Re: [GENERAL] dump to pg

2017-06-04 Thread Steven Chang
hello, not possible in your case. To my understading, no tool can directly transform binary dump(Oralce & MSSQL) to csv file format. Steven 2017-06-02 5:37 GMT+08:00 Nicolas Paris : > > If they aren't too big, you might get away by installing the express > edition of the respective DBMS

[GENERAL] pg_rewind - enable wal_log_hints or data-checksums

2017-06-04 Thread Dylan Luong
Hi In the PostgreSQL documentation for pg_rewind: pg_rewind requires that the target server either has the wal_log_hints option enabled in postgresql.conf or data checksums enabled when the cluster was initialized with initdb. What is the difference between the two options? What are the advan

Re: [GENERAL] pg_rewind - enable wal_log_hints or data-checksums

2017-06-04 Thread Michael Paquier
On Mon, Jun 5, 2017 at 9:37 AM, Dylan Luong wrote: > pg_rewind requires that the target server either has the wal_log_hints > option enabled in postgresql.conf or data checksums enabled when the cluster > was initialized with initdb. Yes, this is to make sure that you don't finish with a corrupte