Error Installing Postgresql on OSx (Macbook Pro latest) using one click installation

Hi,

I am new to Mac and trying to install Postgresql 8.3.6 (latest one click installer) for OS-X, however the installation near the end has a non-fatal error.

Once the installation is over, I am unable to connect using pgAdminIII console to the server using postgres user, I get authentication failed error.

Following information is from the log file.

Script output:
Installing pl/pgsql in the template1 database...
Failed to install pl/pgsql in the 'template1' database
Installing the adminpack module in the postgres database...
Failed to install the 'adminpack' module in the 'postgres' database
/Library/PostgreSQL/8.3/installer/server/loadmodules.sh ran to completion

Script stderr:
psql: FATAL: password authentication failed for user "postgres"
psql: FATAL: password authentication failed for user "postgres"

Error running /Library/PostgreSQL/8.3/installer/server/loadmodules.sh "postgres" "xxxxxxxx" "/Library/PostgreSQL/8.3" 5432 : psql: FATAL: password authentication failed for user "postgres"
psql: FATAL: password authentication failed for user "postgres"
Error running /Library/PostgreSQL/8.3/installer/server/loadmodules.sh "postgres" "xxxxxxxx" "/Library/PostgreSQL/8.3" 5432 : psql: FATAL: password authentication failed for user "postgres"
psql: FATAL: password authentication failed for user "postgres"
Write the data directory to the ini file...
Write the port number, service ID, locale and superuser to the ini file...
Write the server description to the ini file...
Write the server branding to the ini file...
Finished running post-installation/upgrade tasks.
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed
=====================

am I missing something here? Does installer requires something?

Any help is greatly appreciated.

Thanks
Babu

Hi,

I got this issue fixed by installing dev tools on my MacBook Pro and reinstalling Postgresql.
I downloaded iPhone SDK (full) and installed it as it also has xcode dev tools.

Thanks
Babu

Babu_N wrote:Hi,

I got this issue fixed by installing dev tools on my MacBook Pro and reinstalling Postgresql.
I downloaded iPhone SDK (full) and installed it as it also has xcode dev tools.

Thanks
Babu

Hmm, that shouldn't make any difference - we go out of our way not to require any XCode components during installation, and test regularly on machines that have never had them installed.

When you re-ran the installation after installing XCode, had you removed the old installation entirely first? If not, the subsequent installation would have run in upgrade mode, which won't attempt the operations you got the errors from again.

Yes, I had uninstalled previous installation and deleted default data directory. Only thing that I didn't do is to remove postgres user.

Let me know if you want me to try something and/or check some settings on my Mac.

Thanks
Babu

Babu_N wrote:Yes, I had uninstalled previous installation and deleted default data directory. Only thing that I didn't do is to remove postgres user.

Let me know if you want me to try something and/or check some settings on my Mac.

Thanks
Babu

Thanks. I'm not sure there's anything to test now as installing XCode has clearly fixed something. If anyone happens to run into this problem in the future, perhaps they can post before fixing so we can try to figure out what is going wrong exactly.

Regards, Dave.

This message was edited 1 time. Last update was at 10/03/2009 08:41:16

Hi,
I had a similar problem installing Postgres 8.3.6-1.
Installation procedure went ok, except for the same message as Babu_N.

This is my install-postgresql.log:

Log started 03/10/2009 at 10:45:04
Preferred installation mode : osx
Trying to init installer in mode osx
Mode osx successfully initted
Using ini file: /etc/postgres-reg.ini
Existing base directory:
Existing data directory: /Library/PostgreSQL/8.3/data
Using branding: PostgreSQL 8.3
Executing /tmp/postgresql_installer/preinstall.sh
Script exit code: 0

Script output:
Shared memory looks OK (SHMALL: 33554432, SHMMAX: 33554432).

Script stderr:

Executing /tmp/postgresql_installer/getlocales.sh
Script exit code: 0

Script output:
afxxUSxxZA=af_ZA
amxxUSxxET=am_ET
bexxUSxxBY=be_BY
bgxxUSxxBG=bg_BG
caxxUSxxES=ca_ES
csxxUSxxCZ=cs_CZ
daxxUSxxDK=da_DK
dexxUSxxAT=de_AT
dexxUSxxCH=de_CH
dexxUSxxDE=de_DE
elxxUSxxGR=el_GR
enxxUSxxAU=en_AU
enxxUSxxCA=en_CA
enxxUSxxGB=en_GB
enxxUSxxIE=en_IE
enxxUSxxNZ=en_NZ
enxxUSxxUS=en_US
esxxUSxxES=es_ES
etxxUSxxEE=et_EE
euxxUSxxES=eu_ES
fixxUSxxFI=fi_FI
frxxUSxxBE=fr_BE
frxxUSxxCA=fr_CA
frxxUSxxCH=fr_CH
frxxUSxxFR=fr_FR
hexxUSxxIL=he_IL
hrxxUSxxHR=hr_HR
huxxUSxxHU=hu_HU
hyxxUSxxAM=hy_AM
isxxUSxxIS=is_IS
itxxUSxxCH=it_CH
itxxUSxxIT=it_IT
jaxxUSxxJP=ja_JP
jaxxUSxxJPxxDOTxxeucJP=ja_JP.eucJP
kkxxUSxxKZ=kk_KZ
koxxUSxxKR=ko_KR
koxxUSxxKRxxDOTxxeucKR=ko_KR.eucKR
ltxxUSxxLT=lt_LT
nlxxUSxxBE=nl_BE
nlxxUSxxNL=nl_NL
noxxUSxxNO=no_NO
plxxUSxxPL=pl_PL
ptxxUSxxBR=pt_BR
ptxxUSxxPT=pt_PT
roxxUSxxRO=ro_RO
ruxxUSxxRU=ru_RU
skxxUSxxSK=sk_SK
slxxUSxxSI=sl_SI
srxxUSxxYU=sr_YU
svxxUSxxSE=sv_SE
trxxUSxxTR=tr_TR
ukxxUSxxUA=uk_UA
zhxxUSxxCN=zh_CN
zhxxUSxxCNxxDOTxxeucCN=zh_CN.eucCN
zhxxUSxxHK=zh_HK
zhxxUSxxTW=zh_TW
C=C
POSIX=POSIX

Script stderr:

Preparing to Install

** Unpacking operations with no errors **

Running the post-installation/upgrade actions:
Delete the temporary scripts directory...
Write the base directory to the ini file...
Write the version number to the ini file...
Creating service user account...
Executing /Library/PostgreSQL/8.3/installer/server/createuser.sh
Script exit code: 0

Script output:
/Library/PostgreSQL/8.3/installer/server/createuser.sh ran to completion

Script stderr:

Initialising the database cluster (this may take a few minutes)...
Executing /Library/PostgreSQL/8.3/installer/server/initcluster.sh
Script exit code: 0

Script output:
The files belonging to this database system will be owned by user "admin".
This user must also own the server process.

The database cluster will be initialized with locale it_IT.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "italian".

fixing permissions on existing directory /Library/PostgreSQL/8.3/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ... 24MB/153600
creating configuration files ... ok
creating template1 database in /Library/PostgreSQL/8.3/data/base/1 ... ok
initializing pg_authid ... ok
setting password ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

Success. You can now start the database server using:

/Library/PostgreSQL/8.3/bin/postgres -D /Library/PostgreSQL/8.3/data
or
/Library/PostgreSQL/8.3/bin/pg_ctl -D /Library/PostgreSQL/8.3/data -l logfile start

/Library/PostgreSQL/8.3/installer/server/initcluster.sh ran to completion

Script stderr:

Configuring database server startup...
Executing /Library/PostgreSQL/8.3/installer/server/startupcfg.sh
Script exit code: 0

Script output:
/Library/PostgreSQL/8.3/installer/server/startupcfg.sh ran to completion

Script stderr:

Creating menu shortcuts...
Executing /Library/PostgreSQL/8.3/installer/server/createshortcuts.sh
Script exit code: 0

Script output:
/Library/PostgreSQL/8.3/installer/server/createshortcuts.sh ran to completion

Script stderr:

Starting the database server...
Executing /Library/PostgreSQL/8.3/installer/server/startserver.sh
Script exit code: 0

Script output:
waiting for server to start... done
server started
/Library/PostgreSQL/8.3/installer/server/startserver.sh ran to completion

Script stderr:

Loading additional SQL modules...
Executing /Library/PostgreSQL/8.3/installer/server/loadmodules.sh
Script exit code: 2

Script output:
Installing pl/pgsql in the template1 database...
Failed to install pl/pgsql in the 'template1' database
Installing the adminpack module in the postgres database...
Failed to install the 'adminpack' module in the 'postgres' database
/Library/PostgreSQL/8.3/installer/server/loadmodules.sh ran to completion

Script stderr:
psql: FATAL: password authentication failed for user "xxxxxxxx"
psql: FATAL: password authentication failed for user "xxxxxxxx"

Error running /Library/PostgreSQL/8.3/installer/server/loadmodules.sh "xxxxxxxx" "yyyyyyyy" "/Library/PostgreSQL/8.3" 5432 : psql: FATAL: password authentication failed for user "xxxxxxxx"
psql: FATAL: password authentication failed for user "xxxxxxxx"
Error running /Library/PostgreSQL/8.3/installer/server/loadmodules.sh "xxxxxxxx" "yyyyyyyy" "/Library/PostgreSQL/8.3" 5432 : psql: FATAL: password authentication failed for user "xxxxxxxx"
psql: FATAL: password authentication failed for user "xxxxxxxx"
Write the data directory to the ini file...
Write the port number, service ID, locale and superuser to the ini file...
Write the server description to the ini file...
Write the server branding to the ini file...
Finished running post-installation/upgrade tasks.
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed
Log finished 03/10/2009 at 10:47:51

Is it possible that postmaster doesn't accept connections on localhost?

My system is a MacBook running Mac OS X 10.4.11
Thanks in advance

Vincenzo_C wrote:Hi,
I had a similar problem installing Postgres 8.3.6-1.
Installation procedure went ok, except for the same message as Babu_N.

...

Script stderr:
psql: FATAL: password authentication failed for user "xxxxxxxx"
psql: FATAL: password authentication failed for user "xxxxxxxx"

Error running /Library/PostgreSQL/8.3/installer/server/loadmodules.sh "xxxxxxxx" "yyyyyyyy" "/Library/PostgreSQL/8.3" 5432 : psql: FATAL: password authentication failed for user "xxxxxxxx"
psql: FATAL: password authentication failed for user "xxxxxxxx"
Error running /Library/PostgreSQL/8.3/installer/server/loadmodules.sh "xxxxxxxx" "yyyyyyyy" "/Library/PostgreSQL/8.3" 5432 : psql: FATAL: password authentication failed for user "xxxxxxxx"
psql: FATAL: password authentication failed for user "xxxxxxxx"

Hi,

I don't suppose you have a : or any other punctuation characters in your password do you?

Hi, thank for your reply.

No, password and database names are entirely alphabetical, without numbers or symbols.

Vincenzo_C wrote:Hi, thank for your reply.

No, password and database names are entirely alphabetical, without numbers or symbols.

