Postgresql setup issue

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Postgresql setup issue

Mike Bernhardt

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?


------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
rscds-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/rscds-general
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql setup issue

Andrew McMillan
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
------------------------------------------------------------------------


------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
rscds-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/rscds-general

signature.asc (205 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql setup issue

Mike Bernhardt
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:[hidden email]]
Sent: Thursday, January 28, 2010 12:42 AM
To: Mike Bernhardt
Cc: [hidden email]
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
------------------------------------------------------------------------



------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
rscds-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/rscds-general
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql setup issue

Mike Bernhardt
In reply to this post by Andrew McMillan
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:[hidden email]]
Sent: Thursday, January 28, 2010 12:42 AM
To: Mike Bernhardt
Cc: [hidden email]
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
------------------------------------------------------------------------



------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
rscds-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/rscds-general