Very easy, just add a repository and run apt-get install postresql-9.0 
Dctr Watson explains how:
Tag Archive: Database
- On the source machine:
- Set the tablespace(s) into read only mode
- SQL> Alter tablespace <tablespace> read only
- Set the tablespace(s) into read only mode
- Export the tablespace meta data using export
- % expdp system/<password> DUMPFILE=expdat.dmp DIRECTORY = dpump_dir TRANSPORT_TABLESPACES = <list of tablespaces separated by commas> TRANSPORT_FULL_CHECK=Y
- If the dumpdir is not set up, you will get an ‘invalid’ directory error:
- SQL> CREATE DIRECTORY dmpdir as ‘/somedir’;
- SQL> GRANT read,write on DIRECTORY to system;
- Export the data converting on the fly:
- Determine the platform name for the destination machine:
- SQL> SELECT PLATFORM_ID, PLATFORM_NAME, ENDIAN_FORMAT FROM V$TRANSPORTABLE_PLATFORM
- % rman TARGET /
- RMAN> CONVERT TABLESPACE <list of tablespaces separated by commas> to PLATFORM ‘<platform name from previous step>’ FORMAT=’/somedir/%U’;
- Determine the platform name for the destination machine:
- Put the tablespaces into read/write mode
- SQL> alter tablespace <tablespace> READ WRITE;
- Transfer the files to the destination machine (Setup the dumpdir if you haven’t already)
- Create the oracle user(s) with the same names as on the source oracle (if you don’t you will need to remap the ownership using the REMAP_SCHEMA for the impdb )
- Import the tablespace schema and data (repeat for each tablespace)
- % impdp system/<password> DUMPFILE=expdat.dmp DIRECTORY = dpump_dir TRANSPORT_DATAFILES = <Full path to each tablespace datafile separated by commas>
- Put the tablespaces in to read/write mode
- SQL> alter tablespace <tablespace> READ WRITE;
I asked Jeff Tallman if I could redistribute his excellent MDA posters for Sybase’s ASE 15.5 database server. He said yes so … here they are in both Adobe PDF and Sybase PowerDesigner PDM formats!
Jeff Tallman also provided us with the MDA posters for Sybase 15.0.3 last year.
Back in December 
of 2007, Andrew E. Bruno wrote an excellent article on how to use the open source program Dia to design databases. He used the resultant design to create a MySQL database but the same principles could be used to create just about any relational database from the design. Dia is available for Linux, *nix, and Windows.
Database Design with Dia
In this post I’m going to give a quick how-to on creating database schemas with a wonderful tool called Dia. I’ve often found having a nice visual representation of a database to be quite helpful but can’t stand keeping it up to date. As soon as you add a new column or change the design around you end up having to sync your visual diagram with your SQL files. It’s tedious having to manage the various SQL for building the database and this can be a larger pain when trying to support different database platforms each with their own SQL syntax. So before you create your next database read on and see how Dia can make your life a bit easier.
Dia is a program for creating diagrams and for this exercise we’ll be creating UML diagrams from within Dia. We’re also going to use a perl script called tedia2sql which will transform our Dia files directly to SQL for our target database. What’s also nice about creating database schemas this way is that you can generate SQL for multiple target databases without the maintenance overhead.
Over at the Database Geek Blog, Lewis Cunningham has provided the first of three blog posts on Oracle Security. The first post is well done IMHO:
Oracle 10g+ Security and Audit – Part 1
This is a three-part definition of Oracle Security (specifically in 10g but applies to later versions also). Part 1 covers the various types of security Oracle provides. Part 2 deals with Users/Schemas, Roles, Permissions and Data Access. Part 2 will be a more technical discussion than parts 1 or 3. In part 3, I will discuss implementing an Oracle auditing scheme and how to ensure you comply with security and audit regulations.
