On Sun, Apr 12, 2009 at 6:08 PM, Kevin Bailey
wrote:
> 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.
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 'postgres' database by default until
8.1 or thereabouts.
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
