Tricks and Tips about Systems/Network

February 21, 2010

EnterepriseDB : – Administrative commands

Filed under: admins,EnterpriseDB — Liju Mathew @ 7:22 pm
Tags:

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

Theme: Rubric. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.