Re: Missing Postgres Database

It seems like you have a nightmare to support...

One thing worth noting is that psql tries to log into a database with
the same name as the user running psql, but there is no normal reason
that anyone would have created a database called "postgres" in order
to match the user "postgres". It isn't necessary for normal
functioning at all, though the server wants to run as postgres
usually.

-W

On 10/4/07, Bruce, Tim <tim(dot)bruce(at)fiserv(dot)com> wrote:
> From: Webb Sprague [mailto:webb(dot)sprague(at)gmail(dot)com]
> Sent: Thursday, October 04, 2007 12:54 PM
> To: Bruce, Tim
> Subject: Re: [pdxpug] Missing Postgres Database
>
> >
> > The version is 7.4.2
>
> Why are you using such an old version?
>
> Also - the template databases are the only ones created automatically.
>
> -W
>
> ------
> Webb,
>
> That is one of the things I get to "fix" from the vendor. They also
> installed two different versions of the client utilities in different
> locations (and different accounts have access to one or the other). I'm
> trying to upgrade to a more recently patched version, but I need to
> build a "test" system that I can test my process against and then ensure
> there are no regressions in the vendor supplied code....
>
> Tim
>