Very strange. Any chance you have an existing PG server on that machine from another package? Though I'd expect to see other errors in that case, but I don't see what else might be going wrong atm :-(

Ok, I'm trying the n-th time to install it. Maybe I should provide additional information on the machine.

It runs Mac OS X 10.4.11; there are two users: an administrator (named Administrator) and a standard user (named JLP) that I use normally.
Until now I start installer on JLP and I provide Administrator uid and password. Installing process ends with the error that I mentioned previously.

Am I doing something wrong?

P.S.
Obviously Apple SDK and Xcode packages are installed correctly.

Vincenzo_C wrote:Ok, I'm trying the n-th time to install it. Maybe I should provide additional information on the machine.

It runs Mac OS X 10.4.11; there are two users: an administrator (named Administrator) and a standard user (named JLP) that I use normally.
Until now I start installer on JLP and I provide Administrator uid and password. Installing process ends with the error that I mentioned previously.

Am I doing something wrong?

P.S.
Obviously Apple SDK and Xcode packages are installed correctly.

Oh, that's interesting - I wonder if the installer is getting confused by the fact that you authenticate as a different user than you are logged in as. I've seen some wierdness in that area before.

Can you see if it installs OK if you log in using your Administrator account and then run the installer please?

I've tried to install as you indicated (by logging with Administrator user and executing the insaller) but the effect is the same; installation log is identical to the previous one.
I've tried also in another way: after uninstalling and deleting installation folder and the "postgres" user (recreating a "clean" machine), I've launched in Terminal the installer:

sudo /Volumes/PostgreSQL\ 8.3.6-1/postgresql-8.3.6-1-osx.app/Contents/MacOS/installbuilder.sh

but I've reported the same errors.

Hope you can help

Vincenzo_C wrote:I've tried to install as you indicated (by logging with Administrator user and executing the insaller) but the effect is the same; installation log is identical to the previous one.
I've tried also in another way: after uninstalling and deleting installation folder and the "postgres" user (recreating a "clean" machine), I've launched in Terminal the installer:

sudo /Volumes/PostgreSQL\ 8.3.6-1/postgresql-8.3.6-1-osx.app/Contents/MacOS/installbuilder.sh

but I've reported the same errors.

Hope you can help

I just put a clean install of Tiger on an Intel mini, let it update to 10.4.11 with all the latest updates from Apple, and then created a non-privileged user. Installed PostgreSQL as that user, but elevating to an administrator account. The installation went without incident (and without XCode).

I have to admit I'm stumped at what's going on in your case. Are you using any unusual partitioning etc? Case sensitive filesystem, non-standard temp directory?

It also struck me that I don't think I've mentioned that the errors you're seeing aren't really problem as long as you can still log into the server after the installation has finished. You can manually run the failed tasks - just run:

CREATE LANGUAGE plpgsql;

in the template1 database (if you want - it's certainly not required), and execute the SQL script $INSTALLDIR/share/postgresql/contrib/adminpack.sql in the postgres database.

Thanks for your patience, but after retried to install as you indicated I had the same errors.
As you told, the errors generated are not criticals, but I can't in no way to connect with database, with PgAdmin III nor with psql.

I don't know how solve this, except the alternative to install by sources.

If you need more information on machine configuration, feel free to ask.
Thanks anyway for your patience and kindness.

P.S.
What do you mean with "Case sensitive filesystem"?
Mine is the standard HFS+ journaled, so it is case sensitive.

Vincenzo_C wrote:Thanks for your patience, but after retried to install as you indicated I had the same errors.
As you told, the errors generated are not criticals, but I can't in no way to connect with database, with PgAdmin III nor with psql.

That sounds pretty critical to me :-(. I was hoping it was just the installer that was having problems.

Vincenzo_C wrote:
I don't know how solve this, except the alternative to install by sources.

If you need more information on machine configuration, feel free to ask.
Thanks anyway for your patience and kindness.

What directory did you install into, and what port number did you choose?

Can you please provide the output from the following commands?

ps -ef
netstat -a

Vincenzo_C wrote:
P.S.
What do you mean with "Case sensitive filesystem"?
Mine is the standard HFS+ journaled, so it is case sensitive.

A default installation of OS X has a case *insensitive* HFS+ filesystem, but it is possible to make it case sensitive (though I don't know how offhand, but have run into people that have done so). E.g. on my laptop:

gator:~ dpage$ ls -al foo
ls: foo: No such file or directory
gator:~ dpage$ ls -al FOO
ls: FOO: No such file or directory
gator:~ dpage$ mkdir foo
gator:~ dpage$ cd FOO
gator:FOO dpage$ pwd