On 01/11/11 09:58, daflmx wrote:
> Hello,everyone.
> I want to build a debian package from the source code.How should I
> do?please tell me the detailed steps.
> Thanks.
It depends on why. The usual answer is: "Don't, just install from the
debian repositories or backports.org".
Why do you need to
On 01/11/11 09:23, Gauthier, Dave wrote:
>
> Is there a way to pass the info (idsid, app, site) to the perl/dbi
> connection string and get this info reported in the deamon runlog
> somehow?
>
In newer versions of Pg you can use the application ID field. It's still
likely going to be another netwo
Craig Ringer writes:
> On 01/11/11 02:51, Gauthier, Dave wrote:
>> Does "reindex table foo" require no other users accessing the foo
>> table? Trying to understand why this seems to be stalled when I attempt
>> this on a live DB (if runs fine/fast on a copy of the DB that no one uses).
> Yes, it
On 01/11/11 02:51, Gauthier, Dave wrote:
> v8.3.4 on linux.
>
>
>
> Does "reindex table foo" require no other users accessing the foo
> table? Trying to understand why this seems to be stalled when I attempt
> this on a live DB (if runs fine/fast on a copy of the DB that no one uses).
Yes, it
Hello,everyone.
I want to build a debian package from the source code.How should I do?please
tell me the detailed steps.
Thanks.
fei
Hi:
PG v8.3.4 on linux. Server is at one corporate site, half the DB users are at
that site, the other half are at a different site 2 time zones away. Users
from both sites access the DB through the same, generic postgres user accout
that has select/insert/update/delete only. And almost all
On 10/31/2011 5:05 PM, David Johnston wrote:
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Bill Thoen
Sent: Monday, October 31, 2011 6:51 PM
To: Postgrresql
Subject: [GENERAL] Need Help With a A Simple Query That's Not So Simple
[...]
What I'd
On Thu, Oct 27, 2011 at 02:09:51PM -0600, Brian Fehrle wrote:
- On 10/27/2011 01:48 PM, Scott Marlowe wrote:
- >On Thu, Oct 27, 2011 at 12:39 PM, Brian Fehrle
- > wrote:
- >>Looking at top, I see no SWAP usage, very little IOWait, and there are a
- >>large number of postmaster processes at 100% cp
Thanks for sharing your experience and thoughts Venkat,
Venkat Balaji said:
> We are performing backups to our production server exactly the same way. We
> have been through some problems while restoring and bringing up the database.
> If you are planning to take initial complete rsync with sub
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Bill Thoen
Sent: Monday, October 31, 2011 6:51 PM
To: Postgrresql
Subject: [GENERAL] Need Help With a A Simple Query That's Not So Simple
I think this should be easy, but I can't seem to put the SQL t
I think this should be easy, but I can't seem to put the SQL together
correctly and would appreciate any help. (I'm using Pg 8.4 in CentOS
5.5, if that matters.)
I have a table of Farms and a table of crops in a 1:M relationship of
Farms : Crops. There are lots of different crops to choose for
v8.3.4 on linux.
Does "reindex table foo" require no other users accessing the foo table?
Trying to understand why this seems to be stalled when I attempt this on a live
DB (if runs fine/fast on a copy of the DB that no one uses).
Should I run this inside a transaction?
Thanks in Advance !
On Mon, 31 Oct 2011 09:41:40 -0500
Merlin Moncure wrote:
>On Mon, Oct 31, 2011 at 8:31 AM, Tarlika Elisabeth Schmitz
> wrote:
>> I have created a function log_insert(), which is simply a shorthand
>> for an INSERT table and which I want to call from various trigger
>> functions.
>>
>> CREATE OR R
Adrian Schreyer writes:
> I have added a GIST operator class to a custom data type in
> PostgreSQL. The index returns the correct results and the build speed
> is fairly good as well. There is one problem however that is
> presumably linked to the picksplit function (?) - the query planner
> alway
I have added a GIST operator class to a custom data type in
PostgreSQL. The index returns the correct results and the build speed
is fairly good as well. There is one problem however that is
presumably linked to the picksplit function (?) - the query planner
always returns half of all the rows in
2011/10/31 Merlin Moncure :
> On Mon, Oct 31, 2011 at 8:31 AM, Tarlika Elisabeth Schmitz
> wrote:
>> I have created a function log_insert(), which is simply a shorthand for
>> an INSERT table and which I want to call from various trigger functions.
>>
>> CREATE OR REPLACE FUNCTION log_insert(vseve
On Mon, Oct 31, 2011 at 8:31 AM, Tarlika Elisabeth Schmitz
wrote:
> I have created a function log_insert(), which is simply a shorthand for
> an INSERT table and which I want to call from various trigger functions.
>
> CREATE OR REPLACE FUNCTION log_insert(vseverity text, vtrigger text,
> vtrigger
I have created a function log_insert(), which is simply a shorthand for
an INSERT table and which I want to call from various trigger functions.
CREATE OR REPLACE FUNCTION log_insert(vseverity text, vtrigger text,
vtriggertable text, vtriggerid text, vmessage text) RETURNS boolean AS
$BODY$
BEGIN
On Mon, Oct 31, 2011 at 02:52:28PM +0100, Alban Hertroys wrote:
> 2011/10/30 Devrim GÜNDÜZ :
> >
> > I have no intention to build the -id packages again, given the lack of
> > request (first request since 8.3.11...). You can build your own packages
> > quite easily, though.
>
> But... aren't integ
2011/10/30 Devrim GÜNDÜZ :
>
> I have no intention to build the -id packages again, given the lack of
> request (first request since 8.3.11...). You can build your own packages
> quite easily, though.
But... aren't integer datetimes supposed to be the default, with float
datetimes quickly becoming
Hi,
On 31 October 2011 23:33, Debasis Mishra wrote:
> RHEL HA clustering is configured to have zero downtime. So if primary server
> is down then HeartBeat will bring secondary server online.
By "RHEL HA clustering" do you mean RedHat cluster suite? RHCS uses
SIGTERM and then kill -9 after 30 se
salve. pgsql-general
Sono felice di presentare una buona occasione per voi
fotocamera digitale, computer, orologi, phone.gultar se sieteinteressati ai nostri prodotti, siamo in grado di offrire il migliorprezzo per voi
luogo: bodoeo .com
2011-10-31 19:48:59
On Sun, Oct 30, 2011 at 11:28:52PM +0200, Devrim GÜNDÜZ wrote:
> I have no intention to build the -id packages again, given the lack of
> request (first request since 8.3.11...). You can build your own packages
> quite easily, though.
ok. fair enough. thanks.
Best regards,
depesz
--
The best t
Dear All,
I read the postgresql document for clustering. I am planning to go for the
shared disk fail over clustering.
But I am unable to understand propery how to achieve this.
Below is my hardware setup -
I have two server - Primary server and secondary server. Both the server
RHEL 6 is i
Hi,
Thanks for the info.
I've sorted out my problem by recreating the table and re-insert back the data
exclude the corrupted row into the newly create table. And went back to my old
backup to get back the data before it corrupt. I was lucky only 1 row affected.
Regards
Louis
>_
Hi all,
how can I install/use an extension form pgfoundry, namely this one:
http://pgfoundry.org/projects/pgchem/
it does not come with any kind of installation instructions. (note: for windows)
Best Regards,
Thomas
Στις Thursday 27 October 2011 11:00:10 ο/η Magnus Hagander έγραψε:
> On Wed, Oct 26, 2011 at 23:00, Darin Perusich wrote:
> > Are you able to specify multiple ldapservers in pg_hba.conf and if so
> > what is the format? I'd like to be able to build some redundancy incase
> > one of the ldap server
27 matches
Mail list logo