follow the other thread that you started. there are some suggestions for
you.
2011/10/6 Adarsh Sharma
> **
> That's the bottleneck I need to solve:-
>
> Previous data & Os Version :- Postgresql-8.3 and Suse Enterprise Linux
> New Data & OS Version :- Postgresql-8.4 and Ubuntu 10.04
>
> W
That's the bottleneck I need to solve:-
Previous data & Os Version :- Postgresql-8.3 and Suse Enterprise Linux
New Data & OS Version :- Postgresql-8.4 and Ubuntu 10.04
What to do know?
Thanks
Raymond O'Donnell wrote:
On 06/10/2011 11:34, Filip Rembiałkowski wrote:
To use existing
On 06/10/2011 11:34, Filip Rembiałkowski wrote:
> To use existing data directory in new installation, you can just stop
> the server, replace data_directory, and start the server. Remember about
> file permissions - data_directory must be owned by server process owner
> ("postgres") and chmod 700.
2011/10/6 Adarsh Sharma
> **
> 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.
>
>
You need
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 Ad
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: ht
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 :
> 2011/10/5 Adarsh Sharma :
>> About 1 month ago, I take a complete databases backup of my Database
>> server
>> through pg_dumpall c
2011/10/5 Adarsh Sharma
> Dear all,
>
> 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
2011/10/5 Adarsh Sharma :
> 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
Dear all,
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.
Please l
10 matches
Mail list logo
