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
Certificati
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 in
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:
BE
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, devrim.gunduz~linu
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 *perfor
Aaron Burnett 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:
> BEGIN;
> drop t
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" wrote:
> Aaron Burnett writes:
>> Hopefully a quick answer. Went to drop a table:
>
>> drop table table_foo;
>> ERROR: cannot drop table tab
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 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 falling ba
On Wed, Feb 11, 2009 at 11:24 PM, Serge Fonville
wrote:
> 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 query, this would gre
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 num
On Sun, Feb 22, 2009 at 11:55 PM, Jordan Tomkinson 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 the sql server
On Sun, Feb 22, 2009 at 11:55 PM, Jordan Tomkinson 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 the sql server
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 wrote:
> On Sun, Feb 22, 2009 at 11:55 PM, Jordan Tomkinson
> 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 h
On Mon, Feb 23, 2009 at 4:08 PM, Scott Marlowe wrote:
> 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
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 wrote:
>
>
> On Mon, Feb 23, 2009 at 4:08 PM, Scott Marlowe
> wrote:
>>
>> 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 dat
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 wrote:
> 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 SQL log for you now.
On Mon, Feb 23, 2009 at 4:29 PM, Scott Marlowe wrote:
> 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 server yet, so no other
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
