[NOVICE] backup task target - Mailing list pgsql-novice

From Andrea Bonomelli
Subject [NOVICE] backup task target
Date
Msg-id CAN9Nn1oG_8-shFz1dX0e2V72f=TswveVLw6NATQGFMhV0gxTVA@mail.gmail.com
Whole thread Raw
Responses Re: [SPAM] [NOVICE] backup task target
List pgsql-novice
Hi


How do I know if my full database is being backed up?
I have a script already in place that runs a nightly backup of a database called okay_db that runs this command:
/usr/lib/postgresql/8.4/bin/pg_dump -h 10.11.7.5 --username postgres okay_db --blobs --file ' + db + ' --format=custom --verbose --no-password'


And I created a new database called okay_db2 Using the UI of another Software call DaVinci Resolve


In PGAdmin III, okay_db2 appears to be under the main database called okay_db as well. How do I know which one is getting backed up? The whole database or just one into the server database?

Sorry for the terminology not sure if I'm being clear as this is not my field of expertise
--


Andrea Bonomelli

OKAY STUDIO


+44 207 127 0764


okaystudio.co.uk / twitter facebook


This transmission is confidential and may be privileged.  It is for use by the addressee(s) only. If you are not the addressee or if this email is sent to you in error, please let us know by return to info@okaystudio.co.uk and delete the message from your system.  No contract may be concluded on behalf of Okay Studio email. Okay Studio reserves the right to monitor e-mail communication through its network.

pgsql-novice by date:

Previous
From: Herman Bergwerf
Date:
Subject: [NOVICE] Extend GIN
Next
From: Moreno Andreo
Date:
Subject: Re: [NOVICE] How to configure Microsoft Access to connect to aPostgreSQL database?