error postgresSQL

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

Re: error postgresSQL

Postby kraada » Wed Jun 09, 2010 9:59 am

Remove the # from the last line you pasted, save the file, and try again.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: error postgresSQL

Postby mats » Wed Jun 09, 2010 10:10 am

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust


nope,still same.
As you can see i tried to change password to "trust",according to a manual,perhaps something went wrong at that time??
mats
 
Posts: 9
Joined: Tue Jun 08, 2010 7:57 am

Re: error postgresSQL

Postby mats » Wed Jun 09, 2010 10:18 am

just to be exakt,this is what pop up when I try to start pt3


"configure PostgresSQL...

postgr... server information

database pt3 2010..............161301

server localhost user postgres
port 5432 password ......

create cancel

if i press create,another box pops up

"unable to create postre... database
reason,unable to log in to databas (template1) reason server closed to connection unexpectedly, this probably means server terminated abnormally before or whle processing the request"



hpoe that might help
mats
 
Posts: 9
Joined: Tue Jun 08, 2010 7:57 am

Re: error postgresSQL

Postby kraada » Wed Jun 09, 2010 12:08 pm

Right the problem is that PostgreSQL isn't starting so PT3 cannot connect to it. Having it be trust is fine, it just means that the password isn't necessary.

Try running this program then rebooting that may fix things.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: error postgresSQL

Postby mats » Wed Jun 09, 2010 3:07 pm

thank you,it worked.what a relief.
Good work
cheers
mats
mats
 
Posts: 9
Joined: Tue Jun 08, 2010 7:57 am

Previous

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 52 guests

cron