dbTalk Databases Forums  

try run PostgreSql as a service on Freebsd

comp.databases.postgresql comp.databases.postgresql


Discuss try run PostgreSql as a service on Freebsd in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
GvaderTh
 
Posts: n/a

Default try run PostgreSql as a service on Freebsd - 12-03-2006 , 12:29 PM






Hi all.
I have installed Freebsd 6.1 with PostgreSql Server 8.1. I can run
server when I first log, as root user, and after that I log as pgsql
(deamon user for postgres).
Then I execute postmaster -D /usr/local/pgsql/data and server start. But
I must do that for every restart.
How can I start PostgreSql as a service and what must I done that
PostgreSql start automatically after server reboot?
I had edited /etc/rc.conf -
postgresql_enable="YES"
postgresql_data="/usr/local/pgsql/data/"
I find that I have script called postgres in
/usr/local/etc/rc.d/
when I executed after reboot server (PostgreSql is not running)
$ /usr/local/etc/rc.d/postgresql start - I get
The program "postmaster" was found by "/usr/local/bin/pg_ctl"
but was not the same version as pg_ctl.
Check your installation.
What I have to do?

Reply With Quote
  #2  
Old   
Riemer Palstra
 
Posts: n/a

Default Re: try run PostgreSql as a service on Freebsd - 12-03-2006 , 01:37 PM






On 2006-12-03, GvaderTh <gregtech (AT) wp (DOT) pl> wrote:
Quote:
postgresql_enable="YES"
postgresql_data="/usr/local/pgsql/data/"
I find that I have script called postgres in
/usr/local/etc/rc.d/
when I executed after reboot server (PostgreSql is not running)
$ /usr/local/etc/rc.d/postgresql start - I get
The program "postmaster" was found by "/usr/local/bin/pg_ctl"
but was not the same version as pg_ctl.
I'm assuming you've installed these packages via FreeBSD ports. In that
case, your version of postgresql-client (which supplies pg_ctl) is not
the same as the version of postgresql-server (which supplies
postmaster). Upgrade one of both (and its dependancies) to make them
match.

--
Riemer Palstra Amsterdam, The Netherlands
riemer (AT) palstra (DOT) com http://www.palstra.com/


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.