Re: BUG #3258: Password fails, RPM installs in wrong directory

"Phil Criley" <pfcriley@pcwright.com> writes:
> We run FC5 on a server. PostgreSQL does not accept passwords when set to
> md5, I deleted version 8.1 and installed the latest, 8.2 from source. That's
> when I discovered that the install script in Fedora's RPM put postgreSQL in
> the /var/lib/pgsql but the default installation from the source puts it in
> /usr/local/pgsql. PostgreSQL apparently is hard coded to look in
> /usr/local/pgsql for its data.

There is no "hard coding" about it; it's just a matter of what -D switch
the postmaster is started with.

> I cannot figure out how to add it as a
> service without using the RPM.

Perhaps you should use the RPM distribution then.

ftp://ftp8.us.postgresql.org/postgresql/binary/v8.2.4/linux/rpms/fedora/

The source distribution is platform-agnostic and does not include a
Fedora-style start script, so unless you are prepared to provide one,
an RPM is a better idea.

            regards, tom lane