om mytable;
drop table mytable;
alter table mytablecopy rename to mytable;
Is there a better way?
In any case, that doesn't solve the "problem" of the WAL.
(c) Use pg_dump only? Never do a backup of the
raw files? How to do online backups?
--
Richard Walker
Software Improveme
on is on the same computer
as the database?
--
Richard Walker
Software Improvements Pty Ltd
Phone: +61 2 6273 2055
Fax: +61 2 6273 2082
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ay to deal
with the WAL . . .
--
Richard Walker
Software Improvements Pty Ltd
Phone: +61 2 6273 2055
Fax: +61 2 6273 2082
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of the WAL files. How to
flush old transaction data from the WAL once
and for all?
--
Richard Walker
Software Improvements Pty Ltd
Phone: +61 2 6273 2055
Fax: +61 2 6273 2082
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
