Posted by: Anil | November 21, 2007

Switching Databases From MySQL to PostgreSQL 8.2

Here is an excellent article on how to switch from MySQL to PostgreSQL. The steps outlined there apply to Entic.net v.Dedicated Servers.

The PostgreSQL RBAC role is actually included in the “vds” user account that is created when the v.Dedicated Server is created, as shown here:

vds19@vds19:~% profiles -l

      Postgres Administration:
          /usr/postgres/8.2/bin/initdb    uid=postgres
          /usr/postgres/8.2/bin/ipcclean    uid=postgres
          /usr/postgres/8.2/bin/pg_controldata    uid=postgres
          /usr/postgres/8.2/bin/pg_ctl    uid=postgres
          /usr/postgres/8.2/bin/pg_resetxlog    uid=postgres
          /usr/postgres/8.2/bin/postgres    uid=postgres
          /usr/postgres/8.2/bin/postmaster    uid=postgres
      All:
          *
vds19@vds19:~% profiles
Postgres Administration
Basic Solaris User
All
vds19@vds19:~%
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: