On Tue, Oct 18, 2016 at 3:11 PM, Patrick B wrote:
> Thank you guys... good to know that pg_dump does all the job for me :)
>
> So.. If I only dump using the --schema-only option, it will dump all the
> schemas, constraints, indexes and tables?
>
> Because probably, I'll have to import the data ma
Thank you guys... good to know that pg_dump does all the job for me :)
So.. If I only dump using the --schema-only option, it will dump all the
schemas, constraints, indexes and tables?
Because probably, I'll have to import the data manually. NOt in a single
pg_restore I mean. (AWS issue)
On Mon, Oct 17, 2016 at 8:32 PM, Patrick B wrote:
> Hi guys,
>
> I need to export an entire database to another server, for testing purpose.
>
> Is there any way to export all indexes and constraints ?
> Postgres 9.2
> Patrick
>
By default pg_dump will export the constraints. It will export the
On 18-10-2016 06:32, Patrick B wrote:
Hi guys,
I need to export an entire database to another server, for testing
purpose.
Is there any way to export all indexes and constraints ?
Postgres 9.2
Patrick
Hello,
pg_dump database is that you need, but if you asking do you can export
data + inde
On 10/17/2016 08:32 PM, Patrick B wrote:
Hi guys,
I need to export an entire database to another server, for testing purpose.
Is there any way to export all indexes and constraints ?
pg_dump the_database
Postgres 9.2
Patrick
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-
On 10/17/2016 8:32 PM, Patrick B wrote:
I need to export an entire database to another server, for testing
purpose.
Is there any way to export all indexes and constraints ?
Postgres 9.2
on the existing machine, as the postgres user
pg_dump -Fc -d databasename -f filename.pgdump
then, on
Hi guys,
I need to export an entire database to another server, for testing purpose.
Is there any way to export all indexes and constraints ?
Postgres 9.2
Patrick
