[ADMIN] BLP Model on Postgresql

2011-02-23 Thread H S
Hi to all , I have some questions: no read up and no write down policies in BLP model, what sort of queries/ statements in SQL are read and write!? Sara

Re: [ADMIN] PG_update to 9.0.4 in ubuntu lucid 64

2011-02-23 Thread Bruce Momjian
Bruce Momjian wrote: > Bernhard Rohrer wrote: > > Thanks that worked. :) > > > > After this and some more entertainment we are now here: > > > > Restoring database schema to new cluster > > psql:/usr/lib/postgresql/9.0/bin/pg_upgrade_dump_db.sql:24606: ERROR: > > column "name" in child table mus

Re: [ADMIN] PG_update to 9.0.4 in ubuntu lucid 64

2011-02-23 Thread Bruce Momjian
Bernhard Rohrer wrote: > Thanks that worked. :) > > After this and some more entertainment we are now here: > > Restoring database schema to new cluster > psql:/usr/lib/postgresql/9.0/bin/pg_upgrade_dump_db.sql:24606: ERROR: > column "name" in child table must be marked NOT NULL > > > There we

Re: [ADMIN] CEDRUS

2011-02-23 Thread emersonmartins8
Hello good day everyone! Personal apology to all the previous message in Portuguese! Cedrus downloaded via the svn, use Linux debian / ubuntu does anyone knows how I initialize the cedrus? or configure it once downloaded? -- View this message in context: http://postgresql.1045698.n5.nabble.

[ADMIN] Hight consumption of physical memory

2011-02-23 Thread antonio galery
I´m starting postgresql 8.4.6 in a server aix 5.3 with 32GB ram 8 cpu. At this moment 16 connections are connected customers to postgresql. These connections together with the configuration of postgresql are consuming 29.4 GB and it also presents paging of 20% in page spacing whose size is of 40

Re: [ADMIN] PG_update to 9.0.4 in ubuntu lucid 64

2011-02-23 Thread Bernhard Rohrer
Thanks that worked. :) After this and some more entertainment we are now here: Restoring database schema to new cluster psql:/usr/lib/postgresql/9.0/bin/pg_upgrade_dump_db.sql:24606: ERROR: column "name" in child table must be marked NOT NULL There were problems executing "/usr/lib/postgresq

Re: [ADMIN] PG_update to 9.0.4 in ubuntu lucid 64

2011-02-23 Thread Bernhard Schrader
try to link both postgresql.conf to your /var/lib/postgresql/8.3/main/postgresql.conf and 9.0/main Am Mittwoch, den 23.02.2011, 08:50 + schrieb Bernhard Rohrer: > oh and since pg_config end up in /usr/bin one also needs to symlink it to > /usr/lib/postgresql/9.0/bin/ > > but: this leads to

Re: [ADMIN] PG_update to 9.0.4 in ubuntu lucid 64

2011-02-23 Thread Bernhard Rohrer
oh and since pg_config end up in /usr/bin one also needs to symlink it to /usr/lib/postgresql/9.0/bin/ but: this leads to the next problem: postgres@newcollab :/home/adminlion$ cd /usr/lib/postgresql/9.0/bin/ postgres@newcollab :/usr/lib/postgresql/9.0/bin$ ./pg_upgrade -b /usr/lib/postgresql

Re: [ADMIN] PG_update to 9.0.4 in ubuntu lucid 64

2011-02-23 Thread Bernhard Rohrer
and here is the answer: http://ubuntuforums.org/showthread.php?t=1341411 libpq-dev is what is needed original message- From: "Bernhard Schrader" [email protected] To: "Bernhard Rohrer" [email protected] CC: [email protected] Date: Tue, 2