"Lee, Mija" writes:
> Again, 5 extra processes. 6939 is one example. I'm not sure what you are
> looking for from this command that is different from ps -ef?
> Update_process_title is turned on.
5 extra processes would be exactly what I'd expect in an 8.3
installation. I don't remember the mag
343 ?S 372:35 /services/8.3.5/bin/postgres -D
/services/pgdata2
350 ?S 262:39 /services/8.3.5/bin/postgres -D
/services/pgdata2
5074 ?S 710:07 /services/8.3.5/bin/postgres -D
/services/pgdata2
6939 ?S 1:35 /services/8.3.5/bin/postgres -D
/services/pgdata2
On Fri, Sep 4, 2009 at 12:17 PM, Lee, Mija wrote:
> I got it once I pointed to the ucb ps per Alvaro's suggestion. Thanks! Here's
> what I see with a ps auwx :
So what does ps ax|grep postgres say?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscri
I got it once I pointed to the ucb ps per Alvaro's suggestion. Thanks! Here's
what I see with a ps auwx :
postgres 343 4.2 16.627789922714952 ?S Aug 13 371:21
/services/8.3.5/bin/postgres -D /services/pgdata2
postgres 8677 0.3 16.727967602735936 ?S Aug 13 895:14
/servic
"Thorne, Francis" writes:
> Information in Log file after database restart
> 01/08/2009 - Next Transaction ID = 1400435363
> 01/09/2009 - Next Transaction ID = 1462025864
> Transaction_ID Wrapwround limit is 214784146 limited by database
> postgres
> Is this normal, I would have thought the tra
2009/9/4 Lee, Mija :
> Hi -
> Thanks for the response.
> I'm on solaris so the ps ax doesn't work for me. I think the equivalent
> is ps -ef which shows:
> postgres 6939 22678 0 15:49:49 ? 1:33
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres 22678 16072 0 Aug 06 ?
Lee, Mija escribió:
> Hi -
> Thanks for the response.
> I'm on solaris so the ps ax doesn't work for me. I think the equivalent
> is ps -ef which shows:
hmm, did you try /usr/ucb/ps?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command
On Fri, Sep 4, 2009 at 10:32 AM, Lee, Mija wrote:
> Hi -
> Thanks for the response.
> I'm on solaris so the ps ax doesn't work for me. I think the equivalent
> is ps -ef which shows:
> postgres 6939 22678 0 15:49:49 ? 1:33
> /services/8.3.5/bin/postgres -D /services/pgdata2
> postgres
Hi -
Thanks for the response.
I'm on solaris so the ps ax doesn't work for me. I think the equivalent
is ps -ef which shows:
postgres 6939 22678 0 15:49:49 ? 1:33
/services/8.3.5/bin/postgres -D /services/pgdata2
postgres 22678 16072 0 Aug 06 ? 5:22
/services/8.3.5/bin/p
"Thorne, Francis" writes:
> Last night I got the error
> Error Relation 41036649 deleted while still in use
This is not particularly surprising in 8.1 --- it has some race
conditions that can result in that type of error if vacuum (or anything
else) tries to open a table just as something else is
I am hoping someone might be able to help ascertain if the nightly
vacuum that we have set up is actually working correctly.
Every evening we run a Vacuum Analyse on the whole database after a
large data import. I am concerned that the vacuum might not be working
correctly but to be honest am co
Hi all,
Any help on the following would be greatly appreciated, every evening
most of the data on our postgres 8.1 install is deleted and then a new
set of data is imported into the database (around 100 million row).
After this takes place we run a Vacuum Analyse on the whole database.
Last nigh
12 matches
Mail list logo
