Обсуждение: postgresql on Fedora 16

Hello All:

I am attempting to set up Postgresql under Fedora 16.
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

start the server with the command:
  /usr/bin/pg_ctl -D /usr/local/pgsql/data -l /tmp/pgsql.log start
this returns:
 could not change directory to "/home/kbd"
 server starting

   createdb testdb 
returns:
   could not change directory to "/home/kbd"

psql testdb
returns: ( again )
   could not change directory to "/home/kbd"

testdb=#  select * from pg_language
returns the expected stuff.

pgAdmin is able to connect to Postgresql. Yipee

OK so what is causing this message:
   could not change directory to "/home/kbd"
   I looked in the log file but it is empty.


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


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

Many thanks for your assistance.

Best Regards

KD

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

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