Thread: Re: [GENERAL] postgres 6.5.1

Re: [GENERAL] postgres 6.5.1

From
Adrian Perez Camarena
Date:
Hi jeff

I have two paths with the directory /data

[root@servidor data]# pwd
/usr/src/redhat/BUILD/postgresql-6.5.1/src/data
[root@servidor data]# ls
CVS          koi-alt.tab   koi-koi.tab   koi-win.tab
charset.conf  koi-iso.tab   koi-mac.tab

and

[root@servidor data]# cd
/usr/src/redhat/BUILD/postgresql-6.5.1/src/test/regress/data
[root@servidor data]# ls
CVS        dept.data    onek.data    streets.data
agg.data    desc.data    person.data    stud_emp.data
constrf.data    emp.data    real_city.data    student.data
constro.data    hash.data    rect.data    tenk.data

The table's name is not in any of the directories above, the other tables
I have in my database aren't here either.


I have the next path where postgres keeps its files:

[root@servidor data]# cd /var/lib/pgsql/base/
[root@servidor base]# ls
db_redife     db_redife_bd  redife_1      redife_4
db_redife_1   imp        redife_2      template1
db_redife_2   redife        redife_3      utilidades

[root@servidor base]# cd redife
[root@servidor redife]# ls -l lista_nominal
-rw-------   1 postgres postgres 66977792 Feb 24 05:21 lista_nominal

the name of my DB is redife
the file lista_nominal is here
is very large and I can't read it
and my trouble remains.
thanks for your help...

On Wed, 23 Feb 2000, Jeff MacDonald wrote:

> try finding that table inthe data directory
> i think it's /var/lib/data in redhat, (something like that)
>
> if the file doesn't exist, touch it. and try
> to drop the table again
>
> jeff
>
> A
> On Wed, 23 Feb 2000, Adrian Perez Camarena wrote:
>
> >
> > I have a problem with my D.B.
> > I'm using linux 5.2 and postgres 6.5.1
> > When i try to delete a table with 300,000 rows, the first time, postgres
> > show me the next message:
> >
> >         heap delete: (am) invalid tid
> >
> > If i try to delete it again , the message is the follow:
> >
> >         ExecutePlan: (junk) 'ctid' is NULL!
> >
> > and there is a third message:
> >
> >         Cannot open segment 1 of relation lista_nominal
> >
> > where lista_nominal is the table that has the problem.
> >
> > I don't understand the messages, i hope someone can help me
> >
> >
> > Adrian Perez Camarena
> > IFE
> >
> >
> > ************
> >
>
> Jeff MacDonald
> jeff@pgsql.com
>
>