Re: postgresql on Fedora 16

Hi,

On Thu, 2012-02-02 at 22:08 -0500, Kevin Duffy wrote:

> I am attempting to set up Postgresql under Fedora 16.

I believe I need to write a blog post about this soon...1

> And I think I did not do too bad for a first try for a novice.
>
> I am pretty sure I was logged in as root when I ran yum install
> postgresql-server.
> And I also used yum to install pgAdmin.
> Then I followed various postings to set the postgres account password and
> to
> get the /usr/local/pgsql/data directory set up and permissioned correctly.
>
> I have been able to do the following:
> su postgres

This is the main cause of the problems. You would use

su - postgres

That said, there is

/usr/bin/postgresql-setup

which you can use for initdb, or such. It will initdb
to /var/lib/pgsql/data directory, and it will be compatible with the
init script.

> Is it OK that postgresql is in /usr/local/bin?

I'd stick with the RPM layout, which is /usr/bin. RPMs use that
directory.

> I though it should be in /usr/local/pgsql/bin. Least that it was where when I installed postgresql
> years ago.

It was years ago, but now we have the prebuilt packages, which will make
you lives easier.

> And what do I have to do to get postgresql to start auto on start up.

For RPMs, it is

systemctl enable postgresql.service

Then, you can use

systemctl start postgresql.service

to start the service.

-HTH.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz