Re: [ADMIN] [HACKERS] PK not being restored

2009-06-23 Thread Tom Lane
Rajdeep Das writes: > For you reference I will list the four tables and a couple of > functions that has crept in my database’s public schema. These look like you have been restoring an 8.2 or older dump from a database that had contrib/tsearch2 loaded into it. Please see the 8.3 documentation c

[ADMIN] tuning our database by increasing shared buffer

2009-06-23 Thread Barbara Stephenson
Hello, We will be consolidating from 4 databases to 2 and want to make sure that these parameters are the only ones that need changing. Please advise. Current Future = = Ma

Re: [ADMIN] tuning our database by increasing shared buffer

2009-06-23 Thread Tom Lane
Barbara Stephenson writes: > We will be consolidating from 4 databases to 2 and want to make sure that > these parameters are the only ones that need changing. Please advise. > Current Future > =

Re: [ADMIN] tuning our database by increasing shared buffer

2009-06-23 Thread Barbara Stephenson
Thank ypu! Tom Lane wrote: Barbara Stephenson writes: We will be consolidating from 4 databases to 2 and want to make sure that these parameters are the only ones that need changing. Please advise. Current Future =

Re: [ADMIN] WAL archiving and backup TAR

2009-06-23 Thread Jakov Sosic
On Fri, 19 Jun 2009 09:43:28 -0600 torrez wrote: > Hello, > I'm implementing WAL archiving and PITR on my production DB. > I've set up my TAR, WAL archives and pg_xlog all to be store on a > separate disk then my DB. > I'm at the point where i'm running 'Select pg_start_backup('xxx');'. >

Re: [ADMIN] WAL archiving and backup TAR

2009-06-23 Thread Kenneth Marshall
On Tue, Jun 23, 2009 at 10:18:30PM +0200, Jakov Sosic wrote: > On Fri, 19 Jun 2009 09:43:28 -0600 > torrez wrote: > > > Hello, > > I'm implementing WAL archiving and PITR on my production DB. > > I've set up my TAR, WAL archives and pg_xlog all to be store on a > > separate disk then my DB.