Tom Lane wrote:
Kevin Bailey writes:
Just looking into an old 7.4 based server and the '\l' command isn't
showing a database called 'postgres' - template0 and template1 are there.
Is this expected on 7.4?
Yes. We didn't start creating a
Hi,
Just looking into an old 7.4 based server and the '\l' command isn't
showing a database called 'postgres' - template0 and template1 are there.
Is this expected on 7.4? I've read the docs and can't see any mention
of this DB. Should this DB exist?
Cheers,
Kevin
--
Sent via pgsql-admi
Currently I feel that the sync script I want is within my capabilities
- the re-init stuff would need investigation and testing. I'll get on
with the script and post up the result. There are parts which others
may find useful.
Here's the script in it's current format. After all the wo
The destination server (we call the Secondary server) only needs to be a
copy of the Primary (live) server.
Well, the easiest solution is just to re-initdb the secondary and load
pg_dumpall output into it.
We're using Debian and have servers on Etch and Lenny.
I've never carried out in
Tom Lane wrote:
Kevin Bailey writes:
Can a whole server be restored over to another server in a single command?
The output of pg_dumpall is really meant to be loaded into an empty
server. Although it has a "--clean" switch, that's got serious
limitations and I wou
How's this for a quick and dirty replication plan?
We need to replicate a PG on one server to another server repeatedly.
The issues coming up relate to:
* Using 'clean' to be able to clean out the data has a problem cos
roles can not be dropped due to dependencies.
* We'd like to use pg_dump
The problem is that we'd like to repeatedly carry out this action - so
existing objects are causing errors.
Maybe there can be a combination? Say, completely dropping all
databases on the receiving server before reloading from the backup file?
Kev
--
Sent via pgsql-admin mailing list (pg
ied with using
psql -l -A -t
So - single command or loop?
And if we're using the loop how do we make sure that the ownership of
everything is OK?
Thanks,
Kevin Bailey
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Tom Lane wrote:
Peter Koczan writes:
On Fri, Apr 10, 2009 at 4:34 AM, Kevin Bailey
wrote:
Just to make thigs more interesting, we have to do this for a version 8.1
server and an older 7.4 server which has blobs in it.
If I remember correctly, pg_dumpall only allows
We're trying to get a script to backup and restore a whole database server.
So far we're looking at something like
for db in `psql -U postgres -At -c 'select datname from pg_database
where not datistemplate' -d template1`; do
pg_dump -U ${PGSQL_USER} -h localhost --blobs --format=c
--file="
Further to an earlier question..
I've tried
pg_dumpall --inserts --clean -h $REMOTE -U admin | psql -U postgres
template1
To extract a whole database from a remote server and to reload it into a
local DB but this produces tons of errors.
ERROR: role "admin" cannot be dropped because some
11 matches
Mail list logo
