Обсуждение: 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
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
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@gunduz.org>
Hi,I believe I need to write a blog post about this soon...1
On Thu, 2012-02-02 at 22:08 -0500, Kevin Duffy wrote:
> I am attempting to set up Postgresql under Fedora 16.This is the main cause of the problems. You would use
> 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
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.I'd stick with the RPM layout, which is /usr/bin. RPMs use that
> Is it OK that postgresql is in /usr/local/bin?
directory.It was years ago, but now we have the prebuilt packages, which will make
> I though it should be in /usr/local/pgsql/bin. Least that it was where when I installed postgresql
> years ago.
you lives easier.For RPMs, it is
> And what do I have to do to get postgresql to start auto on start up.
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