Hi i am able to start streaming replication with postgresql, copying the database files with doing theis command:
select pg_start_backup('clone', true);
That's right, but the thing is that i need to copy all the database files in /var/lib/postgresql/data to one server to another. That files are really big because of indexes for example.
I want to know if it is possible to do the same using a simple dump and restoring it on the slave, what is smaller and faster to transfer in the network, it will work? And what should i do to work?