Page 1 of 1

New Macbook, transferred hard drive but SQL wont work

PostPosted: Fri Jun 03, 2011 4:46 pm
by ScoobieDooo
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

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

PostPosted: Fri Jun 03, 2011 5:48 pm
by kraada
Are you able to start the server via the Start Server link in Applications?

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

PostPosted: Fri Jun 03, 2011 6:55 pm
by ScoobieDooo
i get:

su: unknown login: postgres

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

PostPosted: Fri Jun 03, 2011 9:47 pm
by tarix
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.

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

PostPosted: Sat Jun 04, 2011 5:09 am
by ScoobieDooo
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.

highfalutin