On Mon, 06 Nov 2006, Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2006-11-06 12:26:43 +0100:
On Sun, 05 Nov 2006, CSN wrote:
Anybody know of a script that dumps all databases into
corresponding dump files
I've written this one in bash:
[snip]
This would break if any database
On Sun, 05 Nov 2006, CSN wrote:
Anybody know of a script that dumps all databases into
corresponding dump files
I've written this one in bash:
#
#!/bin/bash
pg_dumpall -g /var/lib/pgsql/backups/globals.sql
for dbname in `psql -qXtc
# [EMAIL PROTECTED] / 2006-11-06 12:26:43 +0100:
On Sun, 05 Nov 2006, CSN wrote:
Anybody know of a script that dumps all databases into
corresponding dump files
I've written this one in bash:
#
#!/bin/bash
pg_dumpall -g
Anybody know of a script that dumps all databases into corresponding dump
files, e.g.
$ ./dump
template0 - template0.sql
template1 - template1.sql
db1 - db1.sql
db2 - db2.sql
...
Also, would this approach add up to equal the output of pg_dumpall, or does
pg_dumpall dump
additional things (if
On 11/6/06, CSN [EMAIL PROTECTED] wrote:
Anybody know of a script that dumps all databases into corresponding dump
files, e.g.
$ ./dump
template0 - template0.sql
template1 - template1.sql
db1 - db1.sql
db2 - db2.sql
...
Also, would this approach add up to equal the output of pg_dumpall, or
CSN [EMAIL PROTECTED] writes:
Also, would this approach add up to equal the output of pg_dumpall, or
does pg_dumpall dump additional things (if so, please describe how
they'd also be dumped)?
You'd be missing roles (user/group definitions) and tablespace
definitions. pg_dump doesn't emit