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