pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedBackup of database
6+ messages / 5 participants
[nested] [flat]
* Backup of database
@ 2013-11-26 16:28 joka veera Venkataramana <ramanajvv@gmail.com>
0 siblings, 3 replies; 6+ messages in thread
From: joka veera Venkataramana @ 2013-11-26 16:28 UTC (permalink / raw)
To: pgsql-admin
Hi,
We have Postgresql server on Linux environment and have one database.
Now we are planning to take the dump of database with pg_dump utility.
To use pg_dump utility do I need to install Pgadmin on Linux environment?
If yes, do we need to install Pgadmin with root user? because Postgre
server instance we have installed with different user (not root user).
We are planning to take daily database dump in tar file format, so that it
can occupy less space. Can you please provide the complete pg_dump and
restore command for tar file format.
I know all my questions are basic, why we are asking here is previously we
were in DB2 now we moved our database to Postgre (Its new for us). Please
help us.
Thanks,
Veera.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Backup of database
@ 2013-11-26 16:53 Andrew Krause <andrew.krause@breakthroughfuel.com>
parent: joka veera Venkataramana <ramanajvv@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: Andrew Krause @ 2013-11-26 16:53 UTC (permalink / raw)
To: joka veera Venkataramana <ramanajvv@gmail.com>; +Cc: pgsql-admin; pgsql-admin
I highly recommend that you review the page in the PostgreSQL documentation for pg_dump before proceeding. If this is new to you, this page has all the information you should need to get started (including examples at the bottom).
http://www.postgresql.org/docs/9.2/static/app-pgdump.html
You don't need pgadmin on any of your server machines. It's really just a nice to have GUI client for the database. I recommend using psql if you're connecting with a shell.
On Nov 26, 2013, at 10:28 AM, joka veera Venkataramana <ramanajvv@gmail.com>
wrote:
> Hi,
>
> We have Postgresql server on Linux environment and have one database.
> Now we are planning to take the dump of database with pg_dump utility.
>
> To use pg_dump utility do I need to install Pgadmin on Linux environment?
>
> If yes, do we need to install Pgadmin with root user? because Postgre server instance we have installed with different user (not root user).
>
> We are planning to take daily database dump in tar file format, so that it can occupy less space. Can you please provide the complete pg_dump and restore command for tar file format.
>
>
> I know all my questions are basic, why we are asking here is previously we were in DB2 now we moved our database to Postgre (Its new for us). Please help us.
>
> Thanks,
> Veera.
>
>
>
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Backup of database
@ 2013-11-26 16:56 Scott Ribe <scott_ribe@elevated-dev.com>
parent: joka veera Venkataramana <ramanajvv@gmail.com>
2 siblings, 1 reply; 6+ messages in thread
From: Scott Ribe @ 2013-11-26 16:56 UTC (permalink / raw)
To: joka veera Venkataramana <ramanajvv@gmail.com>; +Cc: pgsql-admin
On Nov 26, 2013, at 9:28 AM, joka veera Venkataramana <ramanajvv@gmail.com> wrote:
> I know all my questions are basic, why we are asking here is previously we were in DB2 now we moved our database to Postgre (Its new for us). Please help us.
<http://www.postgresql.org/docs/9.3/interactive/backup.html;
Personally, for daily backups, I like pg_dumpall | bzip2.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Backup of database
@ 2013-11-26 16:58 Payal Singh <payal@omniti.com>
parent: joka veera Venkataramana <ramanajvv@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: Payal Singh @ 2013-11-26 16:58 UTC (permalink / raw)
To: joka veera Venkataramana <ramanajvv@gmail.com>; +Cc: pgsql-admin
You don't need to install anything for using pg_dump. You can find this
command within postgres bin directory, along with psql and other commands.
A simple pg_dump backup command would look like:
/opt/pgsql/bin/pg_dump -Ft db_name > $FILE
Where $FILE is the name of the backup file you will set. '-F' sets the dump
format, and 't' stands for tar
More info can be found in the documentation at
http://www.postgresql.org/docs/9.2/static/app-pgdump.html
Payal Singh,
OmniTi Computer Consulting Inc.
Junior Database Architect,
Phone: 240.646.0770 x 253
On Tue, Nov 26, 2013 at 11:28 AM, joka veera Venkataramana <
ramanajvv@gmail.com> wrote:
> Hi,
>
> We have Postgresql server on Linux environment and have one database.
> Now we are planning to take the dump of database with pg_dump utility.
>
> To use pg_dump utility do I need to install Pgadmin on Linux environment?
>
> If yes, do we need to install Pgadmin with root user? because Postgre
> server instance we have installed with different user (not root user).
>
> We are planning to take daily database dump in tar file format, so that it
> can occupy less space. Can you please provide the complete pg_dump and
> restore command for tar file format.
>
>
> I know all my questions are basic, why we are asking here is previously
> we were in DB2 now we moved our database to Postgre (Its new for us).
> Please help us.
>
> Thanks,
> Veera.
>
>
>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Backup of database
@ 2013-11-26 18:32 AJ Weber <aweber@comcast.net>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 1 reply; 6+ messages in thread
From: AJ Weber @ 2013-11-26 18:32 UTC (permalink / raw)
To: pgsql-admin
On 11/26/2013 11:56 AM, Scott Ribe wrote:
> On Nov 26, 2013, at 9:28 AM, joka veera Venkataramana<ramanajvv@gmail.com> wrote:
>
>> I know all my questions are basic, why we are asking here is previously we were in DB2 now we moved our database to Postgre (Its new for us). Please help us.
> <http://www.postgresql.org/docs/9.3/interactive/backup.html;
>
> Personally, for daily backups, I like pg_dumpall | bzip2.
If you're using some kind of rsync or rsnapshot to help with backups,
check-out "gzip --rsyncable". It purports to keep the compressed
archive in a better format for rsync-type (changed-block-only)
transfers, at the expense of not using the most advanced algorithm.
I have a script that dumps my db to a local gz file, and alternates
naming it with a .0 or .1 so I always have the last two backups (and
then those backup/archive files are rsync'ed to another machine).
-AJ
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Backup of database
@ 2013-11-26 20:58 joka veera Venkataramana <ramanajvv@gmail.com>
parent: AJ Weber <aweber@comcast.net>
0 siblings, 0 replies; 6+ messages in thread
From: joka veera Venkataramana @ 2013-11-26 20:58 UTC (permalink / raw)
To: AJ Weber <aweber@comcast.net>; +Cc: pgsql-admin
Thank You All...It Worked
On Tue, Nov 26, 2013 at 1:32 PM, AJ Weber <aweber@comcast.net> wrote:
>
> On 11/26/2013 11:56 AM, Scott Ribe wrote:
>
>> On Nov 26, 2013, at 9:28 AM, joka veera Venkataramana<ramanajvv@gmail.com>
>> wrote:
>>
>> I know all my questions are basic, why we are asking here is previously
>>> we were in DB2 now we moved our database to Postgre (Its new for us).
>>> Please help us.
>>>
>> <http://www.postgresql.org/docs/9.3/interactive/backup.html;
>>
>> Personally, for daily backups, I like pg_dumpall | bzip2.
>>
> If you're using some kind of rsync or rsnapshot to help with backups,
> check-out "gzip --rsyncable". It purports to keep the compressed archive
> in a better format for rsync-type (changed-block-only) transfers, at the
> expense of not using the most advanced algorithm.
>
> I have a script that dumps my db to a local gz file, and alternates naming
> it with a .0 or .1 so I always have the last two backups (and then those
> backup/archive files are rsync'ed to another machine).
>
> -AJ
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2013-11-26 20:58 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-11-26 16:28 Backup of database joka veera Venkataramana <ramanajvv@gmail.com>
2013-11-26 16:53 ` Andrew Krause <andrew.krause@breakthroughfuel.com>
2013-11-26 16:56 ` Scott Ribe <scott_ribe@elevated-dev.com>
2013-11-26 18:32 ` AJ Weber <aweber@comcast.net>
2013-11-26 20:58 ` joka veera Venkataramana <ramanajvv@gmail.com>
2013-11-26 16:58 ` Payal Singh <payal@omniti.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox