t; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [ADMIN] Starting postmaster as a service (newbie)
Date: Thu, 5 Jun 2003 10:12:25 -0400
Hi,
I have got a peculiar problem with my postmaster.I have installed
cyg-ipc and postmaster as services on Windows 2000.
But when I restart the s
On Thu, Jun 05, 2003 at 10:12:25AM -0400, Vinay wrote:
> figured that it is because I have to do the init db everytime this
I don't know anything about the Cyg Win installation, but you _don't_
need to do initdb every time: that creates a new data area.
A
Andrew Sullivan
Hi,
I have got a peculiar problem with my
postmaster.I have installed cyg-ipc and postmaster as services on Windows
2000.
But when I restart the system , the postmaster
doesn't start.I figured that it is because I have to do the init db everytime
this happens. But I have to empty the data
Thanks for the information, I've now put back /etc/rc.d/init.d/postgresql and
updated postgresql.conf.
Gary
On Friday 31 August 2001 7:59 pm, Lamar Owen wrote:
> On Friday 31 August 2001 09:50, Gary Stainburn wrote:
> > The postmaster is probably being started using pg_ctl in
> > /etc/init.d/po
On Friday 31 August 2001 09:55, speedboy wrote:
> [root@b] : cat /etc/rc.d/init.d/postgresql
> su - postgres -c 'exec /usr/local/pgsql/bin/pg_ctl -o -i -D
> That help? :)
While this _does_ work, why not use postgresql.conf for its proper purpose?
The RPM initscript, for security reasons, does
On Friday 31 August 2001 09:50, Gary Stainburn wrote:
> The postmaster is probably being started using pg_ctl in
> /etc/init.d/postgresql.
> Add -o -i to the line, which tells pg_ctl to send the '-i' switch to the
> back-end.
PLEASE don't edit /etc/rc.d/init.d/postgresql. Edit
/var/llib/pgsql/
On 31 Aug 2001, Raquel Vieira wrote:
> Does anyone know how can I start postmaster (at the startup of the
> computer) with the option -i?
The file that is starting postgres is one of these:
/etc/rc.d/init.d/postgresql
/etc/rc.d/init.d/postgres
/etc/rc.d/init.d/postgresd
The last one is the mos
On 31 Aug 2001, Raquel Vieira wrote:
> I'm using Postgres 7.1.2 and I need to use TCP/IP connections, so I
> want to start Postmaster with the option -i.
> The Postmaster is starting allone at the startup of the computer, but
> it initiates by itself, I can't start it with that option. I have to
Raquel-
I believe that by v7.1, this could be placed in the postgresql.conf file.
(Found in /etc/postgresql on our Debian Linux box.) the line to add is:
tcpip_socket = 1
check out this page for details:
http://www.postgresql.org/idocs/index.php?runtime-config.html
It's probably not starting
On Friday 31 August 2001 04:38, Raquel Vieira wrote:
> Does anyone know how can I start postmaster (at the startup of the
> computer) with the option -i?
If this is an RPM installation (which is what it sounds like), edit the file
/var/lib/pgsql/data/postgresql.conf and set the 'tcpip_socket' co
[root@b] : cat /etc/rc.d/init.d/postgresql
#!/bin/sh
#[ -x /tmp/.s.PGSQL.* ] && rm -f /tmp/.s.PGSQL.*
case "$1" in
'start')
su - postgres -c 'exec /usr/local/pgsql/bin/pg_ctl -o -i -D
/home/postgres/data start >> /usr/local/pgsql/errlog 2>&1 &'
;;
'stop')
su - postgres -c 'exec /usr/loc
Hi Raquel,
The postmaster is probably being started using pg_ctl in
/etc/init.d/postgresql.
Add -o -i to the line, which tells pg_ctl to send the '-i' switch to the
back-end.
Gary
On Friday 31 August 2001 9:38 am, Raquel Vieira wrote:
> I'm using Postgres 7.1.2 and I need to use TCP/IP con
I'm using Postgres 7.1.2 and I need to use TCP/IP connections, so I
want to start Postmaster with the option -i.
The Postmaster is starting allone at the startup of the computer, but
it initiates by itself, I can't start it with that option. I have to
stop it and start it again with the option by
run "su - postgres" Then it will export the env variables (which you set in
the .bash_profile file). If you do "su postgres" it may not export.
Raj
Bogdan Paduraru wrote:
> Hello,
> I installed Postgresql 7.0.2 on a Redhat Linux 6.1 and I want now to run
> it, but it seems I have a problem.
> I
Bogdan Paduraru wrote:
>Hello,
>I installed Postgresql 7.0.2 on a Redhat Linux 6.1 and I want now to run
>it, but it seems I have a problem.
>I connected as root on my server.
>After that I do :
>$ su postgres
>$nohup /usr/local/pgsql/data \ >server.log 2>>1 &
>After the second com
Hello,
I installed Postgresql 7.0.2 on a Redhat Linux 6.1 and I want now to run
it, but it seems I have a problem.
I connected as root on my server.
After that I do :
$ su postgres
$nohup /usr/local/pgsql/data \ >server.log 2>>1 &
After the second command I get
bash : server.log: Permission denied
i am trying to debug a locking problem in our database. i currently am
starting postgres using this:
'/usr/bin/postmaster -B 256 -S -D /ssms -i'
i am trying to start it with the debugging option, -d 9, following the
advise of a friend. but i can't get it to start. i have tried:
'/usr/bin/p
man pg_hba.conf
pg_hba.conf is used for access control, it should be located in your
$PGDATA directory.
On Thu, 28 Jan 1999, Gerald Brandt wrote:
> Hi there,
>
> I start my postmaster with the -i option to start with tcp connectivity.
>
> I want to be able to limit who can access my postgres
Hi there,
I start my postmaster with the -i option to start with tcp connectivity.
I want to be able to limit who can access my postgres database, and in
theory, I don't need any connectivity outside of the localhost. But,
without the -i, I can't use pgaccess, or the C library.
How can I limit
19 matches
Mail list logo
