New Macbook, transferred hard drive but SQL wont work

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

New Macbook, transferred hard drive but SQL wont work

Postby ScoobieDooo » Fri Jun 03, 2011 4:46 pm

about a month ago i got a new macbook pro and had my entire hard drive transferred over to it. everything else works fine, its like the same identical computer. when i tried to open PT3 for the first time though i get this:

configure postgreSQL database:

server: localhost
user: postgres
port: 5432
pw: dbpass

i then go to connect and it says: unable to connect. reason: unable to login to database. could not connect to server. no such file or directory Is the server running locally and accepting connections on Unix domain socket

SQL 8.4 is installed in my applications....any help? thanks
ScoobieDooo
 
Posts: 3
Joined: Mon May 19, 2008 10:40 pm

Re: New Macbook, transferred hard drive but SQL wont work

Postby kraada » Fri Jun 03, 2011 5:48 pm

Are you able to start the server via the Start Server link in Applications?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: New Macbook, transferred hard drive but SQL wont work

Postby ScoobieDooo » Fri Jun 03, 2011 6:55 pm

i get:

su: unknown login: postgres
ScoobieDooo
 
Posts: 3
Joined: Mon May 19, 2008 10:40 pm

Re: New Macbook, transferred hard drive but SQL wont work

Postby tarix » Fri Jun 03, 2011 9:47 pm

Try reinstalling PostgreSQL. This will fix the user problem and will not harm your data:

1) Download PostgreSQL 8.4.8-1 (Mac)
2) Double-click the dmg file and it will open up a new finder window.
3) Double-click the installer postgresql-8.4.8-1-osx
4) If you get a warning click open and if you are prompted for your admin password enter it.
5) Click "Next >" about four times, then wait for it to install.
6) Uncheck the "Launch Stack Builder?" at exit checkbox.
7) Click Finish.

If everything completed with no errors you should be able to run PT3 as normal. Note you can reinstall PostgreSQL as much as you want and it will not delete your data as long as you never uninstall first.
tarix
Developer
 
Posts: 3760
Joined: Tue May 20, 2008 2:49 pm

Re: New Macbook, transferred hard drive but SQL wont work

Postby ScoobieDooo » Sat Jun 04, 2011 5:09 am

awesome awesome awesome. works perfectly. yeah i wouldve re-installed myself but wasnt sure if that would mess up the existing data or not. thanks for the help you guys are great.
ScoobieDooo
 
Posts: 3
Joined: Mon May 19, 2008 10:40 pm


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 34 guests

highfalutin