Hello all
Thank you very much for your responses! I realised that the restores were
not working as the databases were not being...backed up!...oops! After I did
the reinstallation of the OS I forgot to give permissions in postgresql for
the user doing the backup in ubuntu! I have fixed this.
I h
On Fri, Aug 7, 2009 at 3:54 PM, Scott Marlowe wrote:
> You're probably better off switching to explicitly backing up
> databases in the custom format and using a single pg_dumpall --globals
> to backup the users accounts and such. That's how I prefer to do it
> and it makes life much easier.
Thi
On Fri, Aug 07, 2009 at 01:54:47PM -0600, Scott Marlowe wrote:
> You're probably better off switching to explicitly backing up
> databases in the custom format and using a single pg_dumpall --globals
> to backup the users accounts and such.
-g
--globals-only
Dump only global objects (roles
On Thu, Aug 6, 2009 at 6:42 AM, sub_woofer wrote:
>
> Hello all
>
> To backup my postgresql data I use the pg_dumpall command which dumps all my
> databases to a .sql file.
>
> If I would like to restore a single database from this file how would I do
> this? Is it possible using PgAdmin - as this
On 06/08/2009 13:42, sub_woofer wrote:
> Hello all
>
> To backup my postgresql data I use the pg_dumpall command which dumps all my
> databases to a .sql file.
>
> If I would like to restore a single database from this file how would I do
> this? Is it possible using PgAdmin - as this only allows
Hello all
To backup my postgresql data I use the pg_dumpall command which dumps all my
databases to a .sql file.
If I would like to restore a single database from this file how would I do
this? Is it possible using PgAdmin - as this only allows us to restore a
database from a .backup file???
Wh