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

On Tue, Oct 19, 2010 at 2:48 AM, Isabella Ghiurea 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? Unarchived WAL files continue to ac

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 hav

Re: [ADMIN] transaction time and log analysis

Kasia Tuszynska writes: > 1. Is there anything I could do to in postgresql.conf file to speed up the > time it takes postgres to commit a transaction? If you want the traditional guarantee that "commit" means "your data is safely down on persistent storage", there's not much you can do except bu

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 ou

[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 (pgsql-admin@pos

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

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 out waiting for server startup I've tri

[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 direct

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 Bartoli

[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] 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

Re: [ADMIN] pg_ident.conf not working?

Joe Brenner skrev 2010-10-16 22.49: Joe Brenner 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 kept skimming past it:

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 "