Re: ERROR: could not open relation with OID 2836 - Mailing list pgsql-general

Tom Lane wrote:
> Rodrigo Gonzalez <rjgonzale@gmail.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=#