Hi folks
First time poster here so please extend grace if I don't initially
provide what is needed to help.
I am running postgresql 8.3.7 on debian lenny
(postgresql-8.3_8.3.7-0lenny1_i386.deb).
I have three of these servers and generally they run well.
On this one server if I use the co
m the problem server,
grabbed all the config lines and submitted them one at a time (again
with a script) and it also
worked fine.
regards
Grant Maxwell
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
On 11/09/2009, at 8:17 AM, Tom Lane wrote:
Grant Maxwell writes:
On 11/09/2009, at 1:09 AM, Richard Huxton wrote:
Hmm - some modules can provide their own config variables. Do you
have
the same modules installed in all three servers?
How can I determine what modules are
On 11/09/2009, at 8:36 AM, Tom Lane wrote:
Grant Maxwell writes:
On the problem server:
shared_preload_libraries = 'pgmemcache'
#local_preload_libraries = ''
on the others both are emply.
Sounds like a smoking gun to me.
For good measure I remove
Hi Folks
I'm looking for a bit of advice regarding alpha primary keys.
I have a table (designed by someone else) that has a numeric primary
key and also a unique non-null email address field.
The use of the primary key is causing me some headaches in that in
multiple database server envir
On 13/09/2009, at 2:46 AM, Tom Lane wrote:
Grant Maxwell writes:
I don't know why it was done this way but it seems to me that the
email addresses are unique, non null and could be used as the primary
key. This would make the replication much faster and simpler.
Does anyone out
elp
Grant
On 11/09/2009, at 9:09 AM, Grant Maxwell wrote:
On 11/09/2009, at 8:36 AM, Tom Lane wrote:
Grant Maxwell writes:
On the problem server:
shared_preload_libraries = 'pgmemcache'
#local_preload_libraries = ''
on the others both are emply.
Sou
On 25/09/2009, at 12:50 PM, Selena Deckelmann wrote:
On Thu, Sep 24, 2009 at 8:09 AM, Cédric Villemain
wrote:
Le jeudi 24 septembre 2009, Selena Deckelmann a écrit :
Hi!
On Wed, Sep 23, 2009 at 10:11 AM, Bryan Montgomery >
wrote:
Hi,
I'm looking for a way to replicate am master database t
Hi Folks
According to the 8.3 docs I should be able to write:
select * from tblretrain where 'ms-ap-t2-02c9' NOT IN (owners);
where owners is an array per the following definition
CREATE TABLE tblretrain
(
pkretrainid integer NOT NULL,
mailid integer NOT NULL,
train_to smallint NOT NU
nd both returned an empty row set.
regards
Grant
On 28/09/2009, at 11:42 AM, Tom Lane wrote:
Grant Maxwell writes:
According to the 8.3 docs I should be able to write:
select * from tblretrain where 'ms-ap-t2-02c9' NOT IN (owners);
where owners is an array per the following definiti
10 matches
Mail list logo
