|
|
|
|
|
|
| Author |
Message |
Frederic Massot
*nix forums beginner
Joined: 15 Mar 2005
Posts: 7
|
 Posted: Tue Mar 15, 2005 2:43 pm Post subject:
Dump all in several files
|
|
|
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 of the basebase.
Do you know how I can adapt this script?
If a developer of pg_dumpall reads this post, is it possible to add to
the command pg_dumpall an option to record one database per file?
Regards.
#! /bin/bash
#
for p in $(find /var/lib/postgres/data/base/ -type d -print -mindepth 1
-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:frederic@juliana-multimedia.com |
===========================Debian=GNU/Linux===
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly |
|
| Back to top |
|
 |
Lonni J Friedman
*nix forums beginner
Joined: 03 Mar 2005
Posts: 28
|
| Posted: Tue Mar 15, 2005 2:54 pm Post subject:
Re: Dump all in several files
|
|
|
On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot
<frederic@juliana-multimedia.com> wrote:
| Quote: | 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 of the basebase.
Do you know how I can adapt this script?
If a developer of pg_dumpall reads this post, is it possible to add to
the command pg_dumpall an option to record one database per file?
Regards.
#! /bin/bash
#
for p in $(find /var/lib/postgres/data/base/ -type d -print -mindepth 1
-maxdepth 1 )
do
base=`basename "$p"`
pg_dump -d -f /var/backup/postgresql/dump_$base $base
done
|
Maybe i'm just not following you, but why can't you just do:
pg_dump $DBNAME >$DB_NAME
where $DB_NAME is the name of each database on the box?
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org |
|
| Back to top |
|
|
Frederic Massot
*nix forums beginner
Joined: 15 Mar 2005
Posts: 7
|
| Posted: Tue Mar 15, 2005 3:01 pm Post subject:
Re: Dump all in several files
|
|
|
Lonni J Friedman wrote:
| Quote: | On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot
frederic@juliana-multimedia.com> 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't you just do:
pg_dump $DBNAME >$DB_NAME
where $DB_NAME is the name of each database on the box?
|
This script is called in a crontab the every day at 6 o'clock in the
morning.
--
==============================================
| FREDERIC MASSOT |
| http://www.juliana-multimedia.com |
| mailto:frederic@juliana-multimedia.com |
===========================Debian=GNU/Linux===
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster |
|
| Back to top |
|
|
javier wilson
*nix forums beginner
Joined: 01 Mar 2005
Posts: 4
|
| Posted: Tue Mar 15, 2005 3:14 pm Post subject:
Re: Dump all in several files
|
|
|
On Tue, 15 Mar 2005 17:01:39 +0100, Frederic Massot
<frederic@juliana-multimedia.com> wrote:
| Quote: | Lonni J Friedman wrote:
On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot
frederic@juliana-multimedia.com> 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't you just do:
pg_dump $DBNAME >$DB_NAME
where $DB_NAME is the name of each database on the box?
This script is called in a crontab the every day at 6 o'clock in the
morning.
|
i have a /etc/backup/data.pgsql where i list all databases
i want to dump, then a script in /etc/cron.daily reads this file
and call pg_dump:
pg_dump -U postgres $1>$1.dump.sql
javier
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster |
|
| Back to top |
|
|
Alvaro Herrera
*nix forums Guru Wannabe
Joined: 11 Mar 2005
Posts: 174
|
| Posted: Tue Mar 15, 2005 3:15 pm Post subject:
Re: Dump all in several files
|
|
|
On Tue, Mar 15, 2005 at 05:01:39PM +0100, Frederic Massot wrote:
| Quote: | Lonni J Friedman wrote:
On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot
frederic@juliana-multimedia.com> 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't you just do:
pg_dump $DBNAME >$DB_NAME
where $DB_NAME is the name of each database on the box?
This script is called in a crontab the every day at 6 o'clock in the
morning.
|
You can obtain the list of databases for scripting with
psql -tlA | cut -d\| -f1
--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Si quieres ser creativo, aprende el arte de perder el tiempo"
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster |
|
| Back to top |
|
|
javier wilson
*nix forums beginner
Joined: 01 Mar 2005
Posts: 4
|
| Posted: Tue Mar 15, 2005 3:32 pm Post subject:
Re: Dump all in several files
|
|
|
On Tue, 15 Mar 2005 12:15:39 -0400, Alvaro Herrera
<alvherre@dcc.uchile.cl> wrote:
| Quote: | 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
frederic@juliana-multimedia.com> 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't you just do:
pg_dump $DBNAME >$DB_NAME
where $DB_NAME is the name of each database on the box?
This script is called in a crontab the every day at 6 o'clock in the
morning.
You can obtain the list of databases for scripting with
psql -tlA | cut -d\| -f1
|
i didn't know that. very nice. try:
psql -Upostgres -tlA |cut -d\| -f1|xargs -i pg_dump -Upostgres -f
'{}'.dump.sql '{}'
javier
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org) |
|
| Back to top |
|
|
Frederic Massot
*nix forums beginner
Joined: 15 Mar 2005
Posts: 7
|
| Posted: Tue Mar 15, 2005 3:35 pm Post subject:
Re: Dump all in several files
|
|
|
Alvaro Herrera wrote:
| Quote: | 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 !!!  )
Thank you.
--
==============================================
| FREDERIC MASSOT |
| http://www.juliana-multimedia.com |
| mailto:frederic@juliana-multimedia.com |
===========================Debian=GNU/Linux===
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Fri Jan 09, 2009 6:20 am | All times are GMT
|
|
Mortgage Calculator | Western Union Money Order | Hackers | Credit Cards | Adverse Credit Remortgage
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
PostgreSQL
