best solution to backup full user databse

Started by Vasiliy G Tolstovalmost 16 years ago5 messagesgeneral
Jump to latest
#1Vasiliy G Tolstov
v.tolstov@selfip.ru

Hello. I'm new with postgresql (before using mysql).
Mysql support to dump all triggers, relations, stored procedures from
specific databse to one file.
How about this in postgresql?

--
Vasiliy G Tolstov <v.tolstov@selfip.ru>
Selfip.Ru

#2Scott Marlowe
scott.marlowe@gmail.com
In reply to: Vasiliy G Tolstov (#1)
Re: best solution to backup full user databse

pg_dump?

On Mon, Apr 19, 2010 at 9:07 AM, Vasiliy G Tolstov <v.tolstov@selfip.ru> wrote:

Hello. I'm new with postgresql (before using mysql).
Mysql support to dump all triggers, relations, stored procedures from
specific databse to one file.
How about this in postgresql?

--
Vasiliy G Tolstov <v.tolstov@selfip.ru>
Selfip.Ru

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
When fascism comes to America, it will be intolerance sold as diversity.

#3Vasiliy G Tolstov
v.tolstov@selfip.ru
In reply to: Scott Marlowe (#2)
Re: best solution to backup full user databse

On Mon, 2010-04-19 at 09:18 -0600, Scott Marlowe wrote:

pg_dump?

Yes. But this tool can dump all domains, triggers, procedures and
functions belongs to specific database ?

On Mon, Apr 19, 2010 at 9:07 AM, Vasiliy G Tolstov <v.tolstov@selfip.ru> wrote:

Hello. I'm new with postgresql (before using mysql).
Mysql support to dump all triggers, relations, stored procedures from
specific databse to one file.
How about this in postgresql?

--
Vasiliy G Tolstov <v.tolstov@selfip.ru>
Selfip.Ru

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Vasiliy G Tolstov <v.tolstov@selfip.ru>
Selfip.Ru

#4Scott Marlowe
scott.marlowe@gmail.com
In reply to: Vasiliy G Tolstov (#3)
Re: best solution to backup full user databse

On Mon, Apr 19, 2010 at 9:34 AM, Vasiliy G Tolstov <v.tolstov@selfip.ru> wrote:

On Mon, 2010-04-19 at 09:18 -0600, Scott Marlowe wrote:

pg_dump?

Yes.  But this tool can dump all domains, triggers, procedures and
functions belongs to specific database ?

Yep. It makes a consistent backup of an entire database.

#5Vasiliy G Tolstov
v.tolstov@selfip.ru
In reply to: Scott Marlowe (#4)
Re: best solution to backup full user databse

On Mon, 2010-04-19 at 09:39 -0600, Scott Marlowe wrote:

On Mon, Apr 19, 2010 at 9:34 AM, Vasiliy G Tolstov <v.tolstov@selfip.ru> wrote:

On Mon, 2010-04-19 at 09:18 -0600, Scott Marlowe wrote:

pg_dump?

Yes. But this tool can dump all domains, triggers, procedures and
functions belongs to specific database ?

Yep. It makes a consistent backup of an entire database.

Thank You!
--
Vasiliy G Tolstov <v.tolstov@selfip.ru>
Selfip.Ru