Re: [ADMIN] question about phppgadmin

when I create a user user1 and give this user the permissions on a database db1 (including login privilage), this user can access all databases although it doesn't have the privilges (even after implmenting the revoke command) on the other hand, any user can access the database db1 after

Re: [ADMIN] pg_ident.conf not working?

Joe Brenner skrev 2010-10-16 22.49: Joe Brennerd...@kzsu.stanford.edu wrote: I've noticed a difference in postgresql 8.3 and 9.0.1 that I suspect is a bug. pg_ident.conf isn't working the way it used to. 8 -- snip --- Though I see it is indeed explained where it should be, I just

Re: [ADMIN] replication solution

Simon Riggs ha scritto: On Tue, 2010-08-24 at 15:46 +0200, Silvio Brandani wrote: Hi all, we are looking for a solution to create a replicated database to be used as reporting database with same data of production ( we can accept a lag of some minutes). we already have the Point In Time

[ADMIN] Postgres 8.4 large table partitioning

Anybody out there using Postgres table partition with a Jboss/Hibernate backend?? Looking for some possible ideas? thanks, Maria Wilson NASA/Langley Research Center Hampton, Virginia 23665 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:

Re: [ADMIN] Postgres 8.4 large table partitioning

Hi Maria, Il 18/10/10 16:38, Maria L. Wilson ha scritto: Anybody out there using Postgres table partition with a Jboss/Hibernate backend?? We do, but could you please provide us with more detailed information regarding your specific issues? Thank you. Regards, Gabriele -- Gabriele

[ADMIN] WAL log shipping + Streaming replication PG 9.0 questions

Hi All, I have some questions regarding hot standby + streaming replication (PG 9.0) : what is master/primary server behavior if archive_command fails due to archive directory off line/unavailable? How about standby server behavior if restore command fails due to archive_master

[ADMIN] transaction time and log analysis

Hi Everybody, Two questions: 1. Is there anything I could do to in postgresql.conf file to speed up the time it takes postgres to commit a transaction? 2. Is there anything better than pg_fouine to analyze logs? Thank you, Sincerely, Kasia -- Sent via pgsql-admin mailing list

Re: [ADMIN] Postgres service won't start, doesn't log any errors

Joe Carr wrote on 18.10.2010 23:11: Hello all, I have a windows postgres 9.0.1 installation which doesn't start, and also doesn't log any information. The only evidence that an attempt was made is in the event log with the following pair of messages : 1. Waiting for server startup... 2. Timed

Re: [ADMIN] Postgres service won't start, doesn't log any errors

I would go with the permissions issue. Not all postgres startup problems are logged in pg_log. Go check the Application log: right click on Computer - Manage - Events - Application and look for any errors with PG as a source. It may be connected to the fact that somehow postgres user doesn't have

Re: [ADMIN] WAL log shipping + Streaming replication PG 9.0 questions

On Tue, Oct 19, 2010 at 2:48 AM, Isabella Ghiurea isabella.ghiu...@nrc-cnrc.gc.ca wrote: I have some questions regarding hot standby  + streaming replication (PG 9.0) : what is   master/primary  server  behavior if  archive_command fails  due to  archive  directory off line/unavailable?