SSNL POKER [cheese] thread SEPT

[Unknown Soldier]

why am i so retarted at this stuff??


just d/l pt (formatted my laptop yesterday) i have a backup postgres SQL database how do i put it back on pt?

[thac]

[ QUOTE ]
why am i so retarted at this stuff??


just d/l pt (formatted my laptop yesterday) i have a backup postgres SQL database how do i put it back on pt?

[/ QUOTE ]

File > Maintain Database Names.
Click the Add button.
Click on the right-side dropdown menu.
Select an Existing PostGreSQL Database.
Select the Database.
Click OK.

[Unknown Soldier]

the backup file isnt the right file type [img]/images/graemlins/confused.gif[/img]

[Unknown Soldier]

nvm i think ive found it. thanks again for your help thac! [img]/images/graemlins/smile.gif[/img]

[thac]

Try the ODBC thing on that dropdown menu. What is the file type?

[thac]

Oh, just looked on the PT forums page:


[ QUOTE ]
POSTGRESQL DATABASE USERS

The database files listed above are the Microsoft Access databases. If you are using PostgreSQL databases then you have to backup the database files differently.

To do the backup (on the old computer):

1. Open the Utilities/PostgreSQL Database Functions window.
2. Click the "Backup" button to create a compressed backup file of the selected PostgreSQL database. If you have more than one database, then you must choose each PostgreSQL database from the dropdown list at the top left corner of the window and perform the backup for EACH database. The backup being done is only for the selected database and NOT for all your databases. So if you have created 3 PostgreSQL databases, you need to perform the backup function 3 times, once for each database.

To do the restore (on the new computer):

1. Open the Utilities/PostgreSQL Database Functions window.
2. In the Restore section, use the Browse button to select the backup file you created in the steps above.
3. Click the Restore button. If the database to restore doesn't exist, then the restore option will create the database for you. If the database already exists, the restore option will drop all the data from the database and reimport the data from the backup file.
4. If the database didn't exist and it was created by the restore option, in order to use this database you must now go to the File/Maintain Database Names window, click the Add button and then select "Select existing PostgreSQL database" option from the last field in the new row. Then on the window that opens, select the database that was created by step 3.

[/ QUOTE ]

[Unknown Soldier]

i had to go to postgre SQL database functions, then theres an option there to restore a backup file. The filetype is just .backup or abbreviated to something

[thac]

So it's all better now?

[Unknown Soldier]

hopefully, its still in the process of restoring it. *fingers crossed*

thanks alot for your help!

[thac]

Haha np, nothing else to do when I'm too tired to grind, but too awake to sleep. =)