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 Mar 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

This message was edited 1 time. Last update was at 17 Mar 2009 14:22:24

Well,
installation directory is /Library/PostgreSQL/8.3/, in /Library/PostgreSQL/8.3/data/ there's db cluster, port number is 5432 and in /Applications/PostgreSQL 8.3/ there are services scripts.

Output of netstat -a:
Active Internet connections (including servers)
Proto Recv-Q Send-Q Local Address Foreign Address (state)
tcp4 0 0 localhost.netinfo-loca localhost.1013 ESTABLISHED
tcp4 0 0 localhost.1013 localhost.netinfo-loca ESTABLISHED
tcp4 0 0 192.168.1.7.49206 83.59.128.7.4662 ESTABLISHED
tcp4 0 0 localhost.netinfo-loca localhost.1015 ESTABLISHED
tcp4 0 0 localhost.1015 localhost.netinfo-loca ESTABLISHED
tcp4 0 0 *.postgresql *.* LISTEN
tcp6 0 0 *.5432 *.* LISTEN
tcp4 0 0 *.23052 *.* LISTEN
tcp4 0 0 192.168.1.7.49158 89.248.172.90.ipsec-ms ESTABLISHED
tcp4 0 0 *.4662 *.* LISTEN
tcp4 0 0 localhost.netinfo-loca localhost.1021 ESTABLISHED
tcp4 0 0 localhost.1021 localhost.netinfo-loca ESTABLISHED
tcp4 0 0 localhost.netinfo-loca *.* LISTEN
udp4 0 0 *.mdns *.*
udp6 0 0 localhost.49157 localhost.49157
udp46 0 0 *.9887 *.*
udp4 0 0 *.rfa *.*
udp4 0 0 *.4665 *.*
udp4 0 0 localhost.49155 localhost.1022
udp4 0 0 localhost.49154 localhost.1022
udp4 0 0 localhost.1022 *.*
udp4 0 0 localhost.49153 localhost.1023
udp4 0 0 localhost.1023 *.*
udp4 0 0 192.168.1.7.ntp *.*
udp6 0 0 fe80:5::21b:63ff.123 *.*
udp4 0 0 localhost.ntp *.*
udp6 0 0 fe80:1::1.123 *.*
udp6 0 0 localhost.123 *.*
udp6 0 0 *.123 *.*
udp4 0 0 *.ntp *.*
udp6 0 0 *.5353 *.*
udp4 0 0 *.mdns *.*
udp4 0 0 localhost.netinfo-loca *.*
udp4 0 0 *.* *.*
Active LOCAL (UNIX) domain sockets
Address Type Recv-Q Send-Q Inode Conn Refs Nextref Addr
2e5acc0 stream 0 0 36b56b4 0 0 0 /tmp/.s.PGSQL.5432
2e5a220 stream 0 0 0 2e5a2a8 0 0 /var/run/mDNSResponder
2e5a2a8 stream 0 0 0 2e5a220 0 0
2e5a6e8 stream 0 0 0 2e5a770 0 0 /var/run/mDNSResponder
2e5a770 stream 0 0 0 2e5a6e8 0 0
2e5a908 stream 0 0 0 2e5a990 0 0
2e5a990 stream 0 0 0 2e5a908 0 0
2e5aa18 stream 0 0 0 2e5aaa0 0 0 /var/run/usbmuxd
2e5aaa0 stream 0 0 0 2e5aa18 0 0
2e5ae58 stream 0 0 0 2e5ac38 0 0 /var/run/mDNSResponder
2e5ac38 stream 0 0 0 2e5ae58 0 0
28f6198 stream 0 0 0 28f6220 0 0 /var/run/mDNSResponder
28f6220 stream 0 0 0 28f6198 0 0
28f62a8 stream 0 0 2dd4f78 0 0 0 /var/run/pppconfd
28f6d48 stream 0 0 0 28f6cc0 0 0
28f6cc0 stream 0 0 0 28f6d48 0 0
28f6908 stream 0 0 0 28f6880 0 0 /var/run/asl_input
28f6880 stream 0 0 0 28f6908 0 0
28f6dd0 stream 0 0 2cfc948 0 0 0 /var/run/mDNSResponder
28f6aa0 stream 0 0 2cccef4 0 0 0 /var/run/asl_input
28f6e58 stream 0 0 2cac840 0 0 0 /var/run/usbmuxd
28f6ee0 stream 0 0 2cac8c4 0 0 0 /var/run/portmap.socket
28f6f68 stream 0 0 2919f78 0 0 0 /var/launchd/0/sock
28f6000 dgram 0 0 0 28f6bb0 0 2e5ad48
2e5a330 dgram 0 0 0 2e5a3b8 2e5a3b8 0
2e5a3b8 dgram 0 0 0 2e5a330 2e5a330 0
2e5a440 dgram 0 0 0 28f64c8 28f64c8 0
28f64c8 dgram 0 0 0 2e5a440 2e5a440 0
2e5a4c8 dgram 0 0 0 2e5a550 2e5a550 0
2e5a550 dgram 0 0 0 2e5a4c8 2e5a4c8 0
2e5a5d8 dgram 0 0 0 2e5a660 2e5a660 0
2e5a660 dgram 0 0 0 2e5a5d8 2e5a5d8 0
2e5a7f8 dgram 0 0 0 2e5a880 2e5a880 0
2e5a880 dgram 0 0 0 2e5a7f8 2e5a7f8 0
2e5ab28 dgram 0 0 0 2e5abb0 2e5abb0 0
2e5abb0 dgram 0 0 0 2e5ab28 2e5ab28 0
2e5ad48 dgram 0 0 0 28f6bb0 0 2e5add0
2e5add0 dgram 0 0 0 28f6bb0 0 2e5af68
2e5af68 dgram 0 0 0 28f6bb0 0 2e5aee0
2e5aee0 dgram 0 0 0 28f6bb0 0 28f6660
28f6088 dgram 0 0 0 28f6110 28f6110 0
28f6110 dgram 0 0 0 28f6088 28f6088 0
28f6660 dgram 0 0 0 28f6bb0 0 28f6440
28f6330 dgram 0 0 0 28f63b8 28f63b8 0
28f63b8 dgram 0 0 0 28f6330 28f6330 0
28f6440 dgram 0 0 0 28f6bb0 0 28f6550
28f6550 dgram 0 0 0 28f6bb0 0 28f66e8
28f65d8 dgram 0 0 0 28f6c38 28f6c38 0
28f6c38 dgram 0 0 0 28f65d8 28f65d8 0
28f66e8 dgram 0 0 0 28f6bb0 0 28f6a18
28f6a18 dgram 0 0 0 28f6bb0 0 28f6770
28f6770 dgram 0 0 0 28f6bb0 0 28f6b28
28f6b28 dgram 0 0 0 28f6bb0 0 0
28f67f8 dgram 0 0 0 28f6990 28f6990 0
28f6990 dgram 0 0 0 28f67f8 28f67f8 0
28f6bb0 dgram 0 0 2cccdec 0 28f6000 0 /var/run/syslog

ps -ef gave me illegal command use.

About filesystem, you've right: is case-sensitive. I didn't know that.

Important: For this try I've upgraded permissions on my main user (named JLPicard) to administrator.

Vincenzo_C wrote:Well,
installation directory is /Library/PostgreSQL/8.3/, in /Library/PostgreSQL/8.3/data/ there's db cluster, port number is 5432 and in /Applications/PostgreSQL 8.3/ there are services scripts.

Output of netstat -a:

ps -ef gave me illegal command use.

About filesystem, you've right: is case-sensitive. I didn't know that.

OK, I reinstalled the mini using a case-sensitive FS, and the install worked fine again.

The output from netstat -a looks as I'd expect.

Please try 'ps -aux'. I forgot that Apple changed the ps options between Tiger and Leopard.

Is this an intel or ppc mac?

Thanks for your patience!

Here it is ps -aux output:

USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
JLPicard 708 7.6 10.4 499020 109020 ?? S 6:37PM 1:15.64 /Applications/Firefox.app/Contents/MacOS
JLPicard 672 2.7 1.8 76916 18656 ?? UNs 6:34PM 0:34.78 /System/Library/Frameworks/CoreServices.
JLPicard 698 1.4 0.9 359024 9748 ?? S 6:36PM 0:02.27 /Applications/Utilities/Terminal.app/Con
windowse 65 1.0 1.8 347544 18896 ?? Rs 6:12PM 0:35.20 /System/Library/Frameworks/ApplicationSe
root 36 0.0 0.0 27252 224 ?? S+ 6:12PM 0:00.00 /usr/libexec/ipfwloggerd
root 38 0.0 0.1 27824 832 ?? Ss 6:12PM 0:00.01 /System/Library/PrivateFrameworks/Dedica
root 39 0.0 0.1 27848 596 ?? Ss 6:12PM 0:00.02 /usr/sbin/KernelEventAgent
root 40 0.0 0.1 28016 1056 ?? Ss 6:12PM 0:00.12 /usr/sbin/mDNSResponder -launchdaemon
root 41 0.0 0.1 27580 580 ?? Ss 6:12PM 0:00.21 /usr/sbin/netinfod -s local
root 42 0.0 0.0 27288 432 ?? Ss 6:12PM 0:00.12 /usr/sbin/syslogd
root 43 0.0 0.0 27528 520 ?? Ss 6:12PM 0:00.01 /usr/sbin/cron
root 44 0.0 0.2 30276 2220 ?? Ss 6:12PM 0:00.75 /usr/sbin/configd
root 45 0.0 0.4 34940 3960 ?? Ss 6:12PM 0:00.30 /usr/sbin/coreaudiod
root 46 0.0 0.1 27804 1180 ?? Ss 6:12PM 0:00.26 /usr/sbin/diskarbitrationd
root 48 0.0 0.1 28324 644 ?? Ss 6:12PM 0:00.02 /usr/sbin/memberd -x
root 49 0.0 0.2 29920 1916 ?? Ss 6:12PM 0:00.19 /usr/sbin/securityd
root 50 0.0 0.0 27864 476 ?? Ss 6:12PM 0:00.11 /usr/sbin/notifyd
root 52 0.0 0.2 32280 2588 ?? Ss 6:12PM 0:00.21 /usr/sbin/DirectoryService
root 53 0.0 0.1 27676 808 ?? Ss 6:12PM 0:00.12 /usr/sbin/distnoted
root 56 0.0 0.0 27252 248 ?? Ss 6:12PM 0:02.42 /usr/sbin/update
root 67 0.0 0.3 39980 2656 ?? S 6:12PM 0:00.16 /usr/sbin/blued
root 69 0.0 1.5 51652 15480 ?? Ss 6:12PM 0:00.82 /System/Library/CoreServices/coreservice
JLPicard 72 0.0 0.6 69412 6040 ?? Ss 6:12PM 0:01.65 /System/Library/Frameworks/ApplicationSe
JLPicard 73 0.0 0.4 341988 4472 ?? Ss 6:12PM 0:00.41 /System/Library/CoreServices/loginwindow
root 96 0.0 0.0 27768 240 ?? Ss 6:12PM 0:00.00 /usr/libexec/crashreporterd
root 139 0.0 0.0 29312 212 ?? Ss 6:12PM 0:00.00 nfsiod -n 4
root 164 0.0 1.0 49868 9968 ?? Ss 6:12PM 0:16.57 /System/Library/Frameworks/CoreServices.
root 168 0.0 0.0 27312 224 ?? Ss 6:12PM 0:00.00 rpc.lockd -w
root 171 0.0 0.1 29720 1212 ?? Ss 6:12PM 0:00.03 /usr/sbin/automount -f -m /Network -nsl
root 179 0.0 0.1 29424 1188 ?? Ss 6:12PM 0:00.03 /usr/sbin/automount -f -m /automount/Ser
JLPicard 186 0.0 0.3 58224 2712 ?? Ss 6:12PM 0:00.37 /System/Library/CoreServices/pbs
JLPicard 194 0.0 0.5 351604 4936 ?? S 6:12PM 0:01.04 /System/Library/CoreServices/Dock.app/Co
JLPicard 195 0.0 0.8 356140 8192 ?? S 6:12PM 0:03.58 /System/Library/CoreServices/SystemUISer
JLPicard 196 0.0 1.6 380980 17284 ?? U 6:12PM 1:18.83 /System/Library/CoreServices/Finder.app/
root 200 0.0 0.0 27740 440 ?? Ss 6:12PM 0:00.15 ntpd -c /private/etc/ntp-restrict.conf -
JLPicard 205 0.0 0.3 342564 3068 ?? S 6:12PM 0:00.13 /Applications/iTunes.app/Contents/Resour
JLPicard 207 0.0 0.4 338760 4144 ?? S 6:12PM 0:00.55 /System/Library/CoreServices/System Even
JLPicard 208 0.0 0.6 363924 6196 ?? S 6:12PM 0:00.18 /Users/JLPicard/Library/Google/GoogleSof
JLPicard 209 0.0 0.4 343160 3820 ?? S 6:12PM 0:00.16 /System/Library/CoreServices/AirPort Bas
JLPicard 210 0.0 0.4 342880 3992 ?? S 6:12PM 0:02.50 /System/Library/PreferencePanes/Universa
nobody 211 0.0 0.1 27632 552 ?? Ss 6:12PM 0:00.01 /System/Library/PrivateFrameworks/Mobile
unknown 632 0.0 0.5 41968 4956 ?? SNs 6:15PM 0:00.14 /System/Library/Frameworks/CoreServices.
JLPicard 647 0.0 1.2 380452 13084 ?? S 6:19PM 0:00.69 /Library/PreferencePanes/Growl.prefPane/
nobody 692 0.0 0.3 41968 3288 ?? SNs 6:35PM 0:00.15 /System/Library/Frameworks/CoreServices.
root 700 0.0 0.1 27576 604 p1 Ss 6:36PM 0:00.02 login -pf JLPicard
JLPicard 701 0.0 0.1 27728 828 p1 S 6:36PM 0:00.03 -bash
security 714 0.0 0.7 335064 7372 ?? S 6:44PM 0:00.63 /System/Library/CoreServices/SecurityAge
admin 722 0.0 0.3 60520 3116 ?? S 6:44PM 0:00.50 /Library/PostgreSQL/8.3/bin/postgres -D
admin 723 0.0 0.3 41656 3168 ?? SNs 6:44PM 0:00.17 /System/Library/Frameworks/CoreServices.
admin 725 0.0 0.0 31848 324 ?? Ss 6:44PM 0:00.01 postgres: logger process
admin 727 0.0 0.1 60520 676 ?? Ss 6:44PM 0:00.03 postgres: writer process
admin 728 0.0 0.0 60520 500 ?? Ss 6:44PM 0:00.02 postgres: wal writer process
admin 729 0.0 0.1 60520 576 ?? Ss 6:44PM 0:00.01 postgres: autovacuum launcher process
admin 730 0.0 0.0 31848 372 ?? Ss 6:44PM 0:00.01 postgres: stats collector process
root 750 0.0 0.1 28776 1292 ?? Ss 6:46PM 0:00.03 /usr/sbin/lookupd
root 759 0.0 0.0 27316 436 p1 R+ 6:47PM 0:00.01 ps -aux
root 1 0.0 0.1 28356 532 ?? S<s 6:12PM 0:00.13 /sbin/launchd
root 28 0.0 0.0 27268 196 ?? Ss 6:12PM 0:00.00 /sbin/dynamic_pager -F /private/var/vm/s
root 32 0.0 0.1 28296 1128 ?? Ss 6:12PM 0:01.54 kextd

The machine is an Intel (Macbook mid 2007)

Vincenzo_C wrote:Here it is ps -aux output:

admin 722 0.0 0.3 60520 3116 ?? S 6:44PM 0:00.50 /Library/PostgreSQL/8.3/bin/postgres -D
admin 723 0.0 0.3 41656 3168 ?? SNs 6:44PM 0:00.17 /System/Library/Frameworks/CoreServices.
admin 725 0.0 0.0 31848 324 ?? Ss 6:44PM 0:00.01 postgres: logger process
admin 727 0.0 0.1 60520 676 ?? Ss 6:44PM 0:00.03 postgres: writer process
admin 728 0.0 0.0 60520 500 ?? Ss 6:44PM 0:00.02 postgres: wal writer process
admin 729 0.0 0.1 60520 576 ?? Ss 6:44PM 0:00.01 postgres: autovacuum launcher process
admin 730 0.0 0.0 31848 372 ?? Ss 6:44PM 0:00.01 postgres: stats collector process

The machine is an Intel (Macbook mid 2007)

Well thats just bizarre - PostgreSQL is running as user 'admin' instead of user 'postgres' which is how the installer sets things up. What's in the file /Library/StartupItems/postgresql-8.3/postgresql-8.3 ?

There are two files: postgresql-8.3 (is a script) and StartupParameters.plist.

Content of the first (postgresql-8.3):

#!/bin/sh

. /etc/rc.common

# Postgres Plus Service script for OS/X

StartService ()
{
ConsoleMessage "Starting PostgreSQL 8.3"
su - postgres -c "/Library/PostgreSQL/8.3/bin/pg_ctl -w start -D \"/Library/PostgreSQL/8.3/data\" -l \"/Library/PostgreSQL/8.3/data/pg_log/startup.log\""

if [ -e "/Library/PostgreSQL/8.3/data/postmaster.pid" ]
then
ConsoleMessage "PostgreSQL 8.3 started successfully"
else
ConsoleMessage "PostgreSQL 8.3 did not start in a timely fashion, please see /Library/PostgreSQL/8.3/data/pg_log/startup.log for details"
fi
}

StopService()
{
ConsoleMessage "Stopping PostgreSQL 8.3"
su - postgres -c "/Library/PostgreSQL/8.3/bin/pg_ctl stop -m fast -w -D \"/Library/PostgreSQL/8.3/data\""
}

RestartService ()
{
StopService
sleep 2
StartService
}

RunService "$1"

Content of second (StartupParameters.plist):

{
Description = "PostgreSQL 8.3";
Provides = ("postgresql-8.3");
Requires = ("Resolver");
Preference = "Late";
Messages =
{
start = "Starting PostgreSQL 8.3";
stop = "Stopping PostgreSQL 8.3";
};
}

Vincenzo_C wrote:
su - postgres -c "/Library/PostgreSQL/8.3/bin/pg_ctl -w start -D \"/Library/PostgreSQL/8.3/data\" -l \"/Library/PostgreSQL/8.3/data/pg_log/startup.log\""

So the important line here is this one above, which starts PostgreSQL under the postgres account. The leaves the question of why the server is starting under the postgres user account but ends up running under the admin account. Can you post the output from the following commands please?

sudo dscl . list /users UniqueID | egrep '(admin|postgres)'
egrep '(admin|postgres)' /etc/passwd

Thanks.

First command:

JLPicard@Mac-X:JLPicard> sudo dscl . list /users UniqueID | egrep '(admin|postgres)'
Password:
admin 502
postgres 502

second command doesn't reply me nothing:

JLPicard@Mac-X:JLPicard> egrep '(admin|postgres)' /etc/passwd
JLPicard@Mac-X:JLPicard>

Vincenzo_C wrote:First command:

JLPicard@Mac-X:JLPicard> sudo dscl . list /users UniqueID | egrep '(admin|postgres)'
Password:
admin 502
postgres 502

Well that explains the confusion between the names - and quite possibly the problem in the installer. Was the admin user created at the same time as the installer was running? Or perhaps there was already a postgres user account on your system from some previous work?

We use some code like the following which should get a unique user ID - it lists all the user accounts and their ids, pulls out the IDs and then sorts them. We then add 1 to the result to generate our user ID.

dscl . list /users uid | awk -F: '{FS=" "; print $2f}' | sort -n | tail -1

What value does that command return?

Assuming the installer normally works OK (it has done for tens of thousands of other users), we can try the installation again. Please uninstall and remove the data directory as you have done previously. Then run

sudo dscl . delete /users/postgres

which should delete the postgres user account. The installer, when re-run, will then recreate the user account and should assign it a unique ID and hoopefully run to completion!!

Nothing, same errors

I did exactly what you said, but I had exactly the same problem.
There's a thing that I forgot to mention: I knew that installer create a user named postgres, so on every uninstall (after removing the /Library/PostgreSQL/ folder) I went in NetInfo and manually delete user postgres user.

User admin is the maintenance user that I mentioned previously, and was created manually after OS installation, so it was pre-existing when I install PostgreSQL the first time.

Command 'dscl . list /users uid | awk -F: '{FS=" "; print $2f}' | sort -n | tail -1' before the last uninstall returned 502. Now it returned the same

Vincenzo_C wrote:Nothing, same errors

I did exactly what you said, but I had exactly the same problem.
There's a thing that I forgot to mention: I knew that installer create a user named postgres, so on every uninstall (after removing the /Library/PostgreSQL/ folder) I went in NetInfo and manually delete user postgres user.

User admin is the maintenance user that I mentioned previously, and was created manually after OS installation, so it was pre-existing when I install PostgreSQL the first time.

Command 'dscl . list /users uid | awk -F: '{FS=" "; print $2f}' | sort -n | tail -1' before the last uninstall returned 502. Now it returned the same

Now I'm even more puzzled. What if you uninstall, then manually create the postgres user (ensuring the ID is unique) before installing? The installer should detect and reuse the existing account.