From: | Dan Gowin <DGowin(at)avantec(dot)net> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, phd2(at)earthling(dot)net |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | RE: [HACKERS] VACUUM ANALYZE problem on linux |
Date: | 1999-02-24 19:30:11 |
Message-ID: | 43A3A1806104D211988500A0C9B576EE7CE36D@avantec_exc.avantec.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, February 24, 1999 1:35 PM
To: phd2(at)earthling(dot)net
Cc: PostgreSQL-development
Subject: Re: [HACKERS] VACUUM ANALYZE problem on linux
Oleg Broytmann <phd(at)sun(dot)med(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-02-24 20:42:15 | OUTER joins |
Previous Message | Tom Lane | 1999-02-24 18:35:05 | Re: [HACKERS] VACUUM ANALYZE problem on linux |