Re: [GENERAL] Dump all in several files

2005-03-15 Thread Frederic Massot
Alvaro Herrera wrote: On Tue, Mar 15, 2005 at 05:01:39PM +0100, Frederic Massot wrote: [...] You can obtain the list of databases for scripting with psql -tlA | cut -d\| -f1 Great !!! :o) Thank you. -- == | FREDERIC MASSOT | |

Re: [GENERAL] Dump all in several files

2005-03-15 Thread javier wilson
On Tue, 15 Mar 2005 12:15:39 -0400, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > On Tue, Mar 15, 2005 at 05:01:39PM +0100, Frederic Massot wrote: > > Lonni J Friedman wrote: > > >On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot > > ><[EMAIL PROTECTED]> wrote: > > > > > >>Hi, > > >> > > >>On the P

Re: [GENERAL] Dump all in several files

2005-03-15 Thread javier wilson
On Tue, 15 Mar 2005 17:01:39 +0100, Frederic Massot <[EMAIL PROTECTED]> wrote: > Lonni J Friedman wrote: > > On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot > > <[EMAIL PROTECTED]> wrote: > > > >>Hi, > >> > >>On the PostgreSQL 6.5 server I use this shell script (see below) for the > >>backup al

Re: [GENERAL] Dump all in several files

2005-03-15 Thread Alvaro Herrera
On Tue, Mar 15, 2005 at 05:01:39PM +0100, Frederic Massot wrote: > Lonni J Friedman wrote: > >On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot > ><[EMAIL PROTECTED]> wrote: > > > >>Hi, > >> > >>On the PostgreSQL 6.5 server I use this shell script (see below) for the > >>backup all of the databas

Re: [GENERAL] Dump all in several files

2005-03-15 Thread Frederic Massot
Lonni J Friedman wrote: On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot <[EMAIL PROTECTED]> wrote: Hi, On the PostgreSQL 6.5 server I use this shell script (see below) for the backup all of the database in several files, one file per database. [...] Maybe i'm just not following you, but why can

Re: [GENERAL] Dump all in several files

2005-03-15 Thread Lonni J Friedman
On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot <[EMAIL PROTECTED]> wrote: > Hi, > > On the PostgreSQL 6.5 server I use this shell script (see below) for the > backup all of the database in several files, one file per database. > > With version 7.3 of PostgreSQL (and the following) the data a

[GENERAL] Dump all in several files

2005-03-15 Thread Frederic Massot
Hi, On the PostgreSQL 6.5 server I use this shell script (see below) for the backup all of the database in several files, one file per database. With version 7.3 of PostgreSQL (and the following) the data are not recorded any more in a repertory with the name of the database, but with the OID o