PT3 database backup?

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

PT3 database backup?

Postby Lateksi » Sun Mar 09, 2008 7:05 pm

does anyone have a pg_dump script/batch file for the beta that I could use?
Lateksi
 
Posts: 5
Joined: Wed Feb 27, 2008 5:57 am

Re: PT3 database backup?

Postby _dave_ » Sun Mar 09, 2008 7:43 pm

you can run "pg_dumpall -U postgres > c:\full_backup.sql" from a console and that *should* get everything.

do "pg_dumpall --help" for a full list of options you should be aware of.

EDIT: here's the documentation http://www.postgresql.org/docs/current/ ... mpall.html
_dave_
 
Posts: 1147
Joined: Sun Dec 09, 2007 6:19 pm

Re: PT3 database backup?

Postby Lateksi » Mon Mar 10, 2008 7:23 am

ah, didn't know about pg_dumpall, cheers
Lateksi
 
Posts: 5
Joined: Wed Feb 27, 2008 5:57 am


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 3 guests