Re: [ADMIN] Best compressed archive_command on Linux?

2007-04-11 Thread Eduardo J. Ortega
. > > Thanks, > Sean > > ---(end of broadcast)--- > TIP 3: Have you checked our extensive FAQ? > >http://www.postgresql.org/docs/faq -- Eduardo J. Ortega - Linux user #222873 "No fake - I'm a big fan of ko

Re: [ADMIN] WAL files backup

2007-02-15 Thread Eduardo J. Ortega
0 > > LOG: database system was not properly shut down; > > automatic recovery in progress > > LOG: record with zero length at 0/3D54614 > > LOG: redo is not required > > LOG: database system is ready > > LOG: transaction ID wrap limit is 2147484146, > > l

Re: [ADMIN] WAL files backup

2007-02-14 Thread Eduardo J. Ortega
gt; I was told that I would make the database work slower > if I make a WAL file too small, what is your take on > the matter? recomendation? etc? > > thanks a lot! > > > > > --- "Eduardo J. Ortega" <[EMAIL PROTECTED]> > > wrote: > > For what

Re: [ADMIN] WAL files backup

2007-02-12 Thread Eduardo J. Ortega
iate >subscribe-nomail command to [EMAIL PROTECTED] so that your >message can get through to the mailing list cleanly -- Eduardo J. Ortega - Linux user #222873 "No fake - I'm a big fan of konqueror, and I use it for everything." -- Linus Torvalds --

Re: [ADMIN] tabla pg_user Ayuda......

2007-02-09 Thread Eduardo J. Ortega
n listado de codigos x ej y que me > > aparesca la lista numerada > > > > gracias > > > > -----------(fin del mensaje)--- > > TIP 4: No hagas 'kill -9' a postmaster -- Eduardo J. Ortega - Linux user #222873 "

[ADMIN] online tape backup

2007-02-09 Thread Eduardo J. Ortega
dure? Any other approaches to tape backup that do *not* involve using pg_dump (because of database size, dump time and performance issues)? Any help is greatly appreciated. -- Eduardo J. Ortega - Linux user #222873 "No fake - I'm a big fan of konqueror, and I use it for everyt

Re: [ADMIN] Terminating a query that appears to be hung

2007-01-29 Thread Eduardo J. Ortega
---Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Robert D Oden > Sent: Tuesday, 30 January 2007 2:03 AM > To: PgSQL ADMIN > Subject: [ADMIN] Terminating a query that appears to be hung > > Is there a way to terminate a client session w

Re: [ADMIN] Incremental Backup of a particular database

2007-01-17 Thread Eduardo J. Ortega
from > > > > > > using, > > > > > > > copying, altering or disclosing the content of this message. > > > > Please > > > > > > delete it immediately and notify the sender. Newgen Software > > > > Technologies Ltd and / or its subsidiary Compa

Re: [ADMIN] Backup

2006-12-14 Thread Eduardo J. Ortega
xample" > > FWIW, -i in copy won't render a backup useless - only if the file to be > archived has already been archived (in which case it stands a chance > it's the same file anyway as PG rotates/recycles WAL file numbers.) > > Hope this goes some way to he

Re: [ADMIN] Backup

2006-12-13 Thread Eduardo J. Ortega
n serve as a warm standby. What exactly are the complications you > see with WAL archiving? > > --- > Shoaib Mir > EnterpriseDB (www.enterprisedb.com) > > On 12/13/06, Eduardo J. Ortega <[EMAIL PROTECTED]> wrote: > > Hi there: > > > > Are there any

[ADMIN] Backup

2006-12-12 Thread Eduardo J. Ortega
ittle complicated and *very* user-error prone. (Not sure if this is the right place for it, but i really think that PG's developers should consider including a viable backup utility in the next version) thanks. -- Eduardo J. Ortega - Linux user #222873 "No fake - I'm a big fan of