Re: [ADMIN] questions about the configure script for building postgres 9.0.3 from source

2011-02-24 Thread Tom Lane
Stephan Doliov writes: > I trolled the archives as I was having difficulty in building Postgres 9.0.3 > from source. I was running configure with the following options (the pasted > in > text of this I had wrapped in a shell script). I apologize in advance that > setting up the question take

Re: [ADMIN] Error stopping postgresql service

2011-02-24 Thread Lou Picciano
Maalini - On first glance (and not knowing the architecture of your particular 'service'), this looks very explainable on the basis of PostgreSQL being instructed to do a 'graceful' shutdown - while you may have users connected. Depending on how your service 'stop' issues the shutdown comma

[ADMIN] questions about the configure script for building postgres 9.0.3 from source

2011-02-24 Thread Stephan Doliov
Hi, I trolled the archives as I was having difficulty in building Postgres 9.0.3 from source. I was running configure with the following options (the pasted in text of this I had wrapped in a shell script). I apologize in advance that setting up the question takes a bit of context. ./configur

Re: [ADMIN] Error stopping postgresql service

2011-02-24 Thread Devrim GÜNDÜZ
On Thu, 2011-02-24 at 10:20 +0800, Maalini Samuganardan wrote: > [root@edbws01 run]# service postgresql start > Starting postgresql service: [ OK ] > [root@edbws01 run]# service postgresql stop > Stopping postgresql service: [FAILED] Co

Re: [ADMIN] Error stopping postgresql service

2011-02-24 Thread Kevin Grittner
Maalini Samuganardan wrote: > I am getting an error when try to stop the postgresql server. > No problem starting. > > Please find error message below. > > Thank you. > > [root@edbws01 run]# service postgresql status > postmaster is stopped > [root@edbws01 run]# service postgresql start > Sta

[ADMIN] Error stopping postgresql service

2011-02-24 Thread Maalini Samuganardan
Hi, I am getting an error when try to stop the postgresql server. No problem starting. Please find error message below. Thank you. [root@edbws01 run]# service postgresql status postmaster is stopped [root@edbws01 run]# service postgresql start Starting postgresql service:

[ADMIN] Re: [ADMIN] sequence numbers under pg concurrence model

2011-02-24 Thread scorpdaddy
Wicked! Great answer. Thanks. - Reply message - From: "Frank Heikens" Date: Thu, Feb 24, 2011 3:54 pm Subject: [ADMIN] sequence numbers under pg concurrence model To: "scorpda...@hotmail.com" Cc: "pgsql-admin@postgresql.org" Op 24 feb 2011, om 20:49 heeft scorpda...@hotmail.com he

Re: [ADMIN] transaction wraparound

2011-02-24 Thread Scott Mead
On Thu, Feb 24, 2011 at 1:28 PM, Dolafi, Tom wrote: > Hi, > > I am getting database shutdown issues as transaction wraparound limit hits > 99. > > Here is the story... > We recently inherited a system in which a postgresql 8.1.18 server hosts > 700+ databases and growing. Essentially it is h

Re: [ADMIN] sequence numbers under pg concurrence model

2011-02-24 Thread Frank Heikens
Op 24 feb 2011, om 20:49 heeft scorpda...@hotmail.com het volgende geschreven: What is the expected behaviour of sequence numbers under pg concurrence model? From the manual: Important: To avoid blocking concurrent transactions that obtain numbers from the same sequence, a nextval opera

[ADMIN] sequence numbers under pg concurrence model

2011-02-24 Thread scorpdaddy
What is the expected behaviour of sequence numbers under pg concurrence model? E.g.  Uncommitted transaction 1 in progress has inserted 5 tuples into table foo.  Meanwhile uncommitted transaction 2 in progress inserts 100 tuples into table foo.  If the sequence number for the pk started at 1000

[ADMIN] transaction wraparound

2011-02-24 Thread Dolafi, Tom
Hi, I am getting database shutdown issues as transaction wraparound limit hits 99. Here is the story... We recently inherited a system in which a postgresql 8.1.18 server hosts 700+ databases and growing. Essentially it is horizontal partitioning per user, but on a single physical sever.

Re: [ADMIN] PG_update to 9.0.4 in ubuntu lucid 64

2011-02-24 Thread Bruce Momjian
Bernhard Rohrer wrote: > > thanks guys > > It'll be a few days before i can do that, but will come back and report. > Can i use the dump file that pg_upgrade produced? it is there after > all. Yes, you can use the dump file pg_upgrade creates to see the table name producing the error. Also, a

Re: [ADMIN] BLP Model on Postgresql

2011-02-24 Thread H S
--- --- > no read up and no write down policies in BLP model, what sort of queries/ > statements in SQL are read and write!? READ: SELECT WRITE: UPDATE/DELETE Thank you for your considerations, so by the way how about Create, Views, and so on. And Update a / some (s) row or whole table;

Re: [ADMIN] BLP Model on Postgresql

2011-02-24 Thread Vibhor Kumar
On Feb 24, 2011, at 5:29 AM, H S wrote: > no read up and no write down policies in BLP model, what sort of queries/ > statements in SQL are read and write!? READ: SELECT WRITE: UPDATE/DELETE Thanks & Regards, Vibhor -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make cha

Re: [ADMIN] PG_update to 9.0.4 in ubuntu lucid 64

2011-02-24 Thread Bernhard Rohrer
thanks guys It'll be a few days before i can do that, but will come back and report. Can i use the dump file that pg_upgrade produced? it is there after all. thanks B original message- From: "Bruce Momjian" To: "Bruce Momjian" CC: "Bernhard Rohrer" grayl...@