On Mon, 20 Dec 2010, Adrian Klaver wrote:
As I remember it there was more than one version of Postgres on this machine. Are you sure you are using the correct postgres binary? While I am it is there a reason you are not using the system start scripts or pg_ctl:)?
Adrian, There _was_ a library not removed when I removed -8.3.3, but that's been gone a while. This had been running until yesterday when I could not log in to my accounting software that uses postgres as the back end. The reason I don't use /etc/rc.d/rc.postgresql is that it doesn't work. While it supposedly su's to user postgres, it actually does not do so. Ergo, nothing starts. Looking for running postgres processes I find none: [root@salmo ~]# ps ax | grep postgres 17168 pts/2 S+ 0:00 grep postgres And when I try to start the postmaster as user postgres it fails (as reported in my original message): postgres@salmo:/home/rshepard$ LOG: could not open directory "/share/timezone": No such file or directory LOG: could not open directory "/share/timezone": No such file or directory LOG: could not open directory "/share/timezone": No such file or directory LOG: could not open directory "/share/timezone": No such file or directory LOG: could not open directory "/share/timezone": No such file or directory WARNING: could not open directory "/share/timezonesets": No such file or directory HINT: This may indicate an incomplete PostgreSQL installation, or that the file "/bin/postgres" has been moved away from its proper location. FATAL: invalid value for parameter "timezone_abbreviations": "Default" [1]+ Exit 1 postgres -D /usr/local/pgsql/data This has not happened before. Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
