pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
data mount point lost permissions
2+ messages / 2 participants
[nested] [flat]

* data mount point lost permissions
@ 2010-11-29 14:13 Silvio Brandani <silvio.brandani@tech.sdb.it>
  2010-11-29 14:59 ` Re: data mount point lost permissions Kevin Grittner <Kevin.Grittner@wicourts.gov>
  0 siblings, 1 reply; 2+ messages in thread

From: Silvio Brandani @ 2010-11-29 14:13 UTC (permalink / raw)
  To: pgsql-admin

During a  server restart  the mount point /var/lib/pgsql/data lost the 
0700 permission and the automatic restart of postgres failed.

How can I set the permission of this mount point to be not lost during 
restart of server ?? Have I to set specific option in fstab??

thanks
---






Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/privacy.html
Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/privacy/codice_penale_616.html
L'Azienda non si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo messaggi estranei all'attività lavorativa o contrari a norme.
--



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: data mount point lost permissions
  2010-11-29 14:13 data mount point lost permissions Silvio Brandani <silvio.brandani@tech.sdb.it>
@ 2010-11-29 14:59 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
  0 siblings, 0 replies; 2+ messages in thread

From: Kevin Grittner @ 2010-11-29 14:59 UTC (permalink / raw)
  To: pgsql-admin; Silvio Brandani <silvio.brandani@tech.sdb.it>

Silvio Brandani <silvio.brandani@tech.sdb.it> wrote:
 
> During a  server restart  the mount point /var/lib/pgsql/data lost
> the 0700 permission and the automatic restart of postgres failed.
> 
> How can I set the permission of this mount point to be not lost
> during restart of server ?? Have I to set specific option in
> fstab??
 
Perhaps the mount failed, or did not occur before PostgreSQL tried
to start?  If so, the permission flags may be saving you from
writing to entirely the wrong place?
 
Does your service script for PostgreSQL (probably in /etc/init.d/)
contain something like this in the BEGIN INIT INFO block?:
 
# Required-Start: $local_fs $network $syslog
# Should-Start: nthd
 
Those settings have kept us out of trouble....
 
-Kevin



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2010-11-29 14:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-11-29 14:13 data mount point lost permissions Silvio Brandani <silvio.brandani@tech.sdb.it>
2010-11-29 14:59 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox