I’d worked with one client who is using enterprisedb ( Redwood version).This database claims the stable performance and index searching same like Oracle does. It’s installation is more difficult since it’s using a GUI installer which requires separate “tmp” partition to start the GUI launcher. very sad thing –
Here are the few examples I uses to administrate it.
For Linux Server.
How start and stop Enterprisedb server
Change to EDB binary directory
cd /opt/EnterpriseDB/8.1.3.12/dbserver/bin
a. For Stopping
#pg_ctl -D /opt/EnterpriseDB/8.1.3.12/data stop
b. For Starting
pg_ctl -D start
Eg: #pg_ctl -D /opt/EnterpriseDB/8.1.3.12/data start
c. Restarting
pg_ctl -D restart/reload
Eg: #pg_ctl -D /opt/EnterpriseDB/8.1.3.12/data restart/reload
Note : U may use reload command in order of loading the chagedset without having DB shout down.
1. To dump all databases:
$ pg_dumpall > db.out -Uenterprisedb
2. To restore the database,
edb-psql -d -f -U enterprisedb
C:\>edb-psql -d symbiosis -f temp.sql -Uenterprisedb
Password for user enterprisedb:
3. Creating a database
C:\>createdb test -Uenterprisedb
Password:
CREATE DATABASE
4. Dumping a single database
C:\>pg_dump -d test -f dump.sql -Uenterprisedb
Password:
C:\>