Re: Problems invoking psql, was: Re: [ADMIN] Troubles at Startup

2002-11-24 Thread Oliver Elphick
On Sun, 2002-11-24 at 16:18, Hugh Esco wrote: > So it appears that instead of copying the symbolic link, it copied instead > pg_wrapper, renaming it in the new directory as psql. > > >hesco@biko:~$ /usr/lib/postgresql/bin/psql -U hesco template1 > > hangs, and spins the hard drive interminably.

Problems invoking psql, was: Re: [ADMIN] Troubles at Startup

2002-11-24 Thread Hugh Esco
Mr. Elphick: OK. Here is what I got. hesco@biko:~$ ls -al /usr/bin/psql lrwxrwxrwx1 root root 10 Oct 10 16:24 /usr/bin/psql -> pg_wrapper hesco@biko:~$ ls -al /usr/bin/pg_w* -rwxr-xr-x1 root root 6584 Sep 11 04:30 /usr/bin/pg_wrapper hesco@biko:~$ ls -al /usr/

Re: [ADMIN] Troubles at Startup

2002-11-23 Thread Oliver Elphick
On Sat, 2002-11-23 at 15:13, Hugh Esco wrote: > Problem solved! > > When using pg_ctl to make the postmaster see a pg_hba.conf file that had > been edited while the database server was running, I got a message that it > looked for, but did not find, the psql script in the > /usr/lib/postgresql/

Re: [ADMIN] Troubles at Startup

2002-11-23 Thread Hugh Esco
Problem solved! When using pg_ctl to make the postmaster see a pg_hba.conf file that had been edited while the database server was running, I got a message that it looked for, but did not find, the psql script in the /usr/lib/postgresql/bin directory. So I copied this file from /usr/bin (wher

Re: [ADMIN] Troubles at Startup

2002-11-19 Thread Chad R. Larson
At 12:07 PM 11/13/02 , Hugh Esco wrote: Although /etc/init.d/postgresql script is listed in each run level startup script at /etc/rc#.d, for some reason completely beyond me, postmaster must be manually started each time I boot up. Any help getting the database server to automatically start at

Re: [ADMIN] Troubles at Startup

2002-11-14 Thread Hugh Esco
Frankly, I cannot remember. It was before the election that I did it and it has been a very busy few weeks since then. I bookmarked several pg pages in my browsers and suspect that I downloaded and compiled it on my own, instead of using the apt-get utility. Please do send me that script. T

Re: [ADMIN] Troubles at Startup

2002-11-14 Thread Nick Fankhauser
> I'm operating in Debian Woody, with PostgreSQL 7.2. -- Hugh Hugh- Did you install from the Debian package or compile-your-own? We're running 7.2 on Debian 2.4, and the startup/shutdown script that Oliver Elphick created for the Debian package has worked flawlessly for us. If you did your own

Re: [ADMIN] Troubles at Startup

2002-11-14 Thread Hugh Esco
I'm operating in Debian Woody, with postgreSQL 7.2. -- Hugh At 04:19 PM 11/13/02 -0500, you wrote: on linux 7.2, I just type "ntsyv" and check the postgres daemon to start automatically. Don't know about other systems. Hugh Esco wrote: Hello: Although /etc/init.d/postgresql script is listed in

[ADMIN] Troubles at Startup

2002-11-13 Thread Hugh Esco
Hello: Although /etc/init.d/postgresql script is listed in each run level startup script at /etc/rc#.d, for some reason completely beyond me, postmaster must be manually started each time I boot up. Any help getting the database server to automatically start at boot up would be appreciated. T