[GENERAL] Dump all in several files

-maxdepth 1 ) do base=`basename "$p"` pg_dump -d -f /var/backup/postgresql/dump_$base $base done -- == | FREDERIC MASSOT | | http://www.juliana-multimedia.com | | mailto:[EMAIL

Re: [GENERAL] Dump all in several files

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 y

Re: [GENERAL] Dump all in several files

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

[GENERAL] Copy of a schema

t in a new database or a new schema. Regards. -- == | FREDERIC MASSOT | | http://www.juliana-multimedia.com | | mailto:[EMAIL PROTECTED] | ===Debian=GNU/Linux===

[GENERAL] To recover data corrupted

personnes avec entrée indépendante (possibilité couchage 1 personne supplémentaire ). Salle d'eau et WC Ouvert toute l'année Do you know how I can recover the data without having to make copy/paste from the binary file? Regards. -- ==

Re: [GENERAL] To recover data corrupted

Jim C. Nasby wrote: On Tue, May 23, 2006 at 01:03:16PM +0200, Frederic Massot wrote: Hi, We have an old waiter Postgresql 6.5.3 which regularly had problem and which crashed. 6.5?! Holy cow, you win the prize for oldest version I've seen. We have of another server with Postgresq