Hi guys, Havin some trouble. One of my databases appeared to be empty suddenly after having a large amount of data in it. I contacted our server company and they gave me the postgres dir. I have put back the folder of the newsdatabase from the base dir into the base dir of Postgres and recreated the database. That's fine. However now the database is empty. When I do a cat on the file of the same name as one of the tables - it has loads of data in it. However when I go in to Postgres and try to list the table it comes back with ) rows. Any ideas I am desperate. I am using linux redhat and Postgres Thanks Abe
- [HACKERS] pgsql is 75 times faster with my new index scan devik
- Re: [HACKERS] pgsql is 75 times faster with my new i... Alfred Perlstein
- Re: [HACKERS] pgsql is 75 times faster with my new i... Hannu Krosing
- Re: [HACKERS] pgsql is 75 times faster with my n... Philip Warner
- Re: [HACKERS] pgsql is 75 times faster with my n... Hiroshi Inoue
- Re: [HACKERS] pgsql is 75 times faster with my n... Bruce Momjian
- Re: [HACKERS] pgsql is 75 times faster with ... Devik
- Re: [HACKERS] pgsql is 75 times faster w... Bruce Momjian
- Re: [HACKERS] pgsql is 75 times fas... Hannu Krosing
- Re: [HACKERS] pgsql is 75 times... Devik
- Re: [HACKERS] pgsql is 75 times... Bruce Momjian
- RE: [HACKERS] pgsql is 75 times faster with my new i... Mikheev, Vadim
- RE: [HACKERS] pgsql is 75 times faster with my new i... Mikheev, Vadim