Re: [ADMIN] WAL segment question

2007-08-03 Thread Decibel!
On Sat, Aug 04, 2007 at 12:00:52AM +0100, Donald Fraser wrote: > Our company has two sites, a master and a disaster recovery site. > I am trying to assess whether data has been lost during a fail-over, due to > the asynchronous method of transporting WAL file data between sites (we use > DRBD). >

Re: [ADMIN] Help

2007-08-03 Thread Decibel!
On Fri, Aug 03, 2007 at 06:57:29PM +0600, ??? ? wrote: > This quotation deals with receiving an inserts pack as 'plain text'. Well, > well, but here we come to another problem: if a database is bulky, it 'does > not want' to be loaded as plain text, and it requires choosing a

Re: [ADMIN] Wal standbies switchover

2007-08-03 Thread Decibel!
On Thu, Aug 02, 2007 at 12:26:47PM +0400, Dimitri Gritsenko wrote: > Goal - having 1 master and 2 standbies - make switchover in the way , that > except minimal downtime - there was always 1 running master and 2 warm > standbies. > > Lets say i have 3 hosts (1,2,3) , 1 master and 2 warm standbies

Re: [ADMIN] incrementals with pg-dump

2007-08-03 Thread Decibel!
On Wed, Aug 01, 2007 at 10:11:01PM -0700, David Bear wrote: > I googled a bit for an incremental or differential way to backup > postgresq. I was hoping there would be switch on pg-dumpall that would > backup all tupples added since some date. Doesn't look like it exists. > > I did find a backup

[ADMIN] WAL segment question

2007-08-03 Thread Donald Fraser
Our company has two sites, a master and a disaster recovery site. I am trying to assess whether data has been lost during a fail-over, due to the asynchronous method of transporting WAL file data between sites (we use DRBD). Disaster recovery node start-up log: user= pid=9907 timestamp=[2007-08-0

[ADMIN] libpq.dll as part of PGDB module: access to PostgreSQL from Python

2007-08-03 Thread ekzept
the module PGDB which gives Python access to PostgreSql currently wants for a copy of a properly located or proper libpq.dll library, on Windows. anyone know what the current story on this is? thanks, -- jt ---(end of broadcast)--- TIP 4: Have y

Re: [ADMIN] pg_catalog.pg_roles DESTROYED?

2007-08-03 Thread Ralph Smith
On Aug 2, 2007, at 5:26 PM, Stephan Szabo wrote: On Thu, 2 Aug 2007, Ralph Smith wrote: I'm preparing to upgrade a 7.4.7 DB to 8.2.4. I just got connectivity from new to old (different hosts), and being a newhire and no-one had ever done any maintenance on the old DB, I connected as joe-user

[ADMIN] Help

2007-08-03 Thread Казорез Александр Олегович
Hi to all, I came across a problem while switching from 8.0 to 8.1.4 (or, now, to 8.2.4). Here it is: QUOTE: Some users are having problems loading UTF-8 data into 8.1.X. This is because previous versions allowed invalid UTF-8 byte sequences to be entered into the database, and this rel

[ADMIN] Reg : Backup job Scheduler...

2007-08-03 Thread Jayakumar_Mukundaraju
Dear All, I did the Backup job schedule in windows through Schedule Task, it is working fine.. The following are the steps.. 1. I created one batch file in my D:\Backup\postgres_backup.bat The contents are.. @echo off rem "c:\Program Files\pgAdmin III\1.7\pg_dump.exe" -i -h