Mailing List Archive

On Wed, 2010-01-27 at 10:41 -0800, Mike Bernhardt wrote:
> I used the davical create-database.sh script, but did not have my
> paths set up correctly. In the end, davical created the database, but
> with many errors. I fixed my path issues but the script won?t run
> because the database already exists. How do I delete it so that I can
> create it again, properly?

How you can drop the database can depend on what OS & distribution you
are running.

On Debian you should be able to type:

dropdb davical

at the shell prompt.

On others you might have to go into psql and issue a:

DROP DATABASE davical;


Cheers,
Andrew.

------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Open Source: the difference between trust and antitrust
------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100128/4a5b22ca/attachment.pgp>
-------------- next part --------------

I'm on Mac OS X, so it's basically BSD. Where exactly is the davical
database created? If I just rm -r the pgsql and/or davical directories and
reinstall, will that do it?

-----Original Message-----
From: Andrew McMillan [mailto:andrew@morphoss.com]
Sent: Thursday, January 28, 2010 12:42 AM
To: Mike Bernhardt
Cc: rscds-general at lists.sourceforge.net
Subject: Re: [DAViCal-general] Postgresql setup issue

On Wed, 2010-01-27 at 10:41 -0800, Mike Bernhardt wrote:
> I used the davical create-database.sh script, but did not have my
> paths set up correctly. In the end, davical created the database, but
> with many errors. I fixed my path issues but the script won't run
> because the database already exists. How do I delete it so that I can
> create it again, properly?

How you can drop the database can depend on what OS & distribution you
are running.

On Debian you should be able to type:

dropdb davical

at the shell prompt.

On others you might have to go into psql and issue a:

DROP DATABASE davical;


Cheers,
Andrew.

------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Open Source: the difference between trust and antitrust
------------------------------------------------------------------------

Never mind, I got it. Once I had my paths properly in place, "dropdb
davical" run as the postgres user did the trick.

-----Original Message-----
From: Andrew McMillan [mailto:andrew@morphoss.com]
Sent: Thursday, January 28, 2010 12:42 AM
To: Mike Bernhardt
Cc: rscds-general at lists.sourceforge.net
Subject: Re: [DAViCal-general] Postgresql setup issue

On Wed, 2010-01-27 at 10:41 -0800, Mike Bernhardt wrote:
> I used the davical create-database.sh script, but did not have my
> paths set up correctly. In the end, davical created the database, but
> with many errors. I fixed my path issues but the script won't run
> because the database already exists. How do I delete it so that I can
> create it again, properly?

How you can drop the database can depend on what OS & distribution you
are running.

On Debian you should be able to type:

dropdb davical

at the shell prompt.

On others you might have to go into psql and issue a:

DROP DATABASE davical;


Cheers,
Andrew.

------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Open Source: the difference between trust and antitrust
------------------------------------------------------------------------