From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | chakkara rangarajan <ranga(at)dvdstation(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: change of table name - any help |
Date: | 2003-09-17 17:40:55 |
Message-ID: | Pine.LNX.4.33.0309171137520.7798-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Well, if you're trying to run postgresql under openmosix, I'd suggest
looking into the archives of the postgresql-general and hackers mailing
list. note that this isn't a problem that has a fix in sight as far as I
know, i.e. there's a lot of work left to make it a functional solution,
and even the, it might wind up being slower than just running postgresql
on a single reasonably fast server.
If you are currently running your database on a mosix cluster I'd
recommend setting up a single machine and restoring your database to that
box.
As for getting your table back, I'm not so sure what to do. It sounds
like the pg_ catalogs are having some problems caused by being under
mosix, and you'll have to find someone here more familiar with the inner
workings of postgresql to get a fix.
On Wed, 17 Sep 2003, chakkara rangarajan wrote:
> Hello Mr.scott,
> Thx for the info and kind help. Can you please provide me any useful links
> about the nature of the problem.
> Rgds
> --Ranga
>
>
> -----Original Message-----
> From: scott.marlowe [mailto:scott(dot)marlowe(at)ihs(dot)com]
> Sent: Wednesday, September 17, 2003 10:26 AM
> To: chakkara rangarajan
> Cc: pgsql-admin(at)postgresql(dot)org
>
> On Wed, 17 Sep 2003, chakkara rangarajan wrote:
>
> > Hi All,
> >
> > We have a development server running
> >
> > OS - Linux, 2.4.20-openmosix-r4
> >
> > DB - postgresql 7.3
> >
> >
> >
> > We have a table ctcert_name under postgres DB(postgres schema and postgres
> > user is the owner). Suddenly, this object started missing from the DB (I
> am
> > the only
> >
> > Person who connects to that server and did not drop/renamed it). When I
> > tried to recreate the same table, the system threw me back an error,
> saying
> > that "postgres.ctcert_name" already exists. I am neither able to drop or
> > rename the table.
> >
> >
> >
> > Can somebody please tell me, what cud have gone wrong and is the error is
> > reproduceable? What is the solution for this kind of problem.
> >
> > Your efforts are greatly appreciated.
>
> Postgresql is known to not work properly under Mosix. It may someday, but
> from what I've read the shared memory / semaphore system is at the heart
> of the problem.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-09-17 17:41:40 | Re: change of table name - any help |
Previous Message | chakkara rangarajan | 2003-09-17 17:34:00 | Re: change of table name - any help |