Thread: postgres data permission

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
quandoli 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
eventualiallegati, 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. 
--

I have noticed a few threads pertaining to the "cache lookup failed"
error message, and thought I would add some data to the mix.  I have
suffered this error in the past, and worked around it by dumping,
dropping and restoring my database (which is what landed me asking for
help yesterday :)).  I thought I would throw some data out into the mix
in the hopes that it might find someone else who is suffering from the
trouble.

My circumstance leading to the error:
- postgresql 8.3.7 on Centos Linux
- PHP connections that create temp table and populate with 100-200K
records (environmental modeling simulation system) - tables dropped
explicitly at the end of a simulation run (just an effort to be tidy)
- at times database log gives error "cache lookup failed for relation
XYXY" as a result of the call: "create temp table tmp_tablname ..."
- inserts attempts to this table subsequently fail "relation
tmp_tablname does not exist"
- copying and pasting the CREATE and INSERT statements into a psql
command line session SUCCEED without any issue, but subsequent PHP
connections (via command line call to php) FAIL with same errors.
- dump, drop and recreating the database fixes the problem (for a while)

From what I gathered looking through archives yesterday, this makes ME
think that it is catalog corruption perhaps?  But it would seem that the
PHP connections should not behave differently than the psql connections,
but I don't know enough to really say that...

Regards,
r.b.

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

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?




--
David Bear
College of Public Programs at ASU
602-494-0424

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

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
quandoli 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
eventualiallegati, 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. 
--

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

---

Get a new e-mail account with Hotmail - Free. Sign-up now.

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