The last time this was asked about
(http://archives.postgresql.org/pgsql-admin/2010-02/msg00189.php), 9.0
was still alpha.
Is there any reason to suspect that direct pg_attribute manipulation to
expand a varchar(n) column might not play nice with streaming
replication/hot standby? (Naturally
that matter, /etc/hostname and /etc/resolv.conf would be good
to see too because of their importance here.
HTH,
Geoff
-
Geoff Tolley
DBA/Systems Administrator
YouGovPolimetrix
285 Hamilton Avenue Suite 200
Palo Alto, CA 94301
geoff.tol...@yougov.com
http://www.yougov.com/
--
Sent via
Nick Urbanik wrote:
It seems that PostgreSQL 7.3.8 does not support create table
table_name like original_table.
Can you suggest a way I can create a duplicate table with the same
triggers and other stuff that this table has?
What is the most efficient way to copy the data?
Something like:
Nick Urbanik wrote:
I am running a full vacuum on a database. It's taking longer than I
hoped. In particular, the vacuum still hasn't reached the table that
will benefit most from the vacuum.
Can I move the existing table to a backup, make a copy of the table
back to its original name, restar
Tom Lane wrote:
Rob Cherry <[EMAIL PROTECTED]> writes:
Does anyone know if it is possible to overload auth types like this such
that if pam fails password would be tried?
No, it's not, as per the Fine Manual:
Provided that you don't care about the security and performance
implications of SS