Thread: starting postmaster problems

I have not been able to get the postmaster to start at boot time.  Although I
have the postgres script in /etc/rc.d/init.d and at boot time the words
"starting postgres" are displayed, it still will not work.  I have tried
starting the postmaster as a user, but that will not work either.  I can
however, start postmaster as the postgres super user.  Can someone help me get
the startup at boot time fixed?

Thanks

on my server, this is how i do it :

in etc/rc.d/rc.local :
/bin/su - postgres -c "/home/postgres/runpostgres"

runpostgres :
#!/bin/sh
export LC_CTYPE=koi8-r
export LC_COLLATE=koi8-r
postmaster -i -B 1024 -S -D/usr/local/pgsql/data/ -o '-Fe'


note that i run postgresql 6.
pat

On Fri, 13 Oct 2000, Patrick Coulombe wrote:
> on my server, this is how i do it :
>
> in etc/rc.d/rc.local :
> /bin/su - postgres -c "/home/postgres/runpostgres"
>
> runpostgres :
> #!/bin/sh
> export LC_CTYPE=koi8-r
> export LC_COLLATE=koi8-r
> postmaster -i -B 1024 -S -D/usr/local/pgsql/data/ -o '-Fe'
>
>
> note that i run postgresql 6.
> pat

Well Pat, I tried it this way and still no luck.  I'm beginning to think it
might be some weird Mandrake thing.  I'm going to try that mailing list for
help.  Thanks for trying to help.

Mike

I can get Postgres running by going su postgres, logging in, and then using
psql. However, what I'd like to do is to use the icon in the KDE menu under
Debian, Databases, Postgresql. When I do this from my home directory, the
terminal flashes up and then disappears. What permissions do I have to put in
place to launch Postgres from my own Linux account?

Frank Hilliard

Frank Hilliard wrote:
  >I can get Postgres running by going su postgres, logging in, and then using
  >psql. However, what I'd like to do is to use the icon in the KDE menu under
  >Debian, Databases, Postgresql. When I do this from my home directory, the
  >terminal flashes up and then disappears. What permissions do I have to put i
      >n
  >place to launch Postgres from my own Linux account?

You have to create a PostgreSQL user with the same name as your login id.
Use the SQL command `CREATE USER' or the createuser script.

(NB: Debian questions are better directed first to the Debian lists.)


--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Only take heed to thyself, and keep thy soul
      diligently, lest thou forget the things which thine
      eyes have seen, and lest they depart from thy heart
      all the days of thy life; but teach them to thy sons,
      and to thy sons' sons..."        Deuteronomy 4:9

On Wed, 25 Oct 2000, Oliver Elphick wrote:
> Frank Hilliard wrote:
>   >I can get Postgres running by going su postgres, logging in, and then using
>   >psql. However, what I'd like to do is to use the icon in the KDE menu under
>   >Debian, Databases, Postgresql. When I do this from my home directory, the
>   >terminal flashes up and then disappears. What permissions do I have to put i
>       >n
>   >place to launch Postgres from my own Linux account?
>
When you set up the icon, type su -c postmaster postgres in the execute area of
the properties box and check the run in terminal check box.  When you click on
the icon, a terminal session will start and prompt you for postgres' password.
After typing in the password you can kill the terminal session and use postgres
until you log off.  At least this works on my Mandrake 7.0 box.