Thread
-
RE: [HACKERS] VACUUM ANALYZE problem on linux
Dan Gowin <dgowin@avantec.net> — 1999-02-24T19:30:11Z
What user ID are you using? Are you "su"ing over the the postgres user ID. Also, make sure all of the environment variables are exported in the script. PGPORT, PGUSER, etc... D. -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Wednesday, February 24, 1999 1:35 PM To: phd2@earthling.net Cc: PostgreSQL-development Subject: Re: [HACKERS] VACUUM ANALYZE problem on linux Oleg Broytmann <phd@sun.med.ru> writes: > 3. Run postmaster -b -D/usr/local/pgsql/data -o -Fe -S (to detach it) > and run VACUUM ANALYZE - worked > (I took these parameters from script /etc/init.d/postgres) > 4. Run /etc/init.d/postgres start > and run VACUUM ANALYZE - failed, no core file. So there is something different about the environment of your postmaster when it's started by init.d versus when it's started by hand. Now you just have to figure out what. I thought of environment variables, ulimit settings, ownership/permission settings ... but it's not clear why any of these would affect VACUUM in particular yet leave you able to do other stuff successfully. Puzzling. regards, tom lane
-
RE: [HACKERS] VACUUM ANALYZE problem on linux
Oleg Broytmann <phd@sun.med.ru> — 1999-02-25T08:58:08Z
Hello! On Wed, 24 Feb 1999, Dan Gowin wrote: > What user ID are you using? Are you "su"ing over > the the postgres user ID. But of course! > Also, make sure all of the environment variables > are exported in the script. PGPORT, PGUSER, etc... I want to remind you and all who watch the thread: I have the problem on 3 different glibc2 linucies - heavily modified Debain 2.0, newly installed Debain 2.0 and modified RedHat 5.1. I have no problem with sparc-solaris, and I have a report from Tom Lane he has no problem with HP-UX. IWB interesting to test libc5-linux... > D. > > -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: Wednesday, February 24, 1999 1:35 PM > To: phd2@earthling.net > Cc: PostgreSQL-development > Subject: Re: [HACKERS] VACUUM ANALYZE problem on linux > > > Oleg Broytmann <phd@sun.med.ru> writes: > > 3. Run postmaster -b -D/usr/local/pgsql/data -o -Fe -S (to detach it) > > and run VACUUM ANALYZE - worked > > (I took these parameters from script /etc/init.d/postgres) > > 4. Run /etc/init.d/postgres start > > and run VACUUM ANALYZE - failed, no core file. > > So there is something different about the environment of your postmaster > when it's started by init.d versus when it's started by hand. Now you > just have to figure out what. > > I thought of environment variables, ulimit settings, > ownership/permission settings ... but it's not clear why any of these > would affect VACUUM in particular yet leave you able to do other stuff > successfully. Puzzling. > > regards, tom lane > Oleg. ---- Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net Programmers don't die, they just GOSUB without RETURN.