Re: [DAViCal-general] Upgrade davical on FreeBSD

[Andrew M. <an...@mo...>]

On Thu, 2010-01-28 at 09:16 +0100, Matthias Fechner wrote:
> Hi Andrew,
> 
> Andrew McMillan wrote:
> > You should try and do the following:
> > Stop postgresql
> > Start postgresql
> >
> > connect as the database superuser and issue a:
> >
> > TRUNCATE session;
> > VACUUM FULL ANALYZE;
> >
> >   
> ok, I executed the commands I checked the session table and it was empty 
> after it.
> If I connect to the database via web I see in the errorlog:
> [Thu Jan 28 08:45:15 2010] [error] [client 88.217.56.106] rscds: WARN: 
> Login ERR: Other than one session record matches. 0
> 
> Maybe I forgot something in the restore of data.
> I execute the copy command on the following tables (in the order it is 
> shown here):
> usr
> caldav_data
> calendar_item
> principal
> property
> session
> 
> Maybe something in the database is broken?
> If you like I can sent a dump of the database to you.

There are lots more tables than that!  You should restore the whole
database.

I usually back up my database with:

  pg_dump -Fc davical >davical.pgdump

And then I can restore with:

  createdb --encoding utf-8 --owner davical_dba davical
  pg_restore -Fc -d davical davical.pgdump


If the database came from an older version of DAViCal, then you would
need to:

  cd /usr/share/davical
  dba/update-davical-database

in the normal manner.

After that you can truncate the session table and vacuum full analyze
the database as mentioned previously.

Cheers,
					Andrew.

------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com                            +64(272)DEBIAN
                Necessity is the mother of documentation
------------------------------------------------------------------------