Re: [cobalt-users] HOWTO: Rebuild PostgreSQL 'cobalt' database due to corrupt quota table

[Bruce Timberlake <bruce@xxxxxxxxxx>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> I followed everything but I have the following error when I erase
> the 'cobalt' database: (After the DEEP BREATH)
>
> [postgres@ns1 pgsql]$ destroydb cobalt
> Connection to database 'template1' failed.
> No pg_hba.conf entry for host localhost, user postgres, database
> template1
> destroydb: database destroy failed on cobalt.
>
> ----------
>
> In my original pg_hba.conf file I had the following line:
> Local COBALT crypt (an not local ALL crypt)
>
> I changed this into
>
> Local cobalt trust  or must this be local ALL trust ??

According to the destroydb man page,

"destroydb internally runs DESTROY DATABASE from psql  while connected 
to the template1 database"

Because it doesn't have explicit permissions to do so without the 
'all' option specified in the .conf file, the connection is failing.

Make it like the example, and it should work.

- -- 
Bruce Timberlake

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE99MqEvLA2hUZ9kgwRAj7vAJ9u9TftOOjXNuHeU3Cl2GNZPYnZ6QCeNABd
sNDD/WPXvWmHoD5Rh2P34pU=
=MQJp
-----END PGP SIGNATURE-----