Thanks to all, the problem is solved now.
But Still I donot know how to use existing data directory (near about
110GB) in a new Postgres Installation.
I ask this in the list yesterday but still no clue on this.
Please guide if it is possible.
Best Regards
Adarsh
Raghavendra wrote:
Hi Adarsh,
Filip workaround is right approach, since its plain text format you
need to play with SED/AWK to pull those two tables.
Following link will help you:-
http://blog.endpoint.com/2010/04/restoring-individual-table-data-from.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
2011/10/5 pasman pasmański <[email protected]
<mailto:[email protected]>>
You should to create new database with two empty tables, set access
rights for all schemas readonly and pipe backup to this database.
2011/10/5, Dickson S. Guedes <[email protected]
<mailto:[email protected]>>:
> 2011/10/5 Adarsh Sharma <[email protected]
<mailto:[email protected]>>:
>> About 1 month ago, I take a complete databases backup of my
Database
>> server
>> through pg_dumpall command.
>> Today I need to extract or restore only 2 tables in a database.
>>
>> Is it possible or I have to restore complete Databases again.
Size of
>> backup
>> is 10 GB in .sql.gz format.
>
> If your dump was created using custom format [1] (pg_dump
> --format=custom or -Fc) you can do a pg_restore using
--use-list and
> --list [2].
>
> [1]
>
http://www.postgresql.org/docs/current/interactive/app-pgdump.html#PG-DUMP-OPTIONS
> [2]
>
http://www.postgresql.org/docs/current/interactive/app-pgrestore.html#APP-PGRESTORE-OPTIONS
>
> --
> Dickson S. Guedes
> mail/xmpp: [email protected] <mailto:[email protected]> -
skype: guediz
> http://guedesoft.net - http://www.postgresql.org.br
>
> --
> Sent via pgsql-general mailing list
([email protected] <mailto:[email protected]>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
------------
pasman
--
Sent via pgsql-general mailing list ([email protected]
<mailto:[email protected]>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
