Database Back-up and Transfer

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Post a reply

Re: Database Back-up and Transfer

Postby kraada » Mon Aug 23, 2010 9:11 am

You can have it open but you can't have PT3 connected to the database you're trying to restore until the restore is complete. 2 hours for vacuum/analyze of 5k hands is extremely long and makes me worry a bit - but it did finish successfully?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY
Top

Re: Database Back-up and Transfer

Postby twinuno » Mon Aug 23, 2010 6:27 pm

It still has not finsihed restoring. The vacuum didnto fisnh i cancelled it
twinuno
 
Posts: 12
Joined: Fri May 16, 2008 6:41 pm
Top

Re: Database Back-up and Transfer

Postby kraada » Tue Aug 24, 2010 8:34 am

Look in the C:\Program Files\PostgreSQL\8.3\data\pg_log directory at the latest file there - are there errors listed? If so, what to they say?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY
Top
Previous
Post a reply

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 19 guests

cron