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 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

cache lookup failed for relation (just some data here)

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)

=46rom 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.


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: postgres data permission

Silvio Brandani 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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: postgres data permission

--0022152d60f903c2a5048b6f990c
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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

> Hi all,
>
> I need to start a postgres istance on a samba filesystems /data which hav=
e
> 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 agl=
i
> 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 perv=
engano
> da questo indirizzo messaggi estranei all'attività lavorativa o cont=
rari 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
>



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

--0022152d60f903c2a5048b6f990c
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 t=
cpip sockets and work much more switfly on a local file system?

class=3D"gmail_quote">
2010/7/15 Silvio Brandani < andani@tech.sdb.it">silvio.brandani@tech.sdb.it>
te class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc so=
lid;padding-left:1ex;">
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 star=
tup istance on this "special folder"??





---













Utilizziamo i dati personali che la riguardano esclusivamente per nostre fi=
nalità amministrative e contabili, anche quando li comunichiamo a terz=
i. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e ag=
li altri Suoi diritti, sono riportate alla pagina inodelbene.com/news/privacy.html" target=3D"_blank">http://www.savinodelben=
e.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 c=
odice penale " target=3D"_blank">http://www.savinodelbene.com/codice_penale _616.html=



L'Azienda non si assume alcuna responsabilità giuridica qualora pe=
rvengano da questo indirizzo messaggi estranei all'attività lavora=
tiva o contrari a norme.

--

Re: postgres data permission

2010/7/15 David Bear :
> 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

Re: postgres data permission

--_52549a84-dc9a-4642-84bc-cfe278e2bf1b_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Remove me from your email chain please

I will react very badly if I recieve any more emails from you.
=20
> From: wultsch@gmail.com
> Date: Fri=2C 16 Jul 2010 00:14:45 -0700
> Subject: Re: [ADMIN] postgres data permission
> To: David.Bear@asu.edu
> CC: silvio.brandani@tech.sdb.it=3B pgsql-admin@postgresql.org
>=20
> 2010/7/15 David Bear :
> > 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 ove=
r
> > tcpip sockets and work much more switfly on a local file system?
> >
>=20
> 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.
>=20
> Could it make sense to have box #2 run pg while mounting the fs of box #1=
?
>=20
>=20
> --=20
> Rob Wultsch
> wultsch@gmail.com
>=20
> --=20
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
=20
____________________________________________________________ _____
http://clk.atdmt.com/UKM/go/195013117/direct/01/
We want to hear all your funny=2C exciting and crazy Hotmail stories. Tell =
us now=

--_52549a84-dc9a-4642-84bc-cfe278e2bf1b_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






Remove me from your email chain please

I will react very badly if I recieve any more emails from =3Byou.
&n=
bsp=3B
>=3B From: wultsch@gmail.com
>=3B Date: Fri=2C 16 Jul 2010=
00:14:45 -0700
>=3B Subject: Re: [ADMIN] postgres data permission
=
>=3B To: David.Bear@asu.edu
>=3B CC: silvio.brandani@tech.sdb.it=3B =
pgsql-admin@postgresql.org
>=3B
>=3B 2010/7/15 David Bear <=3B=
David.Bear@asu.edu>=3B:
>=3B >=3B this doesn't make sense. why go =
through the overhead of smb to get to a
>=3B >=3B database cluster o=
ver a network connection when pg can already work over
>=3B >=3B tcp=
ip sockets and work much more switfly on a local file system?
>=3B >=
=3B
>=3B
>=3B Lets say you have to boxes:
>=3B #1: lots of =
disk but not much ram or cpu.
>=3B #2: lots of ram and cpu but not muc=
h disk.
>=3B
>=3B Could it make sense to have box #2 run pg whil=
e mounting the fs of box #1?
>=3B
>=3B
>=3B --
>=3B =
Rob Wultsch
>=3B wultsch@gmail.com
>=3B
>=3B --
>=3B =
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>=3B To=
make changes to your subscription:
>=3B http://www.postgresql.org/mai=
lpref/pgsql-admin

Re: postgres data permission

On Fri, Jul 16, 2010 at 12:30 AM, Jim Montgomery wr=
ote:
> Remove me from your email chain please
> I will react very badly if I recieve any more emails from=A0you.
>

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

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: postgres data permission

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 > >
>
> 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.
--

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin