Page 1 of 1

Getting "Default Unable to login to database (postgres)."

PostPosted: Fri Jul 04, 2014 3:26 pm
by HondaKid
I recently migrated to a new hard drive, yesterday PT was working fine on my test for thirty minutes. Today, after a restart I get a pop-up:

Re: Getting "Default Unable to login to database (postgres).

PostPosted: Sat Jul 05, 2014 4:44 am
by WhiteRider
That message suggests that PostgreSQL isn't running, but without knowing your setup it's hard to know why that might be. Do you have PostgreSQL in Applications? Can you start the server manually? If you can, does PT4 work OK now?

Can you tell us exactly what you did to migrate to the new hard drive? For example are you now using the new drive exclusively? Does the old drive still exist in the system? Did you move your entire operating system or just PT4?

Re: Getting "Default Unable to login to database (postgres).

PostPosted: Sat Jul 05, 2014 11:39 am
by HondaKid
WhiteRider wrote:That message suggests that PostgreSQL isn't running, but without knowing your setup it's hard to know why that might be. Do you have PostgreSQL in Applications? Can you start the server manually? If you can, does PT4 work OK now?


I was thinking about this last night, I did do one thing which might explain my issues. Having checked my APPLICATIONS, there is indeed only a file folder for PostgreSQL which has support files within and not the actual application. It appears the actual application PostgreSQL has left the building.

How did this happen? After the original restart, I was signing back into my computer. I now noticed my sign-in page had a new person added to the page, under the name of PostgreSQL. Something that has happened before, and just as before, I signed in under my name and went to SYSTEM PREFS to remove the name PostgreSQL from the list of sign-in names. I saw no need for this name to be there, I am the only user of the computer and like things to be clean and simple.[/quote]

So it appears a re-install of PostgreSQL is in order? If so, what are the steps involved?

Thanks again.

Re: Getting "Default Unable to login to database (postgres).

PostPosted: Sat Jul 05, 2014 2:09 pm
by WhiteRider
The 'postgres' user is necessary for PostgreSQL to work - you can hide the user from your login screen but you cannot remove the user. To reinstall PostgreSQL follow this guide.

Re: Getting "Default Unable to login to database (postgres).

PostPosted: Sat Jul 05, 2014 5:11 pm
by HondaKid
Looks good now after the re-install. I'm leaving well enough alone from here on in. Thanks.

Re: Getting "Default Unable to login to database (postgres).

PostPosted: Sat Jul 05, 2014 5:39 pm
by WhiteRider
That's good to hear - thanks for the update.

Re: Getting "Default Unable to login to database (postgres).

PostPosted: Mon Nov 17, 2014 12:10 pm
by HondaKid
WhiteRider wrote:The 'postgres' user is necessary for PostgreSQL to work - you can hide the user from your login screen but you cannot remove the user. To reinstall PostgreSQL follow this guide.


So how do I "hide the user from your login screen"? Instructions please.

Re: Getting "Default Unable to login to database (postgres).

PostPosted: Mon Nov 17, 2014 3:22 pm
by kraada
Instructions on how to do this can be found here.

highfalutin