Обсуждение: EnterpriseDB OSX 9.0.2 PostgresPlus Installer
Hello,
Has anyone downloaded and used the OSX 9.0.2 PostgresPlus installer package from EnterpriseDB?
I have done this and having issues trying to edit the postgresql.conf file as well as the pg_hba.conf files using pgAdmin III that it comes with.
I have also tried to edit them trough the terminal and vi, but since pgAdmin offers the ability to edit these files, I would like to do it through there.
Also, how do you shut down and start the server back up?
I am trying: 'pg_ctl -D /Library/PostgresPlus/9.0SS/data/ stop'
but getting:
'waiting for server to shut down............................................................... failed
pg_ctl: server does not shut down'
message. pgAdmin does not enable the 'start and stop' menu choices for me to do it through there either.
i just took a PG Admin class but in there we used Linux and things were much simpler to work with, so I assume that there is some sort or process or method I need to use for this version of PG.
Thanks.
Has anyone downloaded and used the OSX 9.0.2 PostgresPlus installer package from EnterpriseDB?
I have done this and having issues trying to edit the postgresql.conf file as well as the pg_hba.conf files using pgAdmin III that it comes with.
I have also tried to edit them trough the terminal and vi, but since pgAdmin offers the ability to edit these files, I would like to do it through there.
Also, how do you shut down and start the server back up?
I am trying: 'pg_ctl -D /Library/PostgresPlus/9.0SS/data/ stop'
but getting:
'waiting for server to shut down............................................................... failed
pg_ctl: server does not shut down'
message. pgAdmin does not enable the 'start and stop' menu choices for me to do it through there either.
i just took a PG Admin class but in there we used Linux and things were much simpler to work with, so I assume that there is some sort or process or method I need to use for this version of PG.
Thanks.
On Mar 23, 2011, at 8:46 PM, Bill P. wrote: > I am trying: 'pg_ctl -D /Library/PostgresPlus/9.0SS/data/ stop' > but getting: > 'waiting for server to shut down............................................................... failed > pg_ctl: server does not shut down' By default pg_ctl -D <data directory> stop command does smart shutdown. There might be some connections/transaction in PGwhich must be stoping shutdown. Try: pg_ctl -D /Library/PostgresPlus/9.0SS/data/ stop -mf Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.kumar@enterprisedb.com Blog:http://vibhork.blogspot.com