who can run utility - pg_controldata ?

[Dennis Gearon]

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?

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Tom Lane]

Dennis Gearon <ge*****@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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Dennis Gearon]

Tom Lane wrote:

Dennis Gearon <ge*****@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?

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Tom Lane]

Dennis Gearon <ge*****@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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Dennis Gearon]

Thanks Tom.

Tom Lane wrote:

Dennis Gearon <ge*****@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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend