[GE users] Clearing ARCo Data in arco database

Aman Yus amanyus at gmail.com
Wed Jan 2 15:13:02 GMT 2008


    [ The following text is in the "ISO-8859-1" character set. ]
    [ Your display is set for the "ISO-8859-10" character set.  ]
    [ Some special characters may be displayed incorrectly. ]

Thanks Jana! I dropped the database and recreated it =)



On Jan 2, 2008 5:41 PM, Jana Olivova <Jana.Olivova at sun.com> wrote:

>  Hi Aman,
>
> In that case the easiest way is to drop the whole database. In Postgres as
> a database superuser issue a command dropdb <db_name>. No users can be
> connected to the database at that time. Then you need recreate the database
> (createdb -O arco_write arco) and reinstall the dbwriter, so the table's
> structure is recreated.
>
> Otherwise you would need to issue an sql command for every table: DELETE
> FROM table_name
>
> which would delete all data from the given table.
>
> Regards,
>
> Jana Olivova
>
>
> Aman Yus wrote:
>
> All the data in the database...so that no history will appear in the ARCo
>
>
>
> On Dec 22, 2007 10:58 PM, Petr Jung <Petr.Jung at sun.com> wrote:
>
> > Hi Amanyus,
> > Do you mean clear all data? Or some time related part?
> > Petr
> >
> > amanyus napsal(a):
> > > Hello guys,
> > >
> > > Do we have a way to clear data that has been stored in arco database?
> > >
> >  > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: users-unsubscribe at gridengine.sunsource.net
> > > For additional commands, e-mail: users-help at gridengine.sunsource.net
> > >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe at gridengine.sunsource.net
> > For additional commands, e-mail: users-help at gridengine.sunsource.net
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at gridengine.sunsource.net
> For additional commands, e-mail: users-help at gridengine.sunsource.net
>



More information about the gridengine-users mailing list