Just to know, if actually there's -or where- now, a PostgreSQL Certified
Engineer program.
I think that obtaining -if able- a Postgresql CE and some kind of linux
certification like RHCE o LPI,
could be a lot of interest.
Finally, to know if there's any book (english) for the PostgreSQL
Hi Steve,
I know that EnterpriseDB offers 3 levels of certification.
Perhaps one of them suits your needs..?!?!
regards...:GERD:...
steve.gnuli...@gmail.com schrieb:
Just to know, if actually there's -or where- now, a PostgreSQL Certified
Engineer program.
I think that obtaining -if able- a
On Friday 20 February 2009 7:57:32 pm decibel wrote:
On Feb 19, 2009, at 1:49 PM, Adrian Klaver wrote:
From the Oracle manual:
ENABLE NOVALIDATE means the constraint is checked for new or
modified rows, but existing data may violate the constraint.
So you are looking for an incomplete
Tenia Red Hat enterprise 3.0 con postgresql 7.4.3 y PHP 4.3.2, por necesidad
de hardware migre todo a Red Hat enterprise 5.3 con postgresql 8.1.11 y PHP
5.1.6 (default del sistema operativo), si bien puedo crear y recuperar
la BD, no puedo acceder desde mi aplicacion web en php, si por consola, es
Hi,
postgresql version 8.25 running on RHEL4
Hopefully a quick answer. Went to drop a table:
drop table table_foo;
ERROR: cannot drop table table_foo because other objects depend on it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
Wanted to see what the dependencies were:
On Wed, 2009-02-18 at 13:55 -0200, Martín Marqués wrote:
And finally a question related with the instalation: are there debian
binaries to install replicator?
Not currently, but we are working on it.
Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org,
Hello,
I have a small problem following statement executes well do not give me
proper results, rather subquery calleing another function is not executed at
all.
*perform sometable.pk, (select * from somefunction) from sometable where
somecondition;*
But* select * from somefunction;* and
Aaron Burnett aburn...@bzzagent.com writes:
Hopefully a quick answer. Went to drop a table:
drop table table_foo;
ERROR: cannot drop table table_foo because other objects depend on it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
Wanted to see what the dependencies were:
Thanks Tom,
It was not supressed for notice, so I changed it to 'debug1' and it gave me
the answers I was looking for.
On 2/22/09 6:07 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Aaron Burnett aburn...@bzzagent.com writes:
Hopefully a quick answer. Went to drop a table:
drop table table_foo;
Este podria ser un problema con SELinux?
Prova:
/usr/sbin/getsebool -a | grep httpd
Busca:
httpd_can_network_connect_db
El valor de este directivo debe ser on
Se puede cambiar permanentemente con:
/usr/sbin/setsebool -P httpd_can_network_connect_db on
Suerte
Hey guys, we just moved our system to Amazon's EC2 service. I'm a bit
paranoid about backups, and this environment is very different than
our previous environment. I was hoping you guys could point out any
major flaws in our backup strategy that I may have missed.
A few assumptions:
1. It's OK
1. It's OK if we lose a few seconds (or even minutes) of transactions
should one of our primary databases crash.
2. It's unlikely we'll need to load a backup that's more than a few days
old.
How do you handle failover and falling back to the primary once it's up?
On Sun, Feb 22, 2009 at 7:30 PM, Tim Uckun timuc...@gmail.com wrote:
1. It's OK if we lose a few seconds (or even minutes) of transactions
should one of our primary databases crash.
2. It's unlikely we'll need to load a backup that's more than a few days
old.
How do you handle failover and
On Wed, Feb 11, 2009 at 11:24 PM, Serge Fonville
serge.fonvi...@gmail.comwrote:
Hi,
I am in the process of setting up a two node cluster.
Can PostgreSQL use DRBD as its storage?
Since the in-memory database would be synchronized with the on-disk
database.
If this would be done with every
Hi list,
We are running postgresql 8.3.5 and are trying to stress test our LMS.
The problem is when our stress tester (Jmeter) inserts around 10,000 rows
(in 3 hours) over 2 tables (5000 rows each table) the CPU of the sql server
hits 100% over all 4 cores for all future inserts.
I have tried
On Sun, Feb 22, 2009 at 11:55 PM, Jordan Tomkinson jor...@moodle.com wrote:
Hi list,
We are running postgresql 8.3.5 and are trying to stress test our LMS.
The problem is when our stress tester (Jmeter) inserts around 10,000 rows
(in 3 hours) over 2 tables (5000 rows each table) the CPU of
On Sun, Feb 22, 2009 at 11:55 PM, Jordan Tomkinson jor...@moodle.com wrote:
Hi list,
We are running postgresql 8.3.5 and are trying to stress test our LMS.
The problem is when our stress tester (Jmeter) inserts around 10,000 rows
(in 3 hours) over 2 tables (5000 rows each table) the CPU of
One last thing. You were doing vacuum fulls but NOT reindexing, right?
I quote from the document at google docs:
13:50:00vacuum full analyze on all databases through pgadmin
1: Do you have evidence that regular autovacuum isn't keeping up?
2: If you have such evidence, and you have to
On Mon, Feb 23, 2009 at 4:03 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Sun, Feb 22, 2009 at 11:55 PM, Jordan Tomkinson jor...@moodle.com
wrote:
Hi list,
We are running postgresql 8.3.5 and are trying to stress test our LMS.
The problem is when our stress tester (Jmeter) inserts
On Mon, Feb 23, 2009 at 4:08 PM, Scott Marlowe scott.marl...@gmail.comwrote:
One last thing. You were doing vacuum fulls but NOT reindexing, right?
I quote from the document at google docs:
13:50:00vacuum full analyze on all databases through pgadmin
1: Do you have evidence that
Hello,
the pgfoundry project seems to be the initial start of cybercluster
offered by CyberTec from Austria (German page:
http://www.postgresql-support.de/pr_cybercluster.html).
As far as I know this is a modified/adapted pgcluster solution.
We're very happy with pgpool-II for load-balancing and
On Mon, Feb 23, 2009 at 12:18 AM, Jordan Tomkinson jor...@moodle.com wrote:
On Mon, Feb 23, 2009 at 4:08 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
One last thing. You were doing vacuum fulls but NOT reindexing, right?
I quote from the document at google docs:
13:50:00
Oh yeah, what OS is this? Version and all that.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Feb 23, 2009 at 4:29 PM, Scott Marlowe scott.marl...@gmail.comwrote:
Oh yeah, what OS is this? Version and all that.
Red Hat Enterprise Linux 5.3 x64 kernel 2.6.18-128.el5
os and hardware details are in the google spreadsheet, you might have to
refresh it.
Im working on getting the
On Mon, Feb 23, 2009 at 4:29 PM, Scott Marlowe scott.marl...@gmail.comwrote:
Oh yeah, what OS is this? Version and all that.
I should probably clarify that the high cpu only exists while the jmeter
tests are running, once the tests are finished the cpu returns to 0% (this
isnt a production
hi,
i've been getting nonsensical error messages all day with
postgres 8.3 on winxpsp3. i tried upgrading to 8.3.6
(enterprisedb) and fresh installs.
i get either of the following errors:
PANIC: could not open control file
global/pg_control: Permission denied
postgres cannot access the
26 matches
Mail list logo