Hi,
I have configured PG master and slave to run under synchronous replication mode
and they are mostly working fine. Except during the setup phase. Please read
thru my setup, procedure and let me know if I am doing something stupid.
PG master :
wal_level = hot_standby
max_wal_senders = 5
On Tue, Jun 5, 2012 at 7:20 PM, Chris Curvey wrote:
>
>
> On Tue, Jun 5, 2012 at 6:24 PM, Mike Christensen wrote:
>>
>> Hi -
>>
>> I'm trying to increase my general knowledge about how indexes work in
>> databases. Though my questions are probably general and implemented
>> in a similar way acro
Rich Shepard wrote:
I'm surprised: that worked! I thought the WHERE clause was looking for
equivalency, not an assignment.
SQL generally uses "=" to mean equality test, but sometimes it also uses "=" to
mean assignment; it depends on the context; eg, in an UPDATE statement it can
have both
I have a postgres server I need to move onto a new OS (RHEL6) on a new VM
and am looking for advice on how to partition the disks to gain some
performance improvement.
In the current environment I am given a single VHDD which I have not
partitioned at all. The SAN performance is pretty good, but w
Hi John,
Thanks a lot.
Regards,
DP
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: Tuesday, June 05, 2012 11:28 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgresql support for window
On 06/05/2012 02:51 PM, Aleksander Rozman wrote:
Hi !
I am long time user of postgresql (on several platforms), and last month
I came across weird problem...
I started upgrade of Ubuntu and halfway through, upgrade failed... I was
forced to do clean install. After install all my databases were
On Tue, Jun 5, 2012 at 6:24 PM, Mike Christensen wrote:
> Hi -
>
> I'm trying to increase my general knowledge about how indexes work in
> databases. Though my questions are probably general and implemented
> in a similar way across major relational DBs, I'm also curious as to
> how they're impl
On 06/05/2012 04:49 PM, Rich Shepard wrote:
On Tue, 5 Jun 2012, David Johnston wrote:
As for the duplicate key I would first check to see if you are inserting
into a non-empty table and that one or more of your newly inserted
records
conflicts with existing records on the waterchem table. The e
-Original Message-
From: Mike Christensen [mailto:m...@kitchenpc.com]
Sent: Tuesday, June 05, 2012 4:28 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] I'd like to learn a bit more about how indexes work
I'm aware of how "B-Trees" work, but I only understand the
On Tue, 5 Jun 2012, David Johnston wrote:
As for the duplicate key I would first check to see if you are inserting
into a non-empty table and that one or more of your newly inserted records
conflicts with existing records on the waterchem table. The easiest way
would be to insert into a staging
SQL does not distinguish between equality and assignment (mainly because SQL
is declarative and thus there is never anything to actually assign to). IOW,
there is not "assignment" operator and "=" means "equality".
As for the duplicate key I would first check to see if you are inserting
into a non
I'm aware of how "B-Trees" work, but I only understand them on the
level of traversing a single tree at a time. I'm curious how Postgres
combines multiple indexes with OR and AND clauses.
I've done some Google searches, however I can't find anything basic.
Everything I've found assumes you alread
On Tue, 5 Jun 2012, Greg Williamson wrote:
Try a single equals sign, e.g. WHERE c.site = s.siteid
Greg,
I'm surprised: that worked! I thought the WHERE clause was looking for
equivalency, not an assignment.
There's another problem now that will be more difficult to fix. Postgres
tells me
Hello,
I new on this mailing list and I need a little bit help for an idea to create
different accesses to a database with Postgres 9.1.
I'm using this PG version at the time and I have created a database with a
scheme "storage". Within this schema are some
tables, datatypes and stored procedure
Rich --
> I want to combine columns in two tables and use the exported resulting
>table for statistical analyses. The SQL script is:
>
>INSERT INTO waterchem (site, sampdate, param, quant, ceneq1, low, high,
> stream, basin)
> SELECT c.site, c.sampdate, c.param, c.quant, c.ceneq1, c.low, c.
I want to combine columns in two tables and use the exported resulting
table for statistical analyses. The SQL script is:
INSERT INTO waterchem (site, sampdate, param, quant, ceneq1, low, high,
stream, basin)
SELECT c.site, c.sampdate, c.param, c.quant, c.ceneq1, c.low, c.high,
s.str
If you want to discover how B+Trees or B-Trees work, I suggest a web search. A
database like PostgreSQL is not going to use an ordinary btree for an index,
but they use special trees that have page level structures, such as B-Trees,
GiST trees, etc.For PostgreSQL the list includes {IIRC} B-
Hi -
I'm trying to increase my general knowledge about how indexes work in
databases. Though my questions are probably general and implemented
in a similar way across major relational DBs, I'm also curious as to
how they're implemented in Postgres specifically (mainly because I
like PG, and am al
Hi !
I am long time user of postgresql (on several platforms), and last month
I came across weird problem...
I started upgrade of Ubuntu and halfway through, upgrade failed... I was
forced to do clean install. After install all my databases were missing
(I also had to reinstall postgres, so
On Tue, 2012-06-05 at 18:59 +, Gauthier, Dave wrote:
> Hi: I think I know the answer to this, but the desire/need is great enough
> to get confirmation here.
>
> Is there a way to alias a db name for purposes of redirecting connections?
> For example, you have 2 DBs, DBX and DBY. The user
Hi: I think I know the answer to this, but the desire/need is great enough to
get confirmation here.
Is there a way to alias a db name for purposes of redirecting connections?
For example, you have 2 DBs, DBX and DBY. The users always connect to a DB
alias called "USEDB". USEDB points to D
> -Original Message-
> From: utsav [mailto:utsav.ps...@tcs.com]
> Sent: Monday, June 04, 2012 1:00 AM
> To: pgsql-general@postgresql.org
> Subject: Re: TYPE TABLE OF NUMBER
>
> No.. in this we have to define domain and than used it . Our
> requirenment is like application pass the array
On 06/05/12 6:38 AM, Divyaprakash Y wrote:
Hi,
Will the postgres be supported in the following Operating Systems?
1. Windows 8
2. Windows 2012 Server
wild guess (untested) says the current versions for win7/server 2007
will probably work, but undoubtably once those OS's are released,
t
Hello
probably you don't use memory well.
Can you show source code? Do you use PostgreSQL with asserts?
Regards
Pavel
2012/6/5 Jayashankar K B :
> Hi,
>
>
>
> We are facing one database crash issue because of stored procedures.
>
>
>
> When the stored procedure with a set of values is executed
Hi,
We are facing one database crash issue because of stored procedures.
When the stored procedure with a set of values is executed the first time, it
works fine.
If the same stored procedure is executed with same set of values once more, the
database crashes with the error
WARNING: terminati
I have configured a two-node 9.1 cluster with synchronous streaming
replication. In the event that the standby server fails, a daemon will
degrade the cluster by setting synchronous_standby_names to "" on the
master and reload the config. (My use case is such where availability is
preferred over
Jelastic PaaS gives you an opportunity to work with your databases
remotely via Public IP. Here’s an instruction for PostgreSQl users. It
will help you to connect to your database, backup and restore dumps
from your computer without having to login to our dashboard.
http://blog.jelastic.com/2012/06
Hi,
Will the postgres be supported in the following Operating Systems?
1. Windows 8
2. Windows 2012 Server
Regards,
DP
__
DISCLAIMER: This electronic message and any attachments to this electronic
Hi thomas .. Thanks for your help . I have done that thing . ]
It is working fine
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/TYPE-TABLE-OF-NUMBER-tp5710983p5711247.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-ge
On Tue, Jun 5, 2012 at 10:44 AM, wrote:
> Hello there,
>
>
>
> I have been searching for PostgreSQL 8.4+ version installable for RHEL6 – 64
> bit.
>
> I worked with PostgreSQL8.3 installable earlier and did installation using
> postgresql-8.3.7-1-linux-x64.bin file.
>
> Now I am trying for the sa
Hi,
On Tue, 2012-06-05 at 08:44 +, saimounika.j...@wipro.com wrote:
> Hello there,
>
> I have been searching for PostgreSQL 8.4+ version installable for RHEL6 - 64
> bit.
> I worked with PostgreSQL8.3 installable earlier and did installation using
> postgresql-8.3.7-1-linux-x64.bin file.
>
On 05/06/2012 11:44, saimounika.j...@wipro.com wrote:
Hello there,
I have been searching for PostgreSQL 8.4+ version installable for RHEL6
– 64 bit.
I worked with PostgreSQL8.3 installable earlier and did installation
using postgresql-8.3.7-1-linux-x64.bin file.
Now I am trying for the same fo
Hello there,
I have been searching for PostgreSQL 8.4+ version installable for RHEL6 - 64
bit.
I worked with PostgreSQL8.3 installable earlier and did installation using
postgresql-8.3.7-1-linux-x64.bin file.
Now I am trying for the same format installer for 8.4
But I am not able to find it anyw
Hi everyone,
I am interested in using a shared storage for a failover as decribed here:
http://wiki.postgresql.org/wiki/Shared_Storage.
Can you name any companies that already use such an approach? What
additional Software do they use (e.g. Linux Heartbeat)?
Thanks for your replies.
Am 31.05.2012 22:57, schrieb Scott Marlowe:
And don't be surprised if you find one not listed there.
For instance, my entire production system runs entirely on pl/bf
https://github.com/mikejs/pl-bf
It's really the only logical choice for critical and complex financial
analysis work.
yeah, w
35 matches
Mail list logo
