Unable to create PostgreSQL database

[Dissident]

I get this error w/ postgre, I tried reinstalling (I remember it gave me an error about something out of date but the error doesn't come up any more when installing)

Unable to create PostgreSQL database: PT3 Beta DB1
Reason: Unable to execute query: CREATE DATABASE "PT3 Beta DB1" WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII'; ALTER DATABASE "PT3 Beta DB1" OWNER TO DissidentDT;; Reason: Fatal Error (ERROR: role "dissidentdt" does not exist )

[APerfect10]

Open "My Computer" and browse to your PostgreSQL bin directory which is typically:

C:\Program Files\PostgreSQL\8.2\bin

Double click pgAdmin3. Once pgAdmin launches, double-click "PostgreSQL Database Server..." on the left hand side.

Expand "Login Roles". What is listed under Login Roles? Select the Login Role listed and tell me what is displayed in the "Properties" tab in the right pane.

Best regards,

Derek

[_dave_]

[quotedhq]OWNER TO DissidentDT[/quotedhq]

arghhhhhhh

[Josh]

[quote="_dave_"d2w][quoted2w]OWNER TO DissidentDT[/quoted2w]

arghhhhhhh [/quoted2w]

[_dave_]

I believe a good number of the postgresql problems would be avoided if people used the default name 'postgres' for the service / super user. At a guess I'd say the postgresql.msi installer is having trouble changing everything to support a different name.

[APerfect10]

[quote="_dave_"qr7]I believe a good number of the postgresql problems would be avoided if people used the default name 'postgres' for the service / super user. At a guess I'd say the postgresql.msi installer is having trouble changing everything to support a different name.[/quoteqr7]

As I mentioned in the other thread.

[Josh]

In the next version, if the user wants to use a service/database user name other than "postgres", they have to run the PostgreSQL installation themselves. PT3 won't allow it to be changed. It is creating too many problems with very little to no benefit.

[_dave_]

[quote="Josh"sm6]In the next version, if the user wants to use a service/database user name other than "postgres", they have to run the PostgreSQL installation themselves. PT3 won't allow it to be changed. It is creating too many problems with very little to no benefit.[/quotesm6]

Excellent.

imo one needs a *very* good reason and enough experience to fix resulting problems if there is a valid reason to use another superuser name.

PT3 must still be able to operate under a non-superuser account of course - but I doubt that will be a problem (or cause as many problems as this).

[Dissident]

I reinstalled w/ the default name and pass. I got the basic localhost error, uninstalled, deleted the folder and ran a command I found on a different thread. I then re-installed with the default name and it works fine. Thanks!

[APerfect10]

[quote="Dissident"ghk]I reinstalled w/ the default name and pass. I got the basic localhost error, uninstalled, deleted the folder and ran a command I found on a different thread. I then re-installed with the default name and it works fine. Thanks![/quoteghk]

Good deal