That means that the tablespace directory isn't empty.
On Mon, Apr 24, 2006 at 01:34:33PM +0200, Markus Schaber wrote:
> Hello,
>
> I now pulled the plug, migrated all databases via "create database ...
> tempate olddatabase tablespace newts" to new tablespaces, one for each
> database, and droppe
Daniel Caune wrote:
> It seems that was possible: I tried first to truncate the table (it
> passed), and finally I tried to drop the table (it also passed). Then
> I created the table. I'm not sure that it fixes my problem. I
> modified my fstab file so that Linux checks my file system's healt
> De : [EMAIL PROTECTED] [mailto:pgsql-sql-
> [EMAIL PROTECTED] De la part de Andrew Sullivan
>
> On Mon, Apr 24, 2006 at 12:17:07PM -0400, Daniel Caune wrote:
> > Hi,
> >
> > Is there any way to solve the following issue without dropping the
> > table?
>
> I doubt you'll be able to drop the ta
> De : Alvaro Herrera [mailto:[EMAIL PROTECTED]
>
> Daniel Caune wrote:
> >
> > > De : Alvaro Herrera [mailto:[EMAIL PROTECTED]
> > >
> > > Daniel Caune wrote:
> > > >
> > > > select count(*) from eventplayerleaveroom;
> > > > ERROR: could not access status of transaction 3164404766
> > > >
While down loading 8.1.3, I tried the following:
update pf_inspectionsBld set insdate[0] = current_date
update pf_inspectionsBld set insdate[1] = current_date
update pf_inspectionsBld set insdate[2] = current_date
update pf_inspectionsBld set insdate[3] = current_date
update pf_inspectionsBld set
Daniel Caune wrote:
>
> > De : Alvaro Herrera [mailto:[EMAIL PROTECTED]
> >
> > Daniel Caune wrote:
> > >
> > > select count(*) from eventplayerleaveroom;
> > > ERROR: could not access status of transaction 3164404766
> > > DETAIL: could not open file "pg_clog/0BC9": No such file or direc
> De : Alvaro Herrera [mailto:[EMAIL PROTECTED]
>
> Daniel Caune wrote:
> > Hi,
> >
> > Is there any way to solve the following issue without dropping the
> > table?
> >
> > select count(*) from eventplayerleaveroom;
> > ERROR: could not access status of transaction 3164404766
> > DETAIL:
Daniel Caune wrote:
> Hi,
>
> Is there any way to solve the following issue without dropping the
> table?
>
> select count(*) from eventplayerleaveroom;
> ERROR: could not access status of transaction 3164404766
> DETAIL: could not open file "pg_clog/0BC9": No such file or directory
Are
On Mon, Apr 24, 2006 at 12:17:07PM -0400, Daniel Caune wrote:
> Hi,
>
> Is there any way to solve the following issue without dropping the
> table?
I doubt you'll be able to drop the table. I think you have some sort
of corruption. Assuming your hardware is good, you maybe oughta take
this over
Hello,
I now pulled the plug, migrated all databases via "create database ...
tempate olddatabase tablespace newts" to new tablespaces, one for each
database, and dropped all old databases that contained references to the
tablespace. Pgadmin3 also shows that the tablespace is not referenced by
any
Hi,
Is there any way to solve the following issue without dropping the
table?
select count(*) from eventplayerleaveroom;
ERROR: could not access status of transaction 3164404766
DETAIL: could not open file "pg_clog/0BC9": No such file or directory
Regards,
P.S.: PostgreSQL server 8.1.3
Hello,
Markus Schaber wrote:
> What is the easiest way to migrate a complete database from one
> tablespace to another?
>
> ALTER DATABASE only allows to set the default tablespace, but not
> migrating the existing database.
Is there really no way to do this?
Thanks,
Markus
--
Markus Schaber
Hello,
Markus Schaber wrote:
>>What is the easiest way to migrate a complete database from one
>>tablespace to another?
>>
>>ALTER DATABASE only allows to set the default tablespace, but not
>>migrating the existing database.
>
> Is there really no way to do this?
Via some scripting, I now migr
13 matches
Mail list logo
