More trouble

[Drich33]

Hi, Ive having trouble importing. I was referred to this sticky post below. Unfortunately, The link for Install_PLpgSQL.sql does not have a page. The second link does have a page (with a bunch of words i dont understand) but I do not understand how to install anything with Tools Query. I see two blank spaces but I have no idea what to do. Would it be a better idea for me to just uninstall PostgreSQL and install a new one?

-------------------------------------------

Build 4: Update Outdated Database
by APerfect10 » 01 Feb 2009 14:08
If after upgrading to Build 4 and you receive the PT is configured to import into an outdated Database error then the database update failed because your previous database schema was incorrect.

To resolve the issue, you can either create a new database and reimport all of your processed files or you can follow the steps below to resolve the issue and update your database:


Open PgAdminIII. Start->Programs->PostgreSQL 8.3->PgAdmin III
Double click your "PostgreSQL Database Server" in the left window pane and expand "Databases" by clicking the +
Double click the database which needs updated
On the File menu, click Tools->Query Tool.
Download the following two files:
Install_PLpgSQL.sql
Update_DB_Build4.sql
In the query tool go File->Open then browse to and select "Install_PLpgSQL.sql" then click Query -> Execute. (If this query fails that is fine)
Now go File->Open, browse to and locate "Update_DB_Build4.sql" then click Query->Execute.
Repeat for all databases necessary
Make sure that you run a full "Housekeeping" in PT3 for each database that is updated to ensure optimal performance
Your databases are now updated for Build 4 and you should notice a very large performance boost!

Best regards,

Derek

[WhiteRider]

Try refreshing the first link too - they both work for us (someone else was having trouble with this yesterday but could see the pages when they tried again).

IF you read the instructions carefully they tell you exactly what to do.

If you still can't work it out you can schedule a remote assistance session where someone can logon to your computer with you and directly troubleshoot/resolve the issue.