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

A special forum dedicated to our PT4 for Mac OS X users

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

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

Postby HondaKid » Fri Jul 04, 2014 3:26 pm

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:
Attachments
skitch.png
HondaKid
 
Posts: 50
Joined: Fri Jan 29, 2010 9:46 pm

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

Postby WhiteRider » Sat Jul 05, 2014 4:44 am

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?
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

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

Postby HondaKid » Sat Jul 05, 2014 11:39 am

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.
HondaKid
 
Posts: 50
Joined: Fri Jan 29, 2010 9:46 pm

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

Postby WhiteRider » Sat Jul 05, 2014 2:09 pm

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.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

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

Postby HondaKid » Sat Jul 05, 2014 5:11 pm

Looks good now after the re-install. I'm leaving well enough alone from here on in. Thanks.
HondaKid
 
Posts: 50
Joined: Fri Jan 29, 2010 9:46 pm

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

Postby WhiteRider » Sat Jul 05, 2014 5:39 pm

That's good to hear - thanks for the update.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

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

Postby HondaKid » Mon Nov 17, 2014 12:10 pm

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.
HondaKid
 
Posts: 50
Joined: Fri Jan 29, 2010 9:46 pm

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

Postby kraada » Mon Nov 17, 2014 3:22 pm

Instructions on how to do this can be found here.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PT4 for macOS

Who is online

Users browsing this forum: No registered users and 16 guests

cron