R: Re: [ADMIN] adminpack installation problem

2011-07-06 Thread francescobocca...@libero.it
Thanks Francesco Boccacci >Messaggio originale >Da: fren...@cromwell.co.uk >Data: 06/07/2011 13.29 >A: , >Ogg: Re: [ADMIN] adminpack installation problem > >Hi > >You need to ensure you install into the database you specified as your maintenance database in pgAdmin. > >If you connect t

Re: [ADMIN] adminpack installation problem

2011-07-06 Thread French, Martin
Hi You need to ensure you install into the database you specified as your maintenance database in pgAdmin. If you connect to a database called "live" but use "template1" as your maintenance database, then you will need to install into "template1". psql -U postgres template1 -f /usr/share/post

Re: [ADMIN] Need help in Postgres log shipping replication

2011-07-06 Thread Ray Stell
On Wed, Jul 06, 2011 at 07:34:11PM +0530, Jahnavi Chintakunta wrote: > > > When the standy server is stopped, then the pg_xlog's in the master server > are stagnant. Sorry, I've never seen this before. What is archive_timeout set to? template1=# show archive_timeout; archive_timeout

Re: [ADMIN] Need help in Postgres log shipping replication

2011-07-06 Thread Jahnavi Chintakunta
-Original Message- From: Jahnavi Chintakunta Sent: Wednesday, July 06, 2011 10:03 PM To: 'Ray Stell' Subject: RE: [ADMIN] Need help in Postgres log shipping replication Thanks Ray for the reply. Actually I am testing replication in a test Database & I'm the sole user of that . No conne

Re: [ADMIN] Need help in Postgres log shipping replication

2011-07-06 Thread Ray Stell
On Wed, Jul 06, 2011 at 03:02:22PM +0530, Jahnavi Chintakunta wrote: > > But these files are getting copied continuously and they are not stopping. > > Master is generating pg_xlog files even when there is no activity on the > database. How did you determine there was no activity? Have you que

[ADMIN] Need help in Postgres log shipping replication

2011-07-06 Thread Jahnavi Chintakunta
We are having a huge database and need replication with load balancing for Postgres 9.0 We have chose Log shipping method for replication and trying out that approach. Based on the method given for Log shipping, I have configured the following On Master server the following parameters are set

[ADMIN] ossp-uuid (8.4) for FreeBSD

2011-07-06 Thread Matej Serc
Hi, I am trying to install ossp-uuid for PGSQL in FreeBSD 7.2 but having problems getting it to work on 8.4 - I got it working with server version 8.3 and uuid-freebsd (http://pgfoundry.org/projects/uuid-freebsd/). When I install postgresql84-contrib I get errors when I enable it, but when using u

[ADMIN] adminpack installation problem

2011-07-06 Thread francescobocca...@libero.it
Dear all, i have a question for you. I'd like to install adminpack functionality to my pgadminIII. I use pgaminIII v1.10 and with it i connect to my server where i installed a cluster of database. I read some documentations but i don't understand how can install the package. I found in my serve