who can run utility - pg_controldata ?

Started by Dennis Gearonalmost 22 years ago5 messagesgeneral

gearond@fireserve.net

almost 22 years ago

My website that I'm hosted at (which pgsql of course), had a crash this
weekend and is still recovering, (real bummer).

Otherwise, I would just run it and see if I could.

So, list members, who can run 'pg_controldata', i.e. which users?

tgl@sss.pgh.pa.us

almost 22 years ago

In reply to: Dennis Gearon (#1)

Re: who can run utility - pg_controldata ?

Dennis Gearon <gearond@fireserve.net> writes:

So, list members, who can run 'pg_controldata', i.e. which users?

The postgres user and root. Nobody else should be able to read $PGDATA.

regards, tom lane

gearond@fireserve.net

almost 22 years ago

In reply to: Tom Lane (#2)

Re: who can run utility - pg_controldata ?

Tom Lane wrote:

Dennis Gearon <gearond@fireserve.net> writes:

So, list members, who can run 'pg_controldata', i.e. which users?

The postgres user and root. Nobody else should be able to read $PGDATA.

regards, tom lane

Any other way to find out what the database cluster 'lc_collate' and
'lc_ctype' values are set to?

tgl@sss.pgh.pa.us

almost 22 years ago

In reply to: Dennis Gearon (#3)

Re: who can run utility - pg_controldata ?

Dennis Gearon <gearond@fireserve.net> writes:

Any other way to find out what the database cluster 'lc_collate' and
'lc_ctype' values are set to?

In 7.4, just "show" 'em. Before that, I don't think so (barring
conducting experiments to discover the sort order, etc).

regards, tom lane

gearond@fireserve.net

almost 22 years ago

In reply to: Tom Lane (#4)

Re: who can run utility - pg_controldata ?

Thanks Tom.

Tom Lane wrote:

Show quoted text

Dennis Gearon <gearond@fireserve.net> writes:

Any other way to find out what the database cluster 'lc_collate' and
'lc_ctype' values are set to?

In 7.4, just "show" 'em. Before that, I don't think so (barring
conducting experiments to discover the sort order, etc).

regards, tom lane