Version: 7.3 devel, updated today, 7:00 am warsaw time. Operating System: Linux polpot 2.2.20 #1 Sun Mar 17 11:56:15 UTC 2002 i686 Pentium_III_(Coppermine)
Compiler and libraries: $ ldd work/bin/postmaster | sed 's/^.* => //' | awk '{print $1}' | xargs ls -l lrwxrwxrwx 1 root root 11 lut 26 11:00 /lib/ld-linux.so.2 -> ld-2.2.5.so lrwxrwxrwx 1 root root 17 lut 26 11:00 /lib/libcrypt.so.1 -> libcrypt-2.2.5.so lrwxrwxrwx 1 root root 13 lut 26 11:00 /lib/libc.so.6 -> libc-2.2.5.so lrwxrwxrwx 1 root root 14 lut 26 11:00 /lib/libdl.so.2 -> libdl-2.2.5.so lrwxrwxrwx 1 root root 13 lut 26 11:00 /lib/libm.so.6 -> libm-2.2.5.so lrwxrwxrwx 1 root root 15 lut 26 11:00 /lib/libnsl.so.1 -> libnsl-2.2.5.so lrwxrwxrwx 1 root root 18 lut 21 10:43 /lib/libreadline.so.4 -> libreadline.so.4.2 lrwxrwxrwx 1 root root 18 lut 26 11:00 /lib/libresolv.so.2 -> libresolv-2.2.5.so lrwxrwxrwx 1 root root 15 kwi 17 2001 /lib/libtinfo.so.5 -> libtinfo.so.5.2 lrwxrwxrwx 1 root root 13 kwi 3 10:29 /lib/libz.so.1 -> libz.so.1.1.4 $ rpm -q --queryformat "%{NAME}-%{VERSION}-%{RELEASE} %{VENDOR}\n" glibc gcc ncurses zlib readline glibc-2.2.5-7 PLD gcc-2.95.4-0.20010823.3 PLD ncurses-5.2-27 PLD zlib-1.1.4-2 PLD readline-4.2a-4 PLD database admin username: pgdba problem: after setting pgdba's password using: alter user pgdba with password 'aaa'; or alter user pgdba with encrypted password 'aaa'; and modifying pg_hba.conf to contain: local all all xxx host all all 127.0.0.1 255.255.255.255 xxx where xxx was "password", "crypt" or "md5" - all tested, i couldn't stard postmaster. to start i use this script: $ cat run.sh #!/bin/sh FILEDATE=`/bin/date +"%Y-%m-%d_%H-%M"` LOGDIR="/home/users/pgdba/Logs/" LOGFILE=$LOGDIR"/stderr.log-"$FILEDATE".log" READABLELOG="/home/users/pgdba/stderr.log" DATADIR='/home/users/pgdba/data/' /bin/ln -sf $LOGFILE $READABLELOG pg_ctl start -D "$DATADIR" -w -l "$LOGFILE" $ upon starting it keeps on asking for password; even if the password was 100% correct: $ ./run.sh waiting for postmaster to start....Password: .Password: .Password: logs show this: $ cat stderr.log-2002-04-24_13-15.log FATAL: The database system is starting up LOG: database system was shut down at 2002-04-24 13:15:26 CEST LOG: checkpoint record is at 0/5A5508 LOG: redo record is at 0/5A5508; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 180; next oid: 16844 LOG: database system is ready FATAL: Bad abstime external representation '"depesz' FATAL: Password authentication failed for user "pgdba" LOG: fast shutdown request LOG: shutting down LOG: database system is shut down interesting part is that it wrote only once about authentication for pgdba ... is it a bug or compilation failure? depesz -- hubert depesz lubaczewski http://www.depesz.pl/ ------------------------------------------------------------------------ ... vows are spoken to be broken ... [enjoy the silence] ... words are meaningless and forgettable ... [depeche mode] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html