Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Rosser Schwarz
On 4/5/06, Robin Iddon <[EMAIL PROTECTED]> wrote:[-l $LOGFILE] Hope this helps,It did, thanks./rls-- :wq

Re: [ADMIN] pg_stat_activity showing non-existent processes

2006-04-05 Thread Jim Nasby
On Apr 4, 2006, at 1:29 AM, Tom Lane wrote: "Kevin Grittner" <[EMAIL PROTECTED]> writes: It is probably related to something we've been seeing in the PostgreSQL logs on the Windows servers: [2006-04-03 08:28:25.990 ] 2072 FATAL: could not read from statistics collector pipe: No error [20

Re: [ADMIN] Error Handling with COPY command

2006-04-05 Thread Tomeh, Husam
I think that's still on the TODO list. A very useful feature that I've looking forward to as well. http://www.postgresql.org/docs/faqs.TODO.html Husam http://two.fsphost.com/rdbms -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin

Re: [ADMIN] pg_stat_activity showing non-existent processes

2006-04-05 Thread Jim Nasby
On Apr 3, 2006, at 12:52 PM, Tom Lane wrote: "Kevin Grittner" <[EMAIL PROTECTED]> writes: Is there any way to tweak this in favor of more accurate information, even if has a performance cost? We're finding that during normal operations we're not seeing most connections added to the pg_stat_act

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Robin Iddon
Anyone have any suggestions on novel phrases to offer in my incantations for getting this script to do everything I need? You need to add "-l $LOGFILE" where log is wherever you want to write the stderr+stdout from the postmaster to. Then it will return once starting the server. Also, is

[ADMIN] Error Handling with COPY command

2006-04-05 Thread Kevin Keith
I was wondering if anything has been implemented or is in the works in a future version - where when provided setting / flag / max number of errors - the COPY command would not fail on the error and continue loading data. It would then put the data that didn't load due to error in another locat

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Rosser Schwarz
On 4/5/06, Robin Iddon <[EMAIL PROTECTED]> wrote: Andy Shellam wrote:>I have, however, recently developed an interest in rsync but I'm unsure as >to how PG on the standby server would handle a complete rsync'd data>directory. There has just recently been a fairly extensive discussion on this listab

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Marc G. Fournier
On Wed, 5 Apr 2006, Robin Iddon wrote: Marc G. Fournier wrote: I know ppl are using it to do replication, but has anyone documented what is involved in doing so? thanks ... We use linux HA and linux DRBD (~RAID1 mirror between disks across a LAN) to provide a similar replication mechanism

Re: [ADMIN] pg_stat_activity showing non-existent processes

2006-04-05 Thread Lane Van Ingen
Does anyone out there have a Microsoft installation, know how to get the dump(s) desired to diagnose the problems below, know where dumps end up being placed, and know how to interpret dumps? I am willing to try to help solve these problems, but I need some help ... -Original Message- Fro

Re: [ADMIN] log connections to database

2006-04-05 Thread Ben K.
Yup, this is intended and new in 8.1. You need to REVOKE the privileges before being able to drop the role. Thanks. Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Robin Iddon
Andy Shellam wrote: Robin, On my part it's simply the fact that I currently have two servers in different geographical locations - and cost of new hardware is a huge issue. I have, however, recently developed an interest in rsync but I'm unsure as to how PG on the standby server would handle

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Andy Shellam
Robin, On my part it's simply the fact that I currently have two servers in different geographical locations - and cost of new hardware is a huge issue. I have, however, recently developed an interest in rsync but I'm unsure as to how PG on the standby server would handle a complete rsync'd data

Re: [ADMIN] semctl(): Invalid argument

2006-04-05 Thread Koen Martens
FWIW, i've been running two postmasters on the same port on a FreeBSD 6.0-RELENG server, one in the host and one in a jail (this is on a devel server). I don't like running postgresql in a jail anyway, because it involves enabling sysv IPC inside jails, which sort of defeats the entire purpose of h

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Robin Iddon
Marc G. Fournier wrote: I know ppl are using it to do replication, but has anyone documented what is involved in doing so? thanks ... We use linux HA and linux DRBD (~RAID1 mirror between disks across a LAN) to provide a similar replication mechanism that runs "underneath" the database rath