Re: Several problems with installation on FreeBSD - how to reinstall without loosing data

Jon Theil Nielsen <jontheil(at)gmail(dot)com> wrote:

> First error message:

> "postgres[15928]: [29993-1] FATAL:  role "root" does not exist"

When doing what?  Starting the cluster?  If so, what else is
showing in the log at startup?

> Created user "root" with a command like "createuser -sdrP root"
> (not absolutely sure).
>
> After restart, I got the error message:
> "FATAL:  database "root" does not exist"

Same questoins as above.

> Then, from the webmin interface, I created an empty database
> called "root" owned by user "root" using no template.
>
> After restart, I now got the error message:
> "FATAL:  connection to client lost".
>
>
> I don't know if this information is of any use in this context.
> Of course I can provide the content of some of my configuration
> files. I just don't know what to look for.

It would be great if you could provide all non-comment lines in the
postgresql.conf file (stripped of any comments, for readability).

Also, exactly how are you starting (or restarting) the cluster?  It
does seem as though it might be starting under the root OS login,
which is a bad idea.  A service script, when run by root, should
switch to a different user before starting PostgreSQL.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company