On 12/20/2014 08:23 PM, Ramesh T wrote: CCing list.
yeah i have following 1 and 2 answers..not something else only those two answers..
Well there is CREATE DATABASE TEMPLATE some_db. IMPORTANT look at the caveats at bottom of page here: http://www.postgresql.org/docs/9.3/interactive/sql-createdatabase.html For replication in the core see here: http://www.postgresql.org/docs/9.3/interactive/high-availability.html For other solutions see Table 25-1 here: http://www.postgresql.org/docs/9.3/interactive/different-replication-solutions.html
On Fri, Dec 19, 2014 at 8:20 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote: On 12/19/2014 01:17 AM, Ramesh T wrote: is their any other method to clone database,other then pgadmin and pgdump.. if is their option pls let me know.. You will need to be more specific about what you want. Do you want something like what pg_dump offers, a copy of a database at a point in time? Do want a replicated database that exists in close to real time, concurrently? Or something else? -- Adrian Klaver adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
