Activities

February 2010
M T W T F S S
« Jan   Mar »
1234567
891011121314
15161718192021
22232425262728

EnterepriseDB : – Administrative commands

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:

<strong>#pg_ctl  -D /opt/EnterpriseDB/8.1.3.12/data restart/reload</strong>

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:>

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>