Re: postgresql on Fedora 16

Hello:

OK now I do not know what to do.
Is there a simple way to uninstall and do it right?

What is the difference between su postgres and su - postgres?
The - (dash) makes it a login shell?

I am will to star over, if I had a clue.

KD

2012/2/3 Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>

>
> 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
>