There is a simple way to start/stop postgresql without any need to open the services dialogue:

NET START postgresql-x64-9.3

NET STOP postgresql-x64-9.3

Just replace the version in the statements (you only need major and minor). Just skip the -x64 if you still have a 32bit version.

see http://www.postgresql.org/about/news/1415/ for further information about the new features.

To install it in ubuntu you could use Martin Pitt’s ppa under https://launchpad.net/~pitti/+archive/postgresql

sudo apt-add-repository ppa:pitti/postgresql
sudo apt-get update
sudo apt-get dist-upgrade
sudo apt-get install postgresql-9.2 postgresql-client-9.2

WARNING: This won’t upgrade your 9.1 if you’ve already installed that. Of course you could get rid of your database with apt-get remove. But you’ll have to migrate your data manually!

NOTICE: To avoid autostart of postgre just make

sudo update-rc.d -f postgresql remove

I was just messing around with postgresql and table partitions and tablespaces. Here is a short SQL script that uses a virtual table that is partitioned by the modulus of the id column. Each partition lies on a different tablespace and in the schema partition.

begin;

drop table if exists partition.test_0;
drop table if exists partition.test_1;
drop table if exists test;

CREATE TABLE test (
	id SERIAL PRIMARY KEY
);

CREATE TABLE partition.test_0 (
	PRIMARY KEY (id),
	CHECK ( id % 2 = 0 )
)
INHERITS (test)
TABLESPACE ts1;

CREATE TABLE partition.test_1 (
	PRIMARY KEY (id),
	CHECK ( id % 2 = 1 )
)
INHERITS (test)
TABLESPACE ts2;

CREATE OR REPLACE FUNCTION test_trigger_function()
RETURNS TRIGGER AS $$
BEGIN
	IF ( NEW.id % 2 = 0 ) THEN 
		INSERT INTO partition.test_0 VALUES (NEW.*); 
	ELSIF ( NEW.id % 2 = 1 ) THEN 
		INSERT INTO partition.test_1 VALUES (NEW.*);
	ELSE
		RAISE EXCEPTION 'This should not happen! See test_insert_trigger.';
	END IF;
	RETURN NULL;
END;
$$
LANGUAGE plpgsql;

CREATE TRIGGER insert_test_mod_trigger 
	BEFORE INSERT ON test
	FOR EACH ROW EXECUTE PROCEDURE test_trigger_function();

commit;