postgres2 does not exist

[marchayton]

I am getting this message when I try to open the "PostgreSQL Database Function"

[ptrack pat]

Why did you enter "postgres2" as the user name on the Utilities > PostgreSQL Settings window? The default user when you install PostgreSQL is "postgres". Please give more details about your setup that you have provided here.

[marchayton]

I got a message saying I couldn't use postgres

[ptrack pat]

According to your other post you were going to use the same setup that was used for PT3 so you shouldn't have had to install PostgreSQL again to get this message. So once again, how about providing a detailed explanation of your setup. Did you install 2 versions of PostgreSQL?? Be specific.

[marchayton]

sorry, i have the one that automatically installed with PT3 but haven't used it with PT2 and then I installed the other one "postrequel 8.2.6.2"to use with PT2 so i could restore my old database

[ptrack pat]

Here is what to do.

Go to the Utilities > PostgreSQL Settings window in PT and change the user name to "postgres". Save the changes and close PT2.

Then, go to the Start > Programs > PostgreSQL 8.3 > Configuration Files > Edit pg_hba.conf (<<- yes, I mean PostgreSQL 8.3 here AND NOT 8.2)

At the bottom of this file, change both places where it says "MD5" to "trust" and save the file.

Now, open PT2 again and try to do the conversion again.

[marchayton]

when i change this to trust and then try and save i get the message "cannot create the C:\Program Files\PostgreSQL\8.3\data\pg_hba.conf file. Make sure that the path and file name are correct

[ptrack pat]

Are you using Vista? If so, go to the Start menu select All Programs > PostgreSQL 8.3 > Config Files and then RIGHT-CLICK on the Edit pg_hba.conf option and select 'run as administrator' from the menu. Then make the changes and save.

[marchayton]

now i am getting an error saying unable to connect to PostgreSQL (port#5433)to get list of databases the error was: 101 - SQLSTATA = 08001. (I changed the port originally to 5433 because i coulddn't use it on the default one)

[ptrack pat]

Change the port # on the PostgreSQL Settings window to 5432.