Обсуждение: Error stopping postgresql service

Поиск
Список
Период
Сортировка

Error stopping postgresql service

От
Maalini Samuganardan
Дата:
Hi,

I am getting an error when try to stop the postgresql server. 
No problem starting.

Please find error message below.

Thank you.

[root@edbws01 run]# service postgresql status
postmaster is stopped
[root@edbws01 run]# service postgresql start
Starting postgresql service:                               [  OK  ]
[root@edbws01 run]# service postgresql stop
Stopping postgresql service:                               [FAILED]
[root@edbws01 run]# 

Regards,
Maalini

Re: Error stopping postgresql service

От
"Kevin Grittner"
Дата:
Maalini Samuganardan <maalini.sam@gmail.com> wrote:

> I am getting an error when try to stop the postgresql server.
> No problem starting.
>
> Please find error message below.
>
> Thank you.
>
> [root@edbws01 run]# service postgresql status
> postmaster is stopped
> [root@edbws01 run]# service postgresql start
> Starting postgresql service:
> [  OK  ]
> [root@edbws01 run]# service postgresql stop
> Stopping postgresql service:
> [FAILED]
> [root@edbws01 run]#

What version of PostgreSQL?  Obtained from where?  What OS?  What's
in the log?

-Kevin

Re: Error stopping postgresql service

От
Devrim GÜNDÜZ
Дата:
On Thu, 2011-02-24 at 10:20 +0800, Maalini Samuganardan wrote:
> [root@edbws01 run]# service postgresql start
> Starting postgresql service:                               [  OK  ]
> [root@edbws01 run]# service postgresql stop
> Stopping postgresql service:                               [FAILED]

Could you please take a look at /var/lib/pgsql/pgstartup.log (assuming
that this is an RPM installation)?

Regards,
--
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
Вложения

Re: Error stopping postgresql service

От
Lou Picciano
Дата:
Maalini - 

On first glance (and not knowing the architecture of your particular 'service'), this looks very explainable on the basis of PostgreSQL being instructed to do a 'graceful' shutdown - while you may have users connected.

Depending on how your service 'stop' issues the shutdown command, PostgreSQL may never stop!

Probably need to give us more specifics about the layout of your service.

Lou Picciano

----- Original Message -----
From: "Maalini Samuganardan" <maalini.sam@gmail.com>
To: pgsql-admin@postgresql.org
Sent: Wednesday, February 23, 2011 9:20:10 PM
Subject: [ADMIN] Error stopping postgresql service

Hi,

I am getting an error when try to stop the postgresql server. 
No problem starting.

Please find error message below.

Thank you.

[root@edbws01 run]# service postgresql status
postmaster is stopped
[root@edbws01 run]# service postgresql start
Starting postgresql service:                               [  OK  ]
[root@edbws01 run]# service postgresql stop
Stopping postgresql service:                               [FAILED]
[root@edbws01 run]# 

Regards,
Maalini

Re: Error stopping postgresql service

От
Maalini Samuganardan
Дата:
Hi All,

Thank you for your reply. 

Let me explain a bit more in detail.

This is the first time I am installing PostgreSQL Advanced Server. I do not have any database yet, except for the edb database. 
OS : Fedora 14
PostgreSQL Version : PPAS 8.4.7
I downloaded from enterprisedb website.
Installation was done using GUI  -  ./ppasmeta-8.4.5.18-linux-x64.bin

Below is the output from the log file /var/lib/pgsql/pgstartup.log :-

The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "english".

fixing permissions on existing directory /var/lib/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 24MB
creating configuration files ... ok
creating template1 database in /var/lib/pgsql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

Success. You can now start the database server using:

    /usr/bin/postgres -D /var/lib/pgsql/data
or
    /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start

runuser: cannot set groups: Operation not permitted
runuser: cannot set groups: Operation not permitted
runuser: cannot set groups: Operation not permitted
runuser: cannot set groups: Operation not permitted
runuser: cannot set groups: Operation not permitted
runuser: warning: cannot change directory to /var/lib/pgsql: Permission denied
-bash: /var/lib/pgsql/.bash_profile: Permission denied
postmaster cannot access the server configuration file "/var/lib/pgsql/data/postgresql.conf": Permission denied
runuser: warning: cannot change directory to /var/lib/pgsql: Permission denied
-bash: /var/lib/pgsql/.bash_profile: Permission denied
postmaster cannot access the server configuration file "/var/lib/pgsql/data/postgresql.conf": Permission denied
runuser: warning: cannot change directory to /var/lib/pgsql: Permission denied
-bash: /var/lib/pgsql/.bash_profile: Permission denied
postmaster cannot access the server configuration file "/var/lib/pgsql/data/postgresql.conf": Permission denied
runuser: warning: cannot change directory to /var/lib/pgsql: Permission denied

The weird part is i checked the owner and group of the folder "pgsql" is "enterprisedb". I do not know why it says in the log file that the file is owned by "postgres".

If I want to do a complete and clean installation, where are the location of files that I need to remove manually? 
Please help. I don't mind reinstalling the whole thing.

Thank you
Best Regards,
Maalini



On Fri, Feb 25, 2011 at 5:54 AM, Lou Picciano <loupicciano@comcast.net> wrote:
Maalini - 

On first glance (and not knowing the architecture of your particular 'service'), this looks very explainable on the basis of PostgreSQL being instructed to do a 'graceful' shutdown - while you may have users connected.

Depending on how your service 'stop' issues the shutdown command, PostgreSQL may never stop!

Probably need to give us more specifics about the layout of your service.

Lou Picciano

----- Original Message -----
From: "Maalini Samuganardan" <maalini.sam@gmail.com>
To: pgsql-admin@postgresql.org
Sent: Wednesday, February 23, 2011 9:20:10 PM
Subject: [ADMIN] Error stopping postgresql service

Hi,

I am getting an error when try to stop the postgresql server. 
No problem starting.

Please find error message below.

Thank you.

[root@edbws01 run]# service postgresql status
postmaster is stopped
[root@edbws01 run]# service postgresql start
Starting postgresql service:                               [  OK  ]
[root@edbws01 run]# service postgresql stop
Stopping postgresql service:                               [FAILED]
[root@edbws01 run]# 

Regards,
Maalini