Re: ERROR: could not open relation with OID 2836

Tom Lane wrote:
> Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com> writes:
>> Dont know exactly what you mean, if you are talking about the moment
>> that I receive the error...
>
> No, it's clear that things are already broken before pg_dump started.
> You need to show us how to get to this state from a fresh database.
>
> regards, tom lane

Interesting....a new problem maybe, or maybe the same one....

Steps done:

# rpm -Uvh postgresql-8.3.3-1PGDG.rhel4.x86_64.rpm
postgresql-contrib-8.3.3-1PGDG.rhel4.x86_64.rpm
postgresql-devel-8.3.3-1PGDG.rhel4.x86_64.rpm
postgresql-libs-8.3.3-1PGDG.rhel4.x86_64.rpm
postgresql-plperl-8.3.3-1PGDG.rhel4.x86_64.rpm
postgresql-server-8.3.3-1PGDG.rhel4.x86_64.rpm
warning: postgresql-8.3.3-1PGDG.rhel4.x86_64.rpm: V3 DSA signature:
NOKEY, key ID 442df0f8
Preparing... ###########################################
[100%]
1:postgresql-libs ###########################################
[ 17%]
2:postgresql ###########################################
[ 33%]
3:postgresql-server ###########################################
[ 50%]
4:postgresql-contrib ###########################################
[ 67%]
5:postgresql-devel ###########################################
[ 83%]
6:postgresql-plperl ###########################################
[100%]

#/etc/init.d/postgresql initdb

#cd /var/lib/pgsql/data

# diff -u postgresql.conf /root/backup/pgsql/postgresql.conf
--- postgresql.conf 2008-06-26 01:14:48.000000000 -0500
+++ /root/backup/pgsql/postgresql.conf 2008-06-26 01:07:44.000000000 -0500
@@ -53,7 +53,7 @@

# - Connection Settings -

-#listen_addresses = 'localhost' # what IP address(es) to listen on;
+listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
@@ -73,7 +73,7 @@
# - Security and Authentication -

#authentication_timeout = 1min # 1s-600s
-#ssl = off # (change requires restart)
+ssl = on # (change requires restart)
#ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers
# (change requires restart)
#password_encryption = on
@@ -104,7 +104,7 @@

# - Memory -

-shared_buffers = 32MB # min 128kB or max_connections*16kB
+shared_buffers = 256MB # min 128kB or max_connections*16kB
# (change requires restart)
#temp_buffers = 8MB # min 800kB
#max_prepared_transactions = 5 # can be 0 or more

#cp /root/backup/pgsql/server.* .
#chown postgres:postgres *

# cp /root/backup/pgsql/postgresql.conf .
# cp /root/backup/pgsql/pg_hba.conf .

#/etc/init.d/postgresql start

##### created the user and the DB
##### restored DB from backup. That DB has pg_buffercache contrib module
(just in case is important) and mysqlcompat too

# psql -U postgres db
Welcome to psql 8.3.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

db=# SELECT c.relname, pg_size_pretty(count(*) * 8192) as buffered,
round(100.0 * count(*) / (select setting from pg_settings where
name='shared_buffers')::integer,1) AS buffers_percent, round(100.0 *
count(*) * 8192 / pg_relation_size(c.relname),1) as percent_of_relation
FROM pg_class c INNER JOIN pg_buffercache b ON b.relfilenode =
c.relfilenode INNER JOIN pg_database d ON (b.reldatabase = d.oid AND
d.datname = current_database()) GROUP BY c.relname ORDER BY 3 DESC LIMIT 10;
ERROR: relation "pg_toast_1255" does not exist
db=#