[ADMIN] Why am I getting a "cursor already in use" error?

Hi, I am trying to create a PL/PGSQL stored proc in PostgreSQL 7.3.2 on Mandrake 9.1. I keep getting a "cursor already in use" error even though I only open the cursor once, fetch using that cursor, and then close the cursor when I am finished with it. Why is this happening? I have pasted the

Re: [ADMIN] Replicate PostgreSQL with rsync

Jérôme Kestener wrote: Hello I am trying to replicate a PostgreSQL database with rsync. Does anyone have a experience with that? No I don't have, but is not a good idea. if you not stop the service during the mirror Regards Gaetano Mendola ---(end of broadcast)-

[ADMIN] Replicate PostgreSQL with rsync

Hello I am trying to replicate a PostgreSQL database with rsync. Does anyone have a experience with that?   Thanks   Jérôme KestenerJérôme Kestener4 rue de l'EuropeSierck les BainsTél : 00333 82.83.72.35GSM: 00336 03.16.86.95Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Testez

[ADMIN] using vacuumdb in crontab

Sorry if this is a naive question. I'm using postgresql 7.2 on Linux with password authentication. I wish to issue a vaccumdb command every night via crontab. The problem is that vacuumdb always prompts for a password. How can I pass the password to vacuumdb without having to manually type it?

Re: [ADMIN] using vacuumdb in crontab

Cris Carampa wrote: Sorry if this is a naive question. I'm using postgresql 7.2 on Linux with password authentication. I wish to issue a vaccumdb command every night via crontab. The problem is that vacuumdb always prompts for a password. How can I pass the password to vacuumdb without having t

[ADMIN] Oracle -> Postgres migration stories

Hi all, I must convince all the managment to convert all Oracle databases to postgres, do you have some stories like the red sheriff one: http://www.redsheriff.com/us/news/news_4_201.html Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Ha

Re: [ADMIN] pg_restore and FK constraints with large dbs

--- Bruce Momjian <[EMAIL PROTECTED]> wrote: > ow wrote: > > > > --- Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > > > > Yep, we want to do something, but not sure what. We have: > > > > > > * Allow triggers to be disabled [trigger] > > > I think the following should be added to the "Allo

Re: [ADMIN] pg_restore and FK constraints with large dbs

ow wrote: > > --- Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > > Yep, we want to do something, but not sure what. We have: > > > > * Allow triggers to be disabled [trigger] > > > > Will ppl remember some time from now that it also deals with FK constraints and > pg_restore/dump options?

Re: [ADMIN] [GENERAL] Point-in-time data recovery - v.7.4

On Tue, Nov 18, 2003 at 03:01:15PM +0100, Rafael Martinez Guerrero wrote: > References in mailinglists talk about version 7.4 and in the TODO list > is under the section 'urgent'. It didn't get done. > Anybody knows when this functionality will be available with > prod-quality? I don't think so.

Re: [ADMIN] Point-in-time data recovery - v.7.4

It was planned for 7.4 but got bumped since the work was not finished. There are patches floating around and people are putting some effort into it, so hopefully we will see something in 7.5, but it is dependent on the code being finished before the end of 7.5 development cycle. If you want to help

Re: [ADMIN] [GENERAL] Point-in-time data recovery - v.7.4

I think it was delayed until 7.5... same for win32 port. Here ir Bruce's message talkin about both topics: http://archives.postgresql.org/pgsql-hackers/2003-07/msg00284.php On Tue, 2003-11-18 at 11:01, Rafael Martinez Guerrero wrote: Hello I am trying to find out when 'Point-in-time data re

[ADMIN] Point-in-time data recovery - v.7.4

Hello I am trying to find out when 'Point-in-time data recovery' functionality will be available with postgreSQL but I can not find concrete info about this. References in mailinglists talk about version 7.4 and in the TODO list is under the section 'urgent'. Anybody knows when this functionalit