pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres data permission
7+ messages / 5 participants
[nested] [flat]
* postgres data permission
@ 2010-07-15 13:06 Silvio Brandani <silvio.brandani@tech.sdb.it>
2010-07-15 15:40 ` Re: postgres data permission Tom Lane <tgl@sss.pgh.pa.us>
2010-07-15 16:28 ` Re: postgres data permission David Bear <David.Bear@asu.edu>
0 siblings, 2 replies; 7+ messages in thread
From: Silvio Brandani @ 2010-07-15 13:06 UTC (permalink / raw)
To: pgsql-admin
Hi all,
I need to start a postgres istance on a samba filesystems /data which
have rwxrwxrwx (777) permissions, Ic ould not change such permissions.
If I try to start postgres it complain that should be 700 permission .
How can I skip this control by postgres startup process and be able to
startup istance on this "special folder"??
---
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/news/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/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] 7+ messages in thread
* Re: postgres data permission
2010-07-15 13:06 postgres data permission Silvio Brandani <silvio.brandani@tech.sdb.it>
@ 2010-07-15 15:40 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 7+ messages in thread
From: Tom Lane @ 2010-07-15 15:40 UTC (permalink / raw)
To: Silvio Brandani <silvio.brandani@tech.sdb.it>; +Cc: pgsql-admin
Silvio Brandani <silvio.brandani@tech.sdb.it> writes:
> I need to start a postgres istance on a samba filesystems /data which
> have rwxrwxrwx (777) permissions, Ic ould not change such permissions.
> If I try to start postgres it complain that should be 700 permission .
> How can I skip this control by postgres startup process and be able to
> startup istance on this "special folder"??
You can't, and it wouldn't be a good idea even if you could.
I think what you're really saying is that you are trying to create a
Postgres data directory directly on a filesystem mount point. Don't do
that (it's a large-caliber foot-gun even aside from permissions issues).
Make a subdirectory in the mount point, and use that as the data
directory, and make sure it has the right ownership and permissions.
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgres data permission
2010-07-15 13:06 postgres data permission Silvio Brandani <silvio.brandani@tech.sdb.it>
@ 2010-07-15 16:28 ` David Bear <David.Bear@asu.edu>
2010-07-16 07:14 ` Re: postgres data permission Rob Wultsch <wultsch@gmail.com>
2010-07-16 08:23 ` Re: postgres data permission Silvio Brandani <silvio.brandani@tech.sdb.it>
1 sibling, 2 replies; 7+ messages in thread
From: David Bear @ 2010-07-15 16:28 UTC (permalink / raw)
To: Silvio Brandani <silvio.brandani@tech.sdb.it>; +Cc: pgsql-admin
this doesn't make sense. why go through the overhead of smb to get to a
database cluster over a network connection when pg can already work over
tcpip sockets and work much more switfly on a local file system?
2010/7/15 Silvio Brandani <silvio.brandani@tech.sdb.it>
> Hi all,
>
> I need to start a postgres istance on a samba filesystems /data which have
> rwxrwxrwx (777) permissions, Ic ould not change such permissions.
> If I try to start postgres it complain that should be 700 permission .
>
> How can I skip this control by postgres startup process and be able to
> startup istance on this "special folder"??
>
>
> ---
>
>
>
>
>
>
> 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/news/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/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.
> --
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
David Bear
College of Public Programs at ASU
602-494-0424
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgres data permission
2010-07-15 13:06 postgres data permission Silvio Brandani <silvio.brandani@tech.sdb.it>
2010-07-15 16:28 ` Re: postgres data permission David Bear <David.Bear@asu.edu>
@ 2010-07-16 07:14 ` Rob Wultsch <wultsch@gmail.com>
2010-07-16 07:30 ` Re: postgres data permission Jim Montgomery <monty1967@hotmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Rob Wultsch @ 2010-07-16 07:14 UTC (permalink / raw)
To: David Bear <David.Bear@asu.edu>; +Cc: Silvio Brandani <silvio.brandani@tech.sdb.it>; pgsql-admin
2010/7/15 David Bear <David.Bear@asu.edu>:
> this doesn't make sense. why go through the overhead of smb to get to a
> database cluster over a network connection when pg can already work over
> tcpip sockets and work much more switfly on a local file system?
>
Lets say you have to boxes:
#1: lots of disk but not much ram or cpu.
#2: lots of ram and cpu but not much disk.
Could it make sense to have box #2 run pg while mounting the fs of box #1?
--
Rob Wultsch
wultsch@gmail.com
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgres data permission
2010-07-15 13:06 postgres data permission Silvio Brandani <silvio.brandani@tech.sdb.it>
2010-07-15 16:28 ` Re: postgres data permission David Bear <David.Bear@asu.edu>
2010-07-16 07:14 ` Re: postgres data permission Rob Wultsch <wultsch@gmail.com>
@ 2010-07-16 07:30 ` Jim Montgomery <monty1967@hotmail.com>
2010-07-16 08:07 ` Re: postgres data permission Rob Wultsch <wultsch@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Jim Montgomery @ 2010-07-16 07:30 UTC (permalink / raw)
To: wultsch@gmail.com; david.bear@asu.edu; +Cc: silvio.brandani@tech.sdb.it; pgsql-admin
Remove me from your email chain please
I will react very badly if I recieve any more emails from you.
> From: wultsch@gmail.com
> Date: Fri, 16 Jul 2010 00:14:45 -0700
> Subject: Re: [ADMIN] postgres data permission
> To: David.Bear@asu.edu
> CC: silvio.brandani@tech.sdb.it; pgsql-admin@postgresql.org
>
> 2010/7/15 David Bear <David.Bear@asu.edu>:
> > this doesn't make sense. why go through the overhead of smb to get to a
> > database cluster over a network connection when pg can already work over
> > tcpip sockets and work much more switfly on a local file system?
> >
>
> Lets say you have to boxes:
> #1: lots of disk but not much ram or cpu.
> #2: lots of ram and cpu but not much disk.
>
> Could it make sense to have box #2 run pg while mounting the fs of box #1?
>
>
> --
> Rob Wultsch
> wultsch@gmail.com
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
_________________________________________________________________
http://clk.atdmt.com/UKM/go/195013117/direct/01/
We want to hear all your funny, exciting and crazy Hotmail stories. Tell us now=
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgres data permission
2010-07-15 13:06 postgres data permission Silvio Brandani <silvio.brandani@tech.sdb.it>
2010-07-15 16:28 ` Re: postgres data permission David Bear <David.Bear@asu.edu>
2010-07-16 07:14 ` Re: postgres data permission Rob Wultsch <wultsch@gmail.com>
2010-07-16 07:30 ` Re: postgres data permission Jim Montgomery <monty1967@hotmail.com>
@ 2010-07-16 08:07 ` Rob Wultsch <wultsch@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Rob Wultsch @ 2010-07-16 08:07 UTC (permalink / raw)
To: Jim Montgomery <monty1967@hotmail.com>; +Cc: david.bear@asu.edu; silvio.brandani@tech.sdb.it; pgsql-admin
On Fri, Jul 16, 2010 at 12:30 AM, Jim Montgomery <monty1967@hotmail.com> wrote:
> Remove me from your email chain please
> I will react very badly if I recieve any more emails from you.
>
Jim Montgomery,
This is the second message of this form I have received from you. Tom
Lane recently suggested that you unsubscribe from these mailing list
via the like at the bottom of every message. I think this would be a
good idea. I would like to take this one step further and suggest you
unsubscribe from this plane of existence.
Nothing personal but you are dragging down the species,
Rob Wultsch
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgres data permission
2010-07-15 13:06 postgres data permission Silvio Brandani <silvio.brandani@tech.sdb.it>
2010-07-15 16:28 ` Re: postgres data permission David Bear <David.Bear@asu.edu>
@ 2010-07-16 08:23 ` Silvio Brandani <silvio.brandani@tech.sdb.it>
1 sibling, 0 replies; 7+ messages in thread
From: Silvio Brandani @ 2010-07-16 08:23 UTC (permalink / raw)
To: David Bear <David.Bear@asu.edu>; +Cc: pgsql-admin
David Bear ha scritto:
> this doesn't make sense. why go through the overhead of smb to get to
> a database cluster over a network connection when pg can already work
> over tcpip sockets and work much more switfly on a local file system?
>
> 2010/7/15 Silvio Brandani <silvio.brandani@tech.sdb.it
> <mailto:silvio.brandani@tech.sdb.it>>
>
> Hi all,
>
> I need to start a postgres istance on a samba filesystems /data
> which have rwxrwxrwx (777) permissions, Ic ould not change such
> permissions.
> If I try to start postgres it complain that should be 700 permission .
>
> How can I skip this control by postgres startup process and be
> able to startup istance on this "special folder"??
>
>
> ---
>
>
>
>
>
>
>
> --
> David Bear
> College of Public Programs at ASU
> 602-494-0424
It is just a special occasion to restore a very big production database
in the only place we find enough space...
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/news/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/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] 7+ messages in thread
end of thread, other threads:[~2010-07-16 08:23 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-07-15 13:06 postgres data permission Silvio Brandani <silvio.brandani@tech.sdb.it>
2010-07-15 15:40 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-07-15 16:28 ` David Bear <David.Bear@asu.edu>
2010-07-16 07:14 ` Rob Wultsch <wultsch@gmail.com>
2010-07-16 07:30 ` Jim Montgomery <monty1967@hotmail.com>
2010-07-16 08:07 ` Rob Wultsch <wultsch@gmail.com>
2010-07-16 08:23 ` Silvio Brandani <silvio.brandani@tech.sdb.it>
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