Re: URGENT :: FATAL: could not create lock file "postmaster.pid": Permission denied

Not a problem. We all need help from time to time.
Maybe some time you will be able to help me as well.

Nice meeting you too.

Have a great day.

R

Renato Oliveira
Systems Administrator
e-mail: renato(dot)oliveira(at)grant(dot)co(dot)uk

Tel: +44 (0)1763 260811
Fax: +44 (0)1763 262410
www.grant.co.uk<http://www.grant.co.uk/>

Grant Instruments (Cambridge) Ltd

Company registered in England, registration number 658133

Registered office address:
29 Station Road,
Shepreth,
CAMBS SG8 6GB
UK

From: Kranti(tm) K K Parisa [mailto:kranti(dot)parisa(at)gmail(dot)com]
Sent: 28 January 2010 08:24
To: Renato Oliveira
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] URGENT :: FATAL: could not create lock file "postmaster.pid": Permission denied

hi,

i got that, i checked the folder permissions and given full rights to postgres user now i am able to start the service.

thanks very much and nice meeting you this way.

Best Regards,
Kranti K K Parisa

On Thu, Jan 28, 2010 at 1:51 PM, Renato Oliveira <renato(dot)oliveira(at)grant(dot)co(dot)uk<mailto:renato(dot)oliveira(at)grant(dot)co(dot)uk>> wrote:
How are you trying to start the postgres service?
Which user are you trying to start it with?

R

Renato Oliveira
Systems Administrator
e-mail: renato(dot)oliveira(at)grant(dot)co(dot)uk<mailto:renato(dot)oliveira(at)grant(dot)co(dot)uk>

Tel: +44 (0)1763 260811
Fax: +44 (0)1763 262410
www.grant.co.uk<http://www.grant.co.uk/>

Grant Instruments (Cambridge) Ltd

Company registered in England, registration number 658133

Registered office address:
29 Station Road,
Shepreth,
CAMBS SG8 6GB
UK

From: Kranti(tm) K K Parisa [mailto:kranti(dot)parisa(at)gmail(dot)com<mailto:kranti(dot)parisa(at)gmail(dot)com>]
Sent: 28 January 2010 08:20
To: Renato Oliveira; pgsql-admin(at)postgresql(dot)org<mailto:pgsql-admin(at)postgresql(dot)org>
Subject: Re: [ADMIN] URGENT :: FATAL: could not create lock file "postmaster.pid": Permission denied

Hi,

Thanks for the quick reply. Could you please guide me where could I check the settings or so to identify where postmaster is trying to create the pid file?

Best Regards,
Kranti K K Parisa

On Thu, Jan 28, 2010 at 1:44 PM, Renato Oliveira <renato(dot)oliveira(at)grant(dot)co(dot)uk<mailto:renato(dot)oliveira(at)grant(dot)co(dot)uk>> wrote:
I would check where postmaster is trying to create the pid and check if postgres has permission to write to the folder.
Then Maybe change the location for pid creation.

Check also postgreslog and see if you can spot the error.

R

Renato Oliveira
Systems Administrator
e-mail: renato(dot)oliveira(at)grant(dot)co(dot)uk<mailto:renato(dot)oliveira(at)grant(dot)co(dot)uk>

Tel: +44 (0)1763 260811
Fax: +44 (0)1763 262410
www.grant.co.uk<http://www.grant.co.uk/>

Grant Instruments (Cambridge) Ltd

Company registered in England, registration number 658133

Registered office address:
29 Station Road,
Shepreth,
CAMBS SG8 6GB
UK

From: pgsql-admin-owner(at)postgresql(dot)org<mailto:pgsql-admin-owner(at)postgresql(dot)org> [mailto:pgsql-admin-owner(at)postgresql(dot)org<mailto:pgsql-admin-owner(at)postgresql(dot)org>] On Behalf Of Kranti(tm) K K Parisa
Sent: 28 January 2010 08:11
To: pgsql-admin(at)postgresql(dot)org<mailto:pgsql-admin(at)postgresql(dot)org>
Subject: [ADMIN] URGENT :: FATAL: could not create lock file "postmaster.pid": Permission denied

FATAL: could not create lock file "postmaster.pid": Permission denied

getting this error during servic startup.

please suggest quickly as its a production database

thanks in advance.

Best Regards,
Kranti K K Parisa

P Please consider the environment before printing this email
CONFIDENTIALITY: The information in this e-mail and any attachments is confidential. It is intended only for the named recipients(s). If you are not the named recipient please notify the sender immediately and do not disclose the contents to another person or take copies.

VIRUSES: The contents of this e-mail or attachment(s) may contain viruses which could damage your own computer system. Whilst Grant Instruments (Cambridge) Ltd has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should therefore carry out your own virus checks before opening the attachment(s).

OpenXML: For information about the OpenXML file format in use within Grant Instruments please visit our website<http://www.grant.co.uk/Support/openxml.html>

P Please consider the environment before printing this email
CONFIDENTIALITY: The information in this e-mail and any attachments is confidential. It is intended only for the named recipients(s). If you are not the named recipient please notify the sender immediately and do not disclose the contents to another person or take copies.

VIRUSES: The contents of this e-mail or attachment(s) may contain viruses which could damage your own computer system. Whilst Grant Instruments (Cambridge) Ltd has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should therefore carry out your own virus checks before opening the attachment(s).

OpenXML: For information about the OpenXML file format in use within Grant Instruments please visit our website<http://www.grant.co.uk/Support/openxml.html>

P Please consider the environment before printing this email
CONFIDENTIALITY: The information in this e-mail and any attachments is confidential. It is intended only for the named recipients(s). If you are not the named recipient please notify the sender immediately and do not disclose the contents to another person or take copies.

VIRUSES: The contents of this e-mail or attachment(s) may contain viruses which could damage your own computer system. Whilst Grant Instruments (Cambridge) Ltd has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should therefore carry out your own virus checks before opening the attachment(s).

OpenXML: For information about the OpenXML file format in use within Grant Instruments please visit our website<http://www.grant.co.uk/Support/openxml.html>