Chris <[EMAIL PROTECTED]> writes:
> Craig White wrote:
> > I am getting an error when I import, invalid input syntax for type
> > boolean - which is empty. Is there any way around this of must I
> > necessarily have \N ?
You could try with:
COPY ... WITH NULL AS ''
--
greg
Chris <[EMAIL PROTECTED]> writes:
> Jim Nasby wrote:
>> Actually, as long as you're not changing major versions (ie: 8.0.x to
>> 8.1.x) you'll be fine.
> I wasn't sure if changes like 8.1.x to 8.1.4 would cause a problem here:
We have a project policy that we *never* force initdb in a minor
rel
Jim Nasby wrote:
On May 31, 2006, at 9:18 PM, Chris wrote:
Edward Coyle wrote:
I want to move a windows server 2003 based postgres database from one
server to another server, can I just copy and paste the base folder
or do I have to do a backup and restore? If so what options work best
for cr
On Wed, May 31, 2006 at 15:34:46 -0500,
Edward Coyle <[EMAIL PROTECTED]> wrote:
> I want to move a windows server 2003 based postgres database from one server
> to another server, can I just copy and paste the base folder or do I have to
> do a backup and restore? If so what options work best for
On May 31, 2006, at 9:18 PM, Chris wrote:
Edward Coyle wrote:
I want to move a windows server 2003 based postgres database from
one server to another server, can I just copy and paste the base
folder or do I have to do a backup and restore? If so what options
work best for creating a file t
Craig White wrote:
I am getting an error when I import, invalid input syntax for type
boolean - which is empty. Is there any way around this of must I
necessarily have \N ?
They will have to be changed to nulls - the boolean type only allows
true, false or null:
http://www.postgresql.org/doc
Edward Coyle wrote:
I want to move a windows server 2003 based postgres database from one
server to another server, can I just copy and paste the base folder or
do I have to do a backup and restore? If so what options work best for
creating a file to move?
I think if you shut down postgresql
Craig White wrote:
strugging to import
I connect and am on the command line but I don't think I am in the right
schema. I have looked through the /h /? but can't seem to figure out how
to change to
database: th-db
schema: db
version: # rpm -q postgresql
postgresql-7.4.8-1.RHEL4.1
You'll need
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rafal Pietrak asked:
> 2. I admitt, that I should have spotted myself, that the
> DBD::Pg::PG_BYTEA might not have been recognized without the use
> clausure, but the driver itself understands prity much of the
> underlaying datatypes - I fon't need
Hi
Please, how I can create an insert (dynamic?) query from a PGresult
struct (libpq-fe.h) ? I create this PGresult with a PQexec(..SELECT *
FROM table..
and update ?
Any sample ?
thanks to all !
---(end of broadcast)---
TIP 2: Don't 'kill -
strugging to import
I connect and am on the command line but I don't think I am in the right
schema. I have looked through the /h /? but can't seem to figure out how
to change to
database: th-db
schema: db
version: # rpm -q postgresql
postgresql-7.4.8-1.RHEL4.1
Craig
-
John DeSoi wrote:
On May 31, 2006, at 10:40 AM, John DeSoi wrote:
Yes! Thanks very much -- I looked at that page several times and
missed regexp_replace.
Ok, now I know why I missed it. regexp_replace is only in PostgreSQL 8.1
and later. I'm stuck with 8.0 for hosting at the moment.
I'm
Chris Browne <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] ("Ramakrishna Reddy") writes:
>> We have very huge databases in many installations and infact have
>> plans for upgrading to latest releases. But as we are not very sure
>> about the stability of post 7.2.1 versions, refrained from doing
I am getting an error when I import, invalid input syntax for type
boolean - which is empty. Is there any way around this of must I
necessarily have \N ?
Craig
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
> > It should be easy to write user defined funtion and define your own
> > CONVERSION. CREATE CONVERSION is your friend.
>
> It looks like CREATE CONVERSION requires a C function to do the
> conversion. This will be used in a hosted environment -- I won't be
> able to add any C language func
[EMAIL PROTECTED] ("Ramakrishna Reddy") writes:
> Thanks for your vauable suggestions.
>
> We have very huge databases in many installations and infact have
> plans for upgrading to latest releases. But as we are not very sure
> about the stability of post 7.2.1 versions, refrained from doing
> t
[EMAIL PROTECTED] ("Merlin Moncure") writes:
> Xyratex
>From their web site, they sound like they'll be as challenging to get
straight answers from as any of the other disk array vendors :-(.
And there's nothing about what I see there that seems to address
anything at all about the "instability h
Eliana Providel wrote:
Hola a todos
Estoy trabajando con postgresql y tengo el siguiente problema
cuando intento listar todas las bases de datos existentes con "psql -l"
me sale el siguiente error:
ERROR: no existe la relación "pg_catalog.pg_user"
Puedo crear bases de datos y acceder a ellas
Your query is ambiguous.
Probably, you are looking for SLONY.
http://gborg.postgresql.org/project/slony1/projdisplay.php
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Greg
Sent: Wednesday, May 31, 2006 7:13 AM
To: pgsql-general@postgresql.o
I want to move a windows server 2003 based postgres database
from one server to another server, can I just copy and paste the base folder or
do I have to do a backup and restore? If so what options work best for creating
a file to move?
Edward Coyle
Intellecare, Inc.
Phone-972-919-900
Reid Thompson wrote:
PG_VERSION 8.1 - windows XP - 1GB RAM -- Desktop workstation, PG used
for test/dev.
This installation has been working fine for quite a while. I've used
it minimally.
I rebooted yestderday- log file from reboot
2006-05-18 12:24:32 LOG: database system was shut down at
Hola a todos
Estoy trabajando con postgresql y tengo el siguiente problema
cuando intento listar todas las bases de datos existentes con "psql -l"
me sale el siguiente error:
ERROR: no existe la relación "pg_catalog.pg_user"
Puedo crear bases de datos y acceder a ellas sin problema
Que puede
On Wed, May 31, 2006 at 02:10:38PM -0500, Tony Caduto wrote:
> Hi,
> I am working on a dependency/referenced by viewer and given a query like so:
> select refobjid from pg_depend where objid = 91640
>
> how do I determine what refobjid is? is there a function or something I
> have missed or do I
Hi,
I am working on a dependency/referenced by viewer and given a query like so:
select refobjid from pg_depend where objid = 91640
how do I determine what refobjid is? is there a function or something I
have missed or do I just run brute force queries against the system tables?
Thanks in adv
On 5/31/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> When we were trying to do DW stuff on Linux + Opteron + FibreChannel +
> EMC DiskArray, we too frequently found filesystems keeling over. It
> was neither cheap nor reliable.
I completely agree with the above statements with a small obje
I wrote:
> So basically 8.1 is being too optimistic about the value of ANDing
> multiple indexes. If you try setting enable_bitmapscan off, you'll
> probably find 8.1 beating 7.4 handily for this query. That's a really
> blunt-instrument solution of course, and I wouldn't recommend it for
> produ
On Wed, 2006-05-31 at 12:57, Ramakrishna Reddy wrote:
> Hi,
>
> Thanks for your vauable suggestions.
>
> We have very huge databases in many installations and infact have plans for
> upgrading to latest releases. But as we are not very sure about the stability
> of post 7.2.1 versions, refrai
[EMAIL PROTECTED] ("Joshua D. Drake") writes:
>> When we were trying to do DW stuff on Linux + Opteron + FibreChannel +
>> EMC DiskArray, we too frequently found filesystems keeling over. It
>> was neither cheap nor reliable.
>
> When is When? Not trying to start a flame war but I am curious as to
Hi,
Thanks for your vauable suggestions.
We have very huge databases in many installations and infact have plans for
upgrading to latest releases. But as we are not very sure about the stability
of post 7.2.1 versions, refrained from doing that. Could you please suggest me
which version is t
On Wed, 2006-05-31 at 06:47, Ramakrishna Reddy wrote:
> Hi,
>
> I need to connect to remote databases using Dblink. Our existing version is
> 7.2.1 on Windows and please point me the location of this package where I can
> download from and the installation procedure.
You should REALLY REALLY R
OK, thnx.
2006. 05. 31, szerda keltezéssel 13.24-kor John DeSoi ezt írta:
> Should be no problem, a lot of systems work like this. Also see
> pgpool which can be used to minimize the overhead of opening and
> closing connections.
>
> http://pgpool.projects.postgresql.org/
>
>
>
>
> On May
Should be no problem, a lot of systems work like this. Also see
pgpool which can be used to minimize the overhead of opening and
closing connections.
http://pgpool.projects.postgresql.org/
On May 31, 2006, at 11:36 AM, Bali László wrote:
I wanna make a web-based program.
The program sto
When we were trying to do DW stuff on Linux + Opteron + FibreChannel +
EMC DiskArray, we too frequently found filesystems keeling over. It
was neither cheap nor reliable.
When is When? Not trying to start a flame war but I am curious as to
your specifications to make this stuff work. Was it k
"Philippe Lang" <[EMAIL PROTECTED]> writes:
> Here are both EXPLAIN ANALYSE results, plus the query itself:
> Postgresql 7.4.5: http://www.attiksystem.ch/explain_analyze_74.txt
> Postgresql 8.1.4: http://www.attiksystem.ch/explain_analyze_81.txt
> Query is here: http://www.attiksystem.ch/big_query.
Hi:
Just a hunch:
What about adding an index to the field
etapes_lignes_commandes(code_etape). Assuming your database
uses C locales. This might work for your particular query
since your filter is something like code_etape~~'COMP%'.
What about increasing the settings of work_mem, etc (check
[EMAIL PROTECTED] ("Riccardo Inverni") writes:
> I have to update a Linux box with PostgreSQL on it, essentially
> for data warehousing purposes. I had set it up about 3 years ago and
> at that time the best solution I had been recommended was to use
> SCSI disks with hardware RAID controllers.
Hi,
I wanna make a web-based program.
The program stores the datas in a PG database. A lot of user can be, and
the filling of data web forms could take 30 sec -1 min.
My idea is to handle the connection between the C program and the
database: using only ONE PGuser, and at the beginig of data inser
I agree with you, but I will have two servers : one will be the file
server, the primary controller of the active directory, and the backup
of postgresql; the other one will be the postgresql server and the
backup of the file server and active directory.
So restoring from this situation does n
On May 31, 2006, at 10:40 AM, John DeSoi wrote:
Yes! Thanks very much -- I looked at that page several times and
missed regexp_replace.
Ok, now I know why I missed it. regexp_replace is only in PostgreSQL
8.1 and later. I'm stuck with 8.0 for hosting at the moment.
I'm sure it is not ve
jonathan harvey <[EMAIL PROTECTED]> writes:
> I am trying to get PostgreSQL 8.1.4 up and running on fedora core 5.
Have you started the service? If "ps auxww | grep postgres" doesn't
show some postgres-owned processes, you need
sudo /sbin/service postgresql start
You probably also want
Hi,
I have now disabled hyperthreading in /etc/grub.conf (added noht at the end
of kernel lines), rebooted the server, run ANALYSE on the database again,
and launched the query: things are even a little bit worse, it completes in
540 seconds now. So this is no ANALYSE or hyperthreading problem.
H
Bruno Wolff III a écrit :
On Wed, May 31, 2006 at 09:36:23 +0200,
Arnaud Lesauvage <[EMAIL PROTECTED]> wrote:
I am the only IT here, and my boss asked me to find a way to have
the database always online, without my intervention.
Last time I went on vacation, the server crashed and no one was
On Wed, May 31, 2006 at 09:36:23 +0200,
Arnaud Lesauvage <[EMAIL PROTECTED]> wrote:
> I am the only IT here, and my boss asked me to find a way to have
> the database always online, without my intervention.
> Last time I went on vacation, the server crashed and no one was
> able to repair it.
Philippe Lang wrote:
Hi,
For an unknown reason, I cannot post this message to the mailing-list!
Here it is:
http://www.attiksystem.ch/postgresql-general.txt
Please post query and table structure as well. And since you are using a
medium with no limitation on line lenght, unwrap the query pla
I am trying to get PostgreSQL 8.1.4 up and running on fedora core 5. Upon trying to add a user (I had to use the createuser command) I recieved this error: [EMAIL PROTECTED] postgresql-8.1.4]# createuser postgresShall the new role be a superuser? (y/n) ycreateuser: could not connect to database p
On May 31, 2006, at 9:17 AM, Nis Jorgensen wrote:
regexp_replace seems to do what you need:
http://www.postgresql.org/docs/8.1/static/functions-matching.html
Something like
regexp_replace (field, '[^\u-\u00FF]', '?', 'g')
Yes! Thanks very much -- I looked at that page several times and
"Philippe Lang" <[EMAIL PROTECTED]> writes:
> http://www.attiksystem.ch/postgresql-general.txt
Please provide EXPLAIN ANALYZE, not just EXPLAIN, output ... and try to
post it in an un-line-wrapped form.
Also, as Ludwig mentioned, a common gotcha is to forget to ANALYZE your
data after moving it t
On May 31, 2006, at 9:26 AM, Tatsuo Ishii wrote:
It should be easy to write user defined funtion and define your own
CONVERSION. CREATE CONVERSION is your friend.
It looks like CREATE CONVERSION requires a C function to do the
conversion. This will be used in a hosted environment -- I won'
Hi,
No, the only change I made in postgresql.conf is in order to have the
postmaster listen on the network, and change the default datestyle, just
like I did with all the other installations.
Philippe
-Message d'origine-
De : Ludwig Isaac Lim [mailto:[EMAIL PROTECTED]
Envoyé : mercredi,
Hi:
How about the postgresql.conf settings? Did you changed
them?
ludwig.
--- Philippe Lang <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I did not mention it in my first email, but I did run
> "ANALYSE" before
> running the query... So statistics are just fine for the
> execution plan
> engine.
>
I am creating a Windows Forms App that uses PGSQL 8.1.4 for
the database. The database will be installed on the client, and the server.
I will only need to keep a few tables, not the whole
database synchronised. Is it better to manage this with my app?, or does PGSQL
support some decent sy
At 10:38 AM 5/31/2006 +0200, Magnus Hagander wrote:
Since you're a Windows shop, you may already have the experience (and
even liceneses perhaps?) to run Microsoft Cluster Service (part of 2003
Enterprise Edition or 2000 Advanced Server). PostgreSQL will work fine
with it. Works with shared disk
Hi,
I did not mention it in my first email, but I did run "ANALYSE" before
running the query... So statistics are just fine for the execution plan
engine.
Philippe
-Message d'origine-
De : Ludwig Isaac Lim [mailto:[EMAIL PROTECTED]
Envoyé : mercredi, 31. mai 2006 15:52
À : Philippe Lan
Arnaud Lesauvage wrote:
> Hi list !
>
> I have a small enterprise network (~15 workstations, 1 server), all
> running windows OSes. Most of our work is done on a PostgreSQL DB (on
> the windows server).
> I am the only IT here, and my boss asked me to find a way to have the
> database always onlin
Hi :
Maybe you forget to run the "ANALYZE" command afterwards.
ludwig.
--- Philippe Lang <[EMAIL PROTECTED]> wrote:
> Hi,
>
> For an unknown reason, I cannot post this message to the
> mailing-list!
>
> Here it is:
>
> http://www.attiksystem.ch/postgresql-general.txt
>
> Cheers,
>
> Phi
> >Since you're a Windows shop, you may already have the
> experience (and
> >even liceneses perhaps?) to run Microsoft Cluster Service
> (part of 2003
> >Enterprise Edition or 2000 Advanced Server). PostgreSQL will
> work fine
> >with it. Works with shared disks using either fibrechannel or
Stuart Bishop a écrit :
If your application is normally reliable, I think the best, cheapest and
simplest way of keeping the system online when you are on leave is to give
your work the phone number of a company offering PostgreSQL support
services. I would avoid adding the extra complexity and a
> I have a client that only supports Latin-1 and needs to connect to a
> UTF-8 database to retrieve some data. Some columns may contain
> characters that have no Latin-1 equivalent. I would like to convert
> these to a blank or perhaps some hex value. Is there any way to do
> this in Postgr
Bruce Momjian wrote:
Pit M�ller wrote:
Hello !
We have a very sophisticated setup for our software which needs to
install databases on a PostgreSQL Server if the user chooses PG as
database system. This setup worked fine on 8.1 to 8.1.3 but fails now
with 8.1.4. It looks like the problem i
On Wednesday 31 May 2006 07:51 am, Tino Wildenhain <[EMAIL PROTECTED]> thus
communicated:
--> Philippe Lang schrieb:
--> > Hi,
--> ...
--> > Can anyone read this message?
-->
--> No, sorry. Please repost.
-->
--> Thx
--> Tino .-)
-->
:oD
---(end of broadcast)-
On May 31, 2006, at 5:17 AM, Nis Jorgensen wrote:
You should be able to do this with regular expressions
(substituting all
invalid chars) on the text columns of the result set(s). I write
"should be", since I don't remember the capabilities of pg regular
expressions.
I thought about this
In the last exciting episode, dpage@vale-housing.co.uk ("Dave Page") wrote:
> If I'm honest, I think your boss is going to be disappointed. You
> would add a *lot* of complexity to the system to make it handle
> failures with zero intervention, and that extra complexity is
> probably more likely to
Hi,
For an unknown reason, I cannot post this message to the mailing-list!
Here it is:
http://www.attiksystem.ch/postgresql-general.txt
Cheers,
Philippe Lang
smime.p7s
Description: S/MIME cryptographic signature
Tino Wildenhain a écrit :
If I understand you right, you suggest that the wal files should be
automatically copied to the backup server, which should parse them as
soon as they arrive ?
eactly.
Indeed, it seems to be the best solution !
After reading the backup-online page, I see that the re
This is really strange... Is there an anti-spam software runnning on the
mailing-list server? Or maybe my english is too bad for the server...
Does anyone have access to the /var/maillog of the mailing-list server?
-Message d'origine-
De : Dave Page [mailto:[EMAIL PROTECTED]
Envoyé : me
Hi,
I need to connect to remote databases using Dblink. Our existing version is
7.2.1 on Windows and please point me the location of this package where I can
download from and the installation procedure.
Thanks,
RamaKrishna.
---(end of broadcast)
Dave Page a écrit :
Ah, but wasn't this intended for when you are not there standing over them with
a bat?
:-)
It was, but they know I will come back from vacation one day, and
then
;-)
--
Arnaud
---(end of broadcast)---
TIP 1: if pos
Philippe Lang schrieb:
Hi,
...
Can anyone read this message?
No, sorry. Please repost.
Thx
Tino .-)
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Philippe Lang
> Sent: 31 May 2006 12:33
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Problems posting messages in this mailing-list?
>
> Hi,
>
> I'm desperately trying to post a message
> -Original Message-
> From: Arnaud Lesauvage [mailto:[EMAIL PROTECTED]
> Sent: 31 May 2006 12:33
> To: Dave Page
> Cc: Tino Wildenhain; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Best high availability solution ?
>
> Dave Page a écrit :
> > Yes - the DNS method would work,
Hi,
I'm desperately trying to post a message to this mailing-list since 10
o'clock this morning, although everything worked fine yesterday. I get no
error indicated my message is rejected, but nothing appears in the list.
Can anyone read this message?
--
Philippe
Dave Page a écrit :
Yes - the DNS method would work, but you might run into caching issues
requiring the users to reboot or do a 'ipconfig /flushdns' before they
see the change.
Yes, but I am not a very nice adminsitrator, and when there is any
problem with a datawase, my users HAVE to reboot
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Tino
> Wildenhain
> Sent: 31 May 2006 12:14
> To: Arnaud Lesauvage
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Best high availability solution ?
>
> > Then with a script that would
Arnaud Lesauvage schrieb:
Tino Wildenhain a écrit :
personally I think the WAL approach is by far easier
to set up and maintain - the pg_dump is in fact easy,
but the restore to another database can be tricky
if you want it unattended and bullit-proof the same
time.
I'll have to study this m
Dave Page a écrit :
http://developer.pgadmin.org/~hiroshi/Slony-I/
That's built against 8.1 iirc.
Great !
USE AT YOUR OWN RISK!! IT MAY EAT YOUR DATA AND SET YOUR SERVER ON FIRE :-)
I'll keep an eye on it then ! ;-)
--
Arnaud
---(end of broadcast)-
Tino Wildenhain a écrit :
personally I think the WAL approach is by far easier
to set up and maintain - the pg_dump is in fact easy,
but the restore to another database can be tricky
if you want it unattended and bullit-proof the same
time.
I'll have to study this more in-depth then.
If I got i
> -Original Message-
> From: Arnaud Lesauvage [mailto:[EMAIL PROTECTED]
> Sent: 31 May 2006 11:53
> To: Dave Page
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Best high availability solution ?
>
> Dave Page a écrit :
> > The code is written, and is good as far as we are
Dave Page a écrit :
The code is written, and is good as far as we are aware, but has not been
through a beta/release cycle yet.
OK, that's already pretty good then.
Are there binary releases available ?
Is there a simple replication solution for windows then ? Or will
I have to stop the mast
Arnaud Lesauvage schrieb:
Tino Wildenhain a écrit :
pg_dump does not require you to stop the master database anyway.
(in fact it cannot even dump a stopped database :-)
Hello Tino,
I think I might just use this pg_dump solution...
Seems to be quite simple to set up.
personally I think the
> -Original Message-
> From: Arnaud Lesauvage [mailto:[EMAIL PROTECTED]
> Sent: 31 May 2006 11:27
> To: Dave Page
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Best high availability solution ?
>
> Dave Page a écrit :
> > Slony-I only exists for Windows in a not-even-beta
Arnaud Lesauvage schrieb:
...
I think you're right.
Is there a simple replication solution for windows then ? Or will I have
to stop the master postgresql at night to pgdump and pgrestore on the
backup server ?
pg_dump does not require you to stop the master database anyway.
(in fact it cann
On Wed, May 31, 2006 at 11:31:28AM +0200, Daniel Verite wrote:
> Martijn van Oosterhout wrote:
>
> > However, there is a solution: send the paramters seperate from the
> > query. In fact, postgres has been able to do that for a while now but
> > not all interfaces have been made to use it. M
Dave Page a écrit :
Slony-I only exists for Windows in a not-even-beta state at the moment,
so even if you get things up and running using a virtual IP solution you
will be hand-holding Slony until it gets properly released.
OK, I thought it was in production stage.
If I'm honest, I think you
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Arnaud Lesauvage
> Sent: 31 May 2006 10:39
> To: Magnus Hagander
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Best high availability solution ?
>
> Otherwise, is the clustering ser
Pit M?ller wrote:
> Hello !
> We have a very sophisticated setup for our software which needs to
> install databases on a PostgreSQL Server if the user chooses PG as
> database system. This setup worked fine on 8.1 to 8.1.3 but fails now
> with 8.1.4. It looks like the problem is caused by CREAT
Magnus Hagander a écrit :
Since you're a Windows shop, you may already have the experience (and
even liceneses perhaps?) to run Microsoft Cluster Service (part of 2003
Enterprise Edition or 2000 Advanced Server). PostgreSQL will work fine
with it. Works with shared disks using either fibrechannel
Martijn van Oosterhout wrote:
> However, there is a solution: send the paramters seperate from the
> query. In fact, postgres has been able to do that for a while now but
> not all interfaces have been made to use it. My guess is that those
> other databases you've used were already doing
Hello,
3 weeks ago I install a PostgreSQL 8.1.3 server on
Windows 2003 server standar edition.
The box is a NEC express5800 TM800 with 4 SATA/300
250 Gb 7200 rpm in RAID10 (0+1).
It works fine, faster than the old server ALTOS
with SCSI-3 disks Ultra160 1 rpm.
I upgraded to 8.1.4.
The e
John DeSoi wrote:
I have a client that only supports Latin-1 and needs to connect to a
UTF-8 database to retrieve some data. Some columns may contain
characters that have no Latin-1 equivalent. I would like to convert
these to a blank or perhaps some hex value. Is there any way to do this
in P
On Tue, 2006-05-30 at 22:47 +0200, Martijn van Oosterhout wrote:
> That's why bytea need special encoding to get around this check.
But may be you would know, why I should write:
{ pg_type => DBD::Pg::PG_BYTEA }
instead of possibly more generic:
{ TYPE => SQL_BINARY }
The later
> Hi list !
>
> I have a small enterprise network (~15 workstations, 1
> server), all running windows OSes. Most of our work is done
> on a PostgreSQL DB (on the windows server).
> I am the only IT here, and my boss asked me to find a way to
> have the database always online, without my interve
Markus Schiltknecht a écrit :
Hi Arnaud,
perhaps you can still use Slony-I for replication and have another tool
automatically handle connections (check out PgPool[1] or SQLRelay[2]).
Or go for a middleware replication solution. Check C-JDBC[3], perhaps
there is something similar for ODBC?
Lif
> The latest version (V8.1.4) breaks the setup process of our
> application's installation wizard. We used to call
> "createdb.exe" and piped the password for the postgres user
> (which has been entered by the user in our setup wizard's
> dialogs) into it.
>
> With version V8.1.4 this is not p
Hi Arnaud,
perhaps you can still use Slony-I for replication and have another tool
automatically handle connections (check out PgPool[1] or SQLRelay[2]).
Or go for a middleware replication solution. Check C-JDBC[3], perhaps
there is something similar for ODBC?
LifeKeeper seems to handle replicat
Hi list !
I have a small enterprise network (~15 workstations, 1 server),
all running windows OSes. Most of our work is done on a PostgreSQL
DB (on the windows server).
I am the only IT here, and my boss asked me to find a way to have
the database always online, without my intervention.
Last t
Hello !
We have a very sophisticated setup for our software which needs to
install databases on a PostgreSQL Server if the user chooses PG as
database system. This setup worked fine on 8.1 to 8.1.3 but fails now
with 8.1.4. It looks like the problem is caused by CREATEDB, which seems
to hang.
96 matches
Mail list logo
