Re: [GENERAL] best solution to backup full user databse

2010-04-19 Thread Vasiliy G Tolstov
On Mon, 2010-04-19 at 09:39 -0600, Scott Marlowe wrote: > On Mon, Apr 19, 2010 at 9:34 AM, Vasiliy G Tolstov > 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 speci

Re: [GENERAL] best solution to backup full user databse

2010-04-19 Thread Scott Marlowe
On Mon, Apr 19, 2010 at 9:34 AM, Vasiliy G Tolstov 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 datab

Re: [GENERAL] best solution to backup full user databse

2010-04-19 Thread Vasiliy G Tolstov
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 > wrote: > > Hello. I'm new with postgresql (before using mysql)

Re: [GENERAL] best solution to backup full user databse

2010-04-19 Thread Scott Marlowe
pg_dump? On Mon, Apr 19, 2010 at 9:07 AM, Vasiliy G Tolstov 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 > Selfip.