Carlos Henrique Reimer wrote:
I read some documents about replication and realized that if you plan
on using asynchronous replication, your application should be designed
from the outset with that in mind because asynchronous replication is
not something that can be easily “added on” after the
I need a little SQL help:
I'm trying to get a subselect working inside a view.
I have a table "class" that has related tables (a class has a
location, a location has an address with columns city, state, zip).
I want to use a VIEW to display columns related to a given class.
But a class can also
William Yu <[EMAIL PROTECTED]> writes:
> Allocation of unique IDs that don't collide across servers is a must. For 1
> project, instead of using numeric IDs, we using CHAR and pre-append a unique
> server code so record #1 on server A is A01 versus ?x01 on
> other
> servers. For
I know I am wadding into this discussion as an beginner compared to the rest who
have answered this thread, but doesn't something like pgpool provide relief for
pseudo-multimaster replication, and what about software like sqlrelay wouldn't
these suites help to some extent ? Looking forward to be
I answered my own question--if one upgrades the server, one must also
consider the consequences for the client (DBD::Pg). It had been compiled
using an older library that got removed when I upgraded.
Sean
On 8/24/05 4:31 PM, "Davis, Sean (NIH/NHGRI)" <[EMAIL PROTECTED]> wrote:
> I ran across t
Or, for something far easier, try
http://pgfoundry.org/projects/pgcluster/ which provides syncronous
multi-master clustering.
On Wed, Aug 24, 2005 at 12:53:34PM -0700, Jeff Davis wrote:
> Chris Browne wrote:
> >
> > Slony-I is a master/slave asynchronous replication system; if you
> > already con
On Wed, Aug 24, 2005 at 03:06:18PM -0400, Emi Lu wrote:
> Good afternoon,
>
> A question about varchar(1) and char(1).
> As a result, setup 'col1' to either "varchar(1)" or "char(1)" does not
> matter at all?
As far as storage goes, nope. Think about it, depending on your
encoding, 1 characte
unsubscribe
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Carlos Henrique Reimer wrote:
I read some documents about replication and realized that if you plan on
using asynchronous replication, your application should be designed from
the outset with that in mind because asynchronous replication is not
something that can be easily “added on” after the
Sean Davis <[EMAIL PROTECTED]> writes:
> I ran across this problem while running a plperlu procedure. I do not have
> a libpq.3.dylib, but do have a libpq.4.dylib. I am running perl 5.8.1,
> macos 10.3.8 on an Xserve G5, and Postgres 8.0.2. Any suggestions?
> dyld: /usr/local/pgsql/bin/postmast
Jeff Davis writes:
>The disadvantages:
one more: if you actually have m tables and n servers, you have
m x n tables in reality, which is pretty miserable scaling behavior.
i should think that rules, triggers, and embedded procedures would
explode in complexity rather rapidly.
i know i wouldn't w
Thanks, I found it.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake
Sent: Wednesday, August 24, 2005 12:18 PM
To: Chris Guo
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Start up script for Fedora Core 3
Chris Guo wrote:
> -->
Welty, Richard wrote:
> Jeff Davis writes:
>
>
>>The disadvantages:
>
>
> one more: if you actually have m tables and n servers, you have
> m x n tables in reality, which is pretty miserable scaling behavior.
> i should think that rules, triggers, and embedded procedures would
> explode in comp
Jeff Davis writes:
>>I hope this is helpful. Let me know if there's some reason my plan won't
>>work.
> look at the solution in pgreplicator. site ids are embedded in the
> id columns in the tables, so there only m tables, and a bit less insanity.
That doesn't work with Slony-I unfortunately.
Hey Christopher,
On Wed, Nov 12, 2003 at 11:42:56PM -0500, Christopher Murtagh wrote:
> On Wed, 2003-11-12 at 22:57, Alvaro Herrera wrote:
> > You are initializing the array incorrectly in your htdig(text, text)
> > function. {} is the hash reference you are seeing; HASH(0xwhatever) is
> > its te
Chris Guo wrote:
Dear all,
We are using Fedora Core 3 in our company, and we installed postgresql
8.0.3 as the database system. I wonder if anybody has the start up
script for this version so we can start postgresql service
automatically after we reboot the server.
Any help will be high
I ran across this problem while running a plperlu procedure. I do not have
a libpq.3.dylib, but do have a libpq.4.dylib. I am running perl 5.8.1,
macos 10.3.8 on an Xserve G5, and Postgres 8.0.2. Any suggestions? I
should mention that other db functions seem to work just fine.
>From psql:
sel
Chris Guo wrote:
-->
Dear all,
We are using Fedora Core 3 in our company, and we installed postgresql
8.0.3 as the database system. I wonder if anybody has the start up
script for this version so we can start postgresql service
automatically after we reboot the server.
If you installed
Chris Browne wrote:
>
> Slony-I is a master/slave asynchronous replication system; if you
> already considered it unsuitable, then I see little likelihood of
> other systems with the same sorts of properties being suitable.
>
> What could conceivably be of use to you would be a *multimaster*
> as
"Chris Guo" <[EMAIL PROTECTED]> writes:
> We are using Fedora Core 3 in our company, and we installed postgresql =
> 8.0.3
> as the database system. I wonder if anybody has the start up script for =
> this
> version so we can start postgresql service automatically after we reboot =
> the
> server.
Hello,
We have Fedora Core 4, but I'm pretty sure it's the same. To start the
service we use
/etc/rc.d/init.d/postgresql start
Now if you want postgresql to start automatically on boot you do:
chkconfig postgresql on
Read the man pages for chkconfig for more details.
Hope this helps.
On A
Can we see the schema for the tables RDD010 and RES_layers (including
keys)?
12 H for a million rows really sounds brutal (23 rows/sec).
I am guessing it can be done a lot faster using a join but I would like
to see more information about the tables involved in the query.
> -Original Messag
Good afternoon,
A question about varchar(1) and char(1).
If we have two tables
test1 (col1 varchar(1), ... ... );
test2 (col1 char(1), ... ... );
In the manuall, it written:
*Tip: * There are no performance differences between these three types,
apart from the increased storage size when using
Dear list,
we are using an oracle 10g and I have to convert the schema and german /
chinese data of the oracle to an postgres 8 database. To do that, I use the
ora2pg.pl (version 2.1) / OraPg.pm (version 3.3).
If I export the data with DATA or COPY the script will unfortunately export
only 7bi
Carlos Henrique Reimer
wrote:
> I read some documents about
replication and realized
> that if you plan on using asynchronous
replication, your
> application should be designed from the outset
with that
> in mind because asynchronous replication is
not something
> that can be easi
On Aug 24, 2005, at 6:00 AM, Jose Gonzalez Gomez wrote:
2005/8/24, Robert Treat <[EMAIL PROTECTED]>:
On Wednesday 24 August 2005 03:50, Jose Gonzalez Gomez wrote:
Googling a bit I have discovered that what I probably need is an ETL
(extract, transform and load) tool, preferably open sourced
Hi:
I have a query that uses one table with about 1 million rows. So far it
has been running for about 12h on a P4 3Ghz. The query/function does
this:
Esentially flattens some data. It looks through the values in a row,
does an if/else to categorize the value and update another table based
on the
Dear all,
We are using Fedora Core 3 in our company, and we installed postgresql
8.0.3 as the database system. I wonder if anybody has the start up script for
this version so we can start postgresql service automatically after we reboot
the server.
Any help will be highly appreciated.
I read some documents about replication and realized that if you plan on using asynchronous replication, your application should be designed from the outset with that in mind because asynchronous replication is not something that can be easily added on after the fact.
Am I right?
Reimer
__
Markus Wollny schrob:
> 0x40198cd4 in read () from /lib/i686/libc.so.6
> (gdb) p debug_query_string
> $1 = 137763608
>
> What am I doing wrong?
You are looking at the string's pointer. You could display it with
e.g.
printf "%s\n", debug_query_string
HTH
Andreas
[EMAIL PROTECTED] (Carlos Henrique Reimer) writes:
> Currently we have only one database accessed by the headquarter and
> two branches but the performance in the branches is very poor and
> I was invited to discover a way to increase it.
>
> One possible solution is replicate the headquarter DB
Jim C. Nasby wrote:
A better solution is to use a combination of a timestamp and a sequence.
Why both? Because it's possible for the clock to be set back (though
this is something best avoided), and a sequence will eventually roll
over.
With the default MAXVALUE of a postgresql sequence (9 qu
On Wed, Aug 24, 2005 at 09:50:06AM +0200, Jose Gonzalez Gomez wrote:
> Hi there,
>
> I have started working on a new place where they have a lot of medical
> data stored in relational databases they later exploit with
> statistical software. The situation is a bit chaotic as they're using
> a lot
Using pg 7.4.8 on RHEL4.
I produced a server.crt and server.key using the server computer, as described
in 7.4.8 docs section 16.7. As expected the log reports that root.crt was
not found during server startup. On connection, psql (8.0.3 on WinXP) reports
"SSL connection". Thus, SSL encryption seem
Hello!
As pg_stat_activity.current_query truncates statements to about 255
characters, I've tinkered a bit with gdb, as suggested by Tom Lane a
little while ago. But when I attach to the backend in question, the only
output I get from p debug_query_string is some number, for example:
mysrv:/var/l
Hello!
Is there any example could help in usage
of COPY BINARY since I am a little bit discouraged by this part of PG manual
==
To determine the appropriate binary format for the actual tuple data you should
consult the PostgreSQL source, in particular the *send and *recv functions for
each col
Phil Thornhill <[EMAIL PROTECTED]> writes:
> psql: could not connect to server: Connection refused (0x274D/10061)
> Is the server running on host "???" and accepting
> TCP/IP connections on port 5432?
> the laptop has a trendmicro firewall installed, but this is set to allow
>
On Tue, 23 Aug 2005, Rodrigo Africani wrote:
> Hi,
>
> I'm trying to import a sequence txt file.
> The file has fix columns ... i.e the first 10 positions is the primary key ...
> The comand copy need a delimitier but the file is seq without a delimitier.
> I look in the manual but i don't won't
ok, i already know that it's a table encoding problem. created new one
with unicode and i worked just fine. but i have another problem. how
can i change encoding in database which is already created?
Jarek
---(end of broadcast)---
TIP 1: if posting
sorry for posting that, i already found anwser. but i wonder if client
encoding will be enought to make changes i want to..
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if
Hi,
I have a problem with some portuguese characters like:
select translate('programação', 'aszzclóençã ',
'aszzcloenca+');
i get:
WARNING: ignoring unconvertible UTF-8 character 0xc3a3
and return is:
programaco
without 'a'
is this a problem with tabel encoding? or what? please help and
com
[mailto:[EMAIL PROTECTED] Behalf Of Michael Meskes
>Am Mittwoch, 24. August 2005 14:21 schrieb Carlos Henrique Reimer:
>> One possible solution is replicate the headquarter DB into the two
>> branches.
>> I read about slony-i, but then the replicated DBs will be read-only.
>That's because it's a
Am Mittwoch, 24. August 2005 14:21 schrieb Carlos Henrique Reimer:
> One possible solution is replicate the headquarter DB into the two
> branches.
>
> I read about slony-i, but then the replicated DBs will be read-only.
That's because it's a master-slave replication. If you could sync the slave
2005/8/24, Robert Treat <[EMAIL PROTECTED]>:
> On Wednesday 24 August 2005 03:50, Jose Gonzalez Gomez wrote:
> > Googling a bit I have discovered that what I probably need is an ETL
> > (extract, transform and load) tool, preferably open sourced and very
> > PostgreSQL friendly... does anybody on t
Hello,
Currently we have only one database accessed by the headquarter and two branches but the performance in the branches is very poor and I was invited to discover a way to increase it.
One possible solution is replicate the headquarter DB into the two branches.
I read about slony-i, but
On Wednesday 24 August 2005 03:50, Jose Gonzalez Gomez wrote:
> Googling a bit I have discovered that what I probably need is an ETL
> (extract, transform and load) tool, preferably open sourced and very
> PostgreSQL friendly... does anybody on this list have experience with
> such kind of tools? W
Sean Davis wrote:
On 8/24/05 7:24 AM, "Phil Thornhill" <[EMAIL PROTECTED]> wrote:
Hi,
I can't connect to a new installation of PostgreSQL 8.1 on a XP SP1 laptop.
Im trying to connect using psql in the laptop's command prompt. i keep
getting the following error message:
psql: se
On 8/24/05 7:24 AM, "Phil Thornhill" <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I can't connect to a new installation of PostgreSQL 8.1 on a XP SP1 laptop.
>
> Im trying to connect using psql in the laptop's command prompt. i keep
> getting the following error message:
>
> psql: server closed the
Hi,
I can't connect to a new installation of PostgreSQL 8.1 on a XP SP1 laptop.
Im trying to connect using psql in the laptop's command prompt. i keep
getting the following error message:
psql: server closed the connection unexplectedly
this probably means the server terminated
On 8/23/05 10:10 PM, "wolverine my" <[EMAIL PROTECTED]> wrote:
> Hi!
>
> I got the following psql's error when executing a script,
> ERROR: database "test" is being accessed by other users
>
> To solve this, I have to disconnect the database connection from the
> pgAdmin III.
>
> May I know ho
On Tue, Aug 23, 2005 at 11:36:31PM -0500, Jim C. Nasby wrote:
> A better solution is to use a combination of a timestamp and a sequence.
> Why both? Because it's possible for the clock to be set back (though
> this is something best avoided), and a sequence will eventually roll
> over. It's imposs
Jose Gonzalez wrote:
> The situation is a bit chaotic as they're using
> a lot of local Access databases, some databases hosted in an old
> version of Microsoft SQL Server and a lot of data in other non
> relational files (SPSS, Excel, ...). I was hoping to impose a bit of
> order and I started ins
Hi there,
I have started working on a new place where they have a lot of medical
data stored in relational databases they later exploit with
statistical software. The situation is a bit chaotic as they're using
a lot of local Access databases, some databases hosted in an old
version of Microsoft S
53 matches
Mail list logo
