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
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
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
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
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/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
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 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
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
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
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
[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
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
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
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
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
>
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
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
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
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
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
[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
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
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
__
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.
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
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
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
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
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
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
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
"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.
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 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
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.
Any help will be high
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
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.
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
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:
> -->
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
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
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
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
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
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
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
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
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 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
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
53 matches
Mail list logo
