Renaming a Database

[TPayne]

Is it possible to rename a database?

[fabio]

You can rename your database(s) with pgAdmin

[TPayne]

I looked around in pgAdmin III and I couldn't find anywhere to rename it. It seems as if the names are locked in and unable to edit.

[agc1976]

Try this:

1. Create a backup of your database with PGAdmin.
2. Create a new database with the name that you want.
3. Restore the old database on top of the database you just created.

[Stick66]

(You may want to back up your DB before you try this, but it worked fine for me.)

Found the trick:

- Go into "PSQL to 'postgres'" (not pgAdmin)

- Enter this line exactly, but where xxx = old DB name and nnn = new DB name:

ALTER DATABASE "xxxxxxx" RENAME TO "nnnnnnn" \g

(Here's the PostgreSQL Doc page for it: http://www.postgresql.org/docs/8.3/s...rdatabase.html ) (the "\g" part is what executes the command)

- When you next open HEM, you will get an error "Database not found" or something. Click "OK" and Database Maintenance should open. Connect and make your newly named DB the default.

Then you're set!!