Hi,
I have tried to taken backup while no one is connected. Should i change my
RAM and then check it. Version are same of pg_dump and database version 8.1.
Should I copy the data folder ? and then restore it with new installation or
what do you mean to say kindly brief it please. I will be thankfu
Hi ,
Make sure no one is connected to the database while doing the back up.
Usually memory alloc error comes if its a bad RAM .
check the pg_dump version and your database version match (this could be a
guess)
try file level backup and restore into new database.
On 22/05/2008, Amit jain <[EMAIL
Hi, Gerd
perhaps you can go the way via some system functions like:
Thank you very much and it's very helpful.
Regards
Duan
## list tables and their size
SELECTrelname AS table_name,
pg_size_pretty(pg_relation_size(oid)) AS table_sz,
pg_size_pretty(pg_t
On Thu, May 22, 2008 at 03:41:38PM -0400, Carol Walter wrote:
> This gives the same error. I can select columns from the table
> although select * gets the error. I tried making a copy of the
> "maps" table using CREATE TABLE new table name (all columns) AS
> SELECT all columns FROM maps;
This gives the same error. I can select columns from the table
although select * gets the error. I tried making a copy of the
"maps" table using CREATE TABLE new table name (all columns) AS
SELECT all columns FROM maps; This also gave me the same error.
Carol
On May 22, 2008, at 1:57 PM,
On Thu, May 22, 2008 at 01:37:56PM -0400, Carol Walter wrote:
> When I ran the query you specified I got relname of "pg_toast_16429.
> When I ran the REINDEX TABLE pg_toast_16429 the system responds that
> relation "pg_toast_16429" does not exist.
I think it should be pg_toast.pg_toast_16429
When I ran the query you specified I got relname of "pg_toast_16429.
When I ran the REINDEX TABLE pg_toast_16429 the system responds that
relation "pg_toast_16429" does not exist.
Carol
On May 22, 2008, at 1:02 PM, Tomeh, Husam wrote:
You may want to try to reindex the associated toast t
You may want to try to reindex the associated toast table and see if
that clears it up.
To get the name of the associated toast table, you may run this query:
select relname from pg_class where oid =
(select reltoastrelid from pg_class where relname = 'maps');
Then, reindex it.
Greetings...
I'm getting an error. The error says...
places=# REINDEX INDEX maps_map_id_seq;
ERROR: "maps_map_id_seq" is not an index
places=# SELECT * FROM maps;
ERROR: missing chunk number 0 for toast value 131343627
I have tried reindexing the index, the table, and the database. I
cont
Hello All,
We are using postgresql version 8.1 and our database size is 7gb. Ram Size
is 2 GB.
while trying to take backup through pg_dump i am getting following error.
oka97: pg_dump amtdb > amtdb.out
pg_dump: ERROR: invalid memory alloc request size 4294967293
pg_dump: SQL command to dump t
Hi Duan,
perhaps you can go the way via some system functions like:
## list tables and their size
SELECTrelname AS table_name,
pg_size_pretty(pg_relation_size(oid)) AS table_sz,
pg_size_pretty(pg_total_relation_size(oid)) AS
total_sz
FROM pg_c
11 matches
Mail list logo
