Thread: best solution to backup full user databse
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
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.
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
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.
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