Hi Victor
Le 9/11/2010 5:22, Victor Hooi a écrit :
Has anybody had any experiencing doing a similar port (Access 2007 to
Postgres) recently, what tools did you use, were there any gotchas you hit
etc? Or just any general advice at all here?
We recently migrated from MSAccess 2000 to PostgreSQL
Le 14/04/2011 10:54, John R Pierce a écrit :
On 04/14/11 1:35 AM, Henry C. wrote:
Hint: don't use cheap SSDs - cough up and use Intel.
aren't most of the Intel SSD's still MLC, and still have performance and
reliability issues with sustained small block random writes such as are
generated by
Hi all,
I just came accross this trying to upgrade my server from 8.4.8 to 9.3.4 :
SELECT substring('²' FROM E'\\d');
8.4 : NULL
9.3 : "²"
Am I correct to expect NULL in this case ?
Thanks !
--
Arnaud
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
Le 1/09/2014 15:42, Albe Laurenz a écrit :
Arnaud Lesauvage wrote:
I just came accross this trying to upgrade my server from 8.4.8 to 9.3.4 :
SELECT substring('²' FROM E'\\d');
8.4 : NULL
9.3 : "²"
Am I correct to expect NULL in this case ?
I get a different r
Le 1/09/2014 17:39, Tom Lane a écrit :
Arnaud Lesauvage writes:
I just came accross this trying to upgrade my server from 8.4.8 to 9.3.4 :
SELECT substring('²' FROM E'\\d');
8.4 : NULL
9.3 : "²"
Am I correct to expect NULL in this case ?
Not necessarily
Le 1/09/2014 18:11, Tom Lane a écrit :
Arnaud Lesauvage writes:
Le 1/09/2014 17:39, Tom Lane a écrit :
Not necessarily. \d will match any character that iswdigit() returns true
for. It looks like your new server is using a locale that considers "²"
to be a digit.
Since both
mygeom FROM mytemptable"
So I guess there is a problem with my 'upper' conversion, but I have no
idea what this 0xc29f character could be.
Any help would be greatly appreciated.
Thanks a lot !
--
Arnaud Lesauvage
--
Sent via pgsql-general mailing list (pgsql-general@
Raymond O'Donnell a écrit :
If it's any help to you, you can get iconv (and a bunch of other helpful
stuff) from GnuWin32:
http://gnuwin32.sourceforge.net/
Thanks for your help Raymond.
I tried iconv but I have other problems now.
I still have to load the file into postgresql because the sh
Arnaud Lesauvage a écrit :
But then, if I dump it through a query to have my field in uppercase, I
get an error 'character 0xc29f of encoding UTF8 has no equivalent in
WIN1252' (translated by myself, the message is in French)
The command is simply :
pgsql2shp -f myouput.shp -u p
InterRob a écrit :
>> Arnaud Lesauvage a écrit :
>> Also, doing a search like :
>> SELECT * FROM mytable WHERE upper(myflied) ILIKE u&'%c29f%';
>> Gives me 0 result.
>> Am I wrong to think that the error 'character 0xc29f of UTF8' relates
&
Le 14/04/2011 11:40, Henry C. a écrit :
You have a valid point about using SLC if that's what you need though.
However, MLC works just fine provided you stick them into RAID1. In fact, we
use a bunch of them in RAID0 on top of RAID1.
AFAIK, you won't have TRIM support on RAID-arrayed SSDs.
Tha
TRUE, FALSE) TO stdout CSV
1,test,foo,bar,t,f
What am I missing here ?
Thanks for your help !
Regards
--
Arnaud Lesauvage
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Le 29/06/2010 14:40, Sam Mason a écrit :
On Tue, Jun 29, 2010 at 02:24:00PM +0200, Arnaud Lesauvage wrote:
I'd like to generate CSV files from the output of a query.
I can't get the srings in the output to be quoted though. I thought that
this was the default for CSV, and even
equivalent in LATIN9.
How could I easily write a CONSTRAINT (or RULE) that would check that
everything entered in the fields have an equivalent in my specific
destination encoding ?
Thanks for any hints on this !
Regards
--
Arnaud Lesauvage
--
Sent via pgsql-general mailing list (pgsql-general
cept, and test form input for the length
being zero after the translate function has applied.
Regards
HJR
On Wed, Jun 30, 2010 at 12:52 AM, Arnaud Lesauvage
wrote:
Hi list !
We have a database in UTF8, from which we have to export text files in
LATIN9 encoding (or WIN1252, which is almos
Le 1/07/2010 16:48, Sam Mason a écrit :
On Tue, Jun 29, 2010 at 04:52:22PM +0200, Arnaud Lesauvage wrote:
We have a database in UTF8, from which we have to export text files in
LATIN9 encoding (or WIN1252, which is almostthe same I believe).
Records are entered via MSAccess forms (on
Le 1/07/2010 17:12, Sam Mason a écrit :
On Thu, Jul 01, 2010 at 04:53:51PM +0200, Arnaud Lesauvage wrote:
Le 1/07/2010 16:48, Sam Mason a écrit :
How about using the built in character conversion routines. Something
like:
col = convert_from(convert_to(col, 'LATIN9'),'LA
work around this ?
I am not sure this is really normal, since the restored database's
strucure is not matching perfectly the original one's.
Thanks a lot for your thoughts and help on this matter.
Regards,
Arnaud Lesauvage
--
Sent via pgsql-general mailing list (pgsql-general@post
Le 6/07/2010 16:22, Tom Lane a écrit :
Arnaud Lesauvage writes:
After some research, we found in psqlODBC's log that before the restore
psqlODBC was getting the sequence's nextval with a schema qualified
call, and after the restore the call was not schema qualified.
I checked in
Le 6/07/2010 17:17, Tom Lane a écrit :
Arnaud Lesauvage writes:
As you have understood, I am not very savvy about postgresql's
internals, but from what you say my guess is that the problem is int the
psqlODBC is getting the default value of the sequence ?
I have no idea, becaus
Le 6/07/2010 17:17, Tom Lane a écrit :
Arnaud Lesauvage writes:
As you have understood, I am not very savvy about postgresql's
internals, but from what you say my guess is that the problem is int the
psqlODBC is getting the default value of the sequence ?
I have no idea, becaus
db --lc-collate="Anglais
(États-Unis)" -> ERREUR: nom de locale « Anglais (États-Unis) »
invalide, locale name invalid).
I tried with collation "C" and encoding "UTF8", but is not good at all
since it sorts lowercase letters after uppercase ones.
Thanks in advan
Hi all !
PostgreSQL 8.4 here.
I have a simple update query that looks like this :
UPDATE t1
SET col = t2.col
FROM t2
WHERE t1.key1 = t2.key1 AND t1.key2 = t2.key2;
There is an index on (key1,key2) on the joined table (t2).
This query does not use the index.
If I rewrite it with a subselect, t
Le 16/03/2010 14:50, Richard Huxton a écrit :
On 16/03/10 13:05, Arnaud Lesauvage wrote:
PostgreSQL 8.4 here.
I have a simple update query that looks like this :
UPDATE t1
SET col = t2.col
FROM t2
WHERE t1.key1 = t2.key1 AND t1.key2 = t2.key2;
There is an index on (key1,key2) on the
Le 16/03/2010 15:25, Richard Huxton a écrit :
OK - we have a merge join in the first case where it joins the
pre-sorted output of both tables.
In the second case it queries the index once for each row in "cellules".
Now look at the costs. The first one is around 704,000 and the second
one is 5,
Le 16/03/2010 15:37, Tom Lane a écrit :
Arnaud Lesauvage writes:
First query :
"Merge Join (cost=699826.38..704333.80 rows=13548 width=836)"
" Merge Cond: (((c.rue)::text = (r.rue)::text) AND ((c.codesite)::text
= (r.codesite)::text))"
Second query :
"Seq
Le 16/03/2010 16:02, t...@fuzzy.cz a écrit :
I will try increasing work_mem, but it is already set at 16MB which I
found is quite high.
What do you mean by "high"? I believe the proper value of work_mem is such
that results in highest performance of the query while not causing
problems to the
Le 16/03/2010 16:52, Tom Lane a écrit :
Sometime in the future they might generate the same plan. Right now the
planner's ability to optimize sub-SELECTs is pretty limited, and so you
typically get a nestloop-like plan even if some other join style would
be faster.
OK, thanks for the clarifica
Hi List !
I need to add a column to a view, which would contain an automatically
generated sequence.
An automatic row numbering would do the trick (I only need unique
numbers, that's all), but I don't even know how to achieve this.
Does anybody have a solution for this problem ?
Thanks a lot !
-
Merlin Moncure a écrit :
On 10/10/06, Arnaud Lesauvage <[EMAIL PROTECTED]> wrote:
Hi List !
I need to add a column to a view, which would contain an automatically
generated sequence.
An automatic row numbering would do the trick (I only need unique
numbers, that's all), but I don&
Hi List !
I need to add a column to a view, which would contain an automatically
generated sequence.
An automatic row numbering would do the trick (I only need unique
numbers, that's all), but I don't even know how to achieve this.
Does anybody have a solution for this problem ?
Thanks a lot
Hi List !
I am trying to remove accents from a string. I found a nice
solution for this on postgresqlfr, using the to_ascii()
function.
Now, the problem I have is :
mydb=# SELECT to_ascii(convert('abcdef', 'LATIN9'));
ERROR: encoding conversion from UTF8 to ASCII not supported
Why is the c
Albe Laurenz a écrit :
I am trying to remove accents from a string. I found a nice
solution for this on postgresqlfr, using the to_ascii()
function.
Now, the problem I have is :
mydb=# SELECT to_ascii(convert('abcdef', 'LATIN9'));
ERROR: encoding conversion from UTF8 to ASCII not supported
Hi all !
I am trying to exclude just one schema of my dump.
pg_dump -N myschema
or
pg_dump --exclude-schema=myschema
both tell me that the option is unknown.
I am using the win32 binary distribution v8.1.4 (pg_dump
--version says 8.1.4 too).
Is this normal ?
Thanks !
--
Arnaud
Richard Huxton a écrit :
Arnaud Lesauvage wrote:
Richard Huxton a écrit :
Arnaud Lesauvage wrote:
Hi all !
I am trying to exclude just one schema of my dump.
pg_dump -N myschema
or
pg_dump --exclude-schema=myschema
both tell me that the option is unknown.
It's not in 8.1 - you must
Richard Huxton a écrit :
Arnaud Lesauvage wrote:
Hi list !
I already posted this as "COPY FROM encoding error", but I have been
doing some more tests since then.
I'm trying to export data from MS SQL Server to PostgreSQL.
The tables are quite big (>20M rows), so a CSV
Tomi NA a écrit :
I think I'll go this way... No other choice, actually !
The MSSQL database is in SQL_Latin1_General_CP1_Cl_AS.
I don't really understand what this is. It supports the euro
symbol, so it is probably not pure LATIN1, right ?
I suppose you'd have to look at the latin1 codepage ch
Richard Huxton a écrit :
Arnaud Lesauvage wrote:
Richard Huxton a écrit :
Or go via MS-Access/Perl and ODBC/DBI perhaps?
Yes, I think it would work. The problem is that the DB is too big for
this king of export. Using DTS from MSSQL to export directly to
PostgreSQL using psqlODBC Unicode
Hi List !
I am looking for an easy URL decoding function.
I thought about using regexp_replace, but I cna't get it to
work :
SELECT regexp_replace('foo%B5bar', '%(..)', '\x\\1' , 'g');
> 'fooxB5bar'
I wanted to replace %BE with the character \xB5 (µ, I
think), but of course I am doing this w
Alvaro Herrera a écrit :
Arnaud Lesauvage wrote:
Tomi NA a écrit :
>>I think I'll go this way... No other choice, actually !
>>The MSSQL database is in SQL_Latin1_General_CP1_Cl_AS.
>>I don't really understand what this is. It supports the euro
>>symbol, so it
Tomi NA a écrit :
2006/11/21, Arnaud Lesauvage <[EMAIL PROTECTED]>:
Hi list !
I already posted this as "COPY FROM encoding error", but I have
been doing some more tests since then.
I'm trying to export data from MS SQL Server to PostgreSQL.
The tables are quite big
Magnus Hagander a écrit :
> I have done this in Delphi using it's built in UTF8 encoding and
> decoding routines. You can get a free copy of Delphi
Turbo Explorer
> which includes components for MS SQL server and ODBC, so it
would be
> pretty straight forward to get this working.
>
> The a
Alvaro Herrera a écrit :
Arnaud Lesauvage wrote:
Alvaro Herrera a écrit :
>Arnaud Lesauvage wrote:
>>Tomi NA a écrit :
>>>>I think I'll go this way... No other choice, actually !
>>>>The MSSQL database is in SQL_Latin1_General_CP1_Cl_AS.
>>>>I
Alvaro Herrera a écrit :
Arnaud Lesauvage wrote:
Alvaro Herrera a écrit :
>Arnaud Lesauvage wrote:
>
>>mydb=# SET client_encoding TO LATIN9;
>>SET
>>mydb=# COPY statistiques.detailrecherche (log_gid,
>>champrecherche, valeurrecherche) FROM
>>'E:\\P
Brandon Aiken a écrit :
It also might be a big/little endian problem, although I always thought that
was platform specific, not locale specific.
Try the UCS-2-INTERNAL and UCS-4-INTERNAL codepages in iconv, which should use
the two-byte or four-byte versions of UCS encoding using the system's
Tino Wildenhain a écrit :
Arnaud Lesauvage schrieb:
Hi List !
I am looking for an easy URL decoding function.
I thought about using regexp_replace, but I cna't get it to work :
SELECT regexp_replace('foo%B5bar', '%(..)', '\x\\1' , 'g');
&g
Hi list !
When trying to import a 20M rows csv file into PostgreSQL, I
get :
ERROR: out of memory
État SQL :53200
Détail :Failed on request of size 1073741823.
Contexte : COPY tmp, line 1
The table has no index, no trigger, ... :
CREATE TABLE tmp
(
c1 bigint,
c2 character varying,
c3 c
Martijn van Oosterhout a écrit :
On Thu, Nov 23, 2006 at 11:27:06AM -0500, Tom Lane wrote:
Arnaud Lesauvage <[EMAIL PROTECTED]> writes:
> When trying to import a 20M rows csv file into PostgreSQL, I
> get :
> ERROR: out of memory
> État SQL :53200
> Détail :Fail
Arnaud Lesauvage a écrit :
Brandon Aiken a écrit :
It also might be a big/little endian problem, although I always thought that
was platform specific, not locale specific.
Try the UCS-2-INTERNAL and UCS-4-INTERNAL codepages in iconv, which should use
the two-byte or four-byte versions of UCS
Tomi NA a écrit :
2006/11/23, Arnaud Lesauvage <[EMAIL PROTECTED]>:
Arnaud Lesauvage a écrit :
> Brandon Aiken a écrit :
>> It also might be a big/little endian problem, although I always thought that
was platform specific, not locale specific.
>>
>> Try the UCS-2-
Alvaro Herrera a écrit :
Arnaud Lesauvage wrote:
Martijn van Oosterhout a écrit :
>On Thu, Nov 23, 2006 at 11:27:06AM -0500, Tom Lane wrote:
>>Arnaud Lesauvage <[EMAIL PROTECTED]> writes:
>>> When trying to import a 20M rows csv file into PostgreSQL, I
>>> g
Hi List !
I have some data that comes from a HTTP server.
Some characters are encoded with the HTML convention :
&#;
I'd like to replace these sequences with the 'real'
character, my database being encoded in UTF8.
I already found that to convert the decimal value to the
corresponding chara
HI List,
Trying to import data from a text file, with a semicolon as
the delimiter, double-quotes as the quoting character.
I would like empty strings to be inserted as NULL values in
a varchar column. In the text file, they are writen as :
;"";
I tried
COPY table (columns) FROM textfile
D
Richard Huxton a écrit :
Arnaud Lesauvage wrote:
HI List,
Trying to import data from a text file, with a semicolon as the
delimiter, double-quotes as the quoting character.
I would like empty strings to be inserted as NULL values in a varchar
column. In the text file, they are writen as
Stephen Woodbridge a écrit :
Or maybe there is another general solution that I am no aware of.
If you just want to remove accents from your string, you can
use :
to_ascii(convert(, 'LATIN9'), 'LATIN9')
It works very well AFAIAC.
(tip given on this list)
--
Arnaud
--
Andrew Edson a écrit :
Does anyone know of anything in Postgres that might be causing this unusual
behavior? Or should I check the perl mailing lists instead?
Maybe you are beginning a transaction and that you are committing afterwards ?
--
Arnaud
---(end of broadc
Hi list !
I would like to test clustering on a multicolumn GIST index.
The first column is a PostGIS-geometry field, the second column is a smallint
field.
When I try to create the index, I have an error about GIST not being available
for smallint datatype.
How can I create this operator class
Oleg Bartunov a écrit :
Try install contrib/btree_gist
Thanks a lot !
Regards
--
Arnaud
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hi list !
I have a quite large table with a PostGIS-geometry field (~25M rows)
representing road segments.
The segments are classified in 9 classes (from 0 to 8), based on their
importance.
I am trying some different methods for optimizing queries on this table.
I decided to try with a multicol
Martin Marques a écrit :
I have a doubt about the function to_ascii() and what the documentation
says.
Basically, I passed my DB from latin1 to UTF-8, and I started getting an
error when using the to_ascii() function on a field of one of my DB [1]:
ERROR: la conversión de codificación de UT
Hi all !
I am trying to install PostGreSQL 8.1.1 on my WinXP Pro.
I am using the latest installer from
http://www.postgresql.org/ftp/binary/v8.1.1/win32/.
Here is my problem :
If I setup PostGreSQL to use the default data directory and my
language locale (French, Belgium) and UTF-8 encoding, eve
Arnaud Lesauvage wrote:
>> Hi all !
>>
>> I am trying to install PostGreSQL 8.1.1 on my WinXP Pro.
>> I am using the latest installer from
>> http://www.postgresql.org/ftp/binary/v8.1.1/win32/.
>>
>> Here is my problem :
>> If I setup Pos
Hi all !
I am trying to install PostGreSQL 8.1.1 on my WinXP Pro.
I am using the latest installer from
http://www.postgresql.org/ftp/binary/v8.1.1/win32/.
Here is my problem :
If I setup PostGreSQL to use the default data directory and my
language locale (French, Belgium) and UTF-8 encoding,
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
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
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
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
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
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
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)-
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
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
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
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
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 o
Philippe Lang a écrit :
Hardware is much more powerful: intel server motherboard, dual-xeon
3GHz, SCSI disks (raid 1), 4GB RAM.
Do you need the hyperthreading ?
Depending on your case, you might have better results with 2x3GHz
thant 4x1.5GHz.
--
Arnaud
---(end of br
Michael Meskes a écrit :
Josh, don't you think the better starting point when looking for support
would be http://www.postgresql.org/support/professional_support ? :-)
There are support companies in France and other parts of Europe which
might be a better idea for a company in France. After all
Scott Ribe a écrit :
I prefer the approach of keeping the backup server up to date, whether using
PITR or Slony or your own home-grown synching, and then changing IPs. My
process involves someone making the decision that server is indeed down,
then UNPLUGGING it from the network, then changing th
Hi list !
I am currently deploying two servers (Windows 2003 R2) that will
be used as file servers as well as PostgreSQL servers.
One of the server will be the main server, the other one a backup
server (no load-balancing, only an easy-recoverage solution).
The goal is to be able to start wor
Csaba Nagy wrote:
for a cold/warm standby postgresql backup, I'd suggest using pitr.
I found that PITR using WAL shipping is not protecting against all
failure scenarios... it sure will help if the primary machine's hardware
fails, but in one case it was useless for us: the primary had a linux
Merlin Moncure wrote:
I am currently deploying two servers (Windows 2003 R2) that will
be used as file servers as well as PostgreSQL servers.
One of the server will be the main server, the other one a backup
server (no load-balancing, only an easy-recoverage solution).
The goal is to be able to
Hi list !
I received a bunch of shapefiles with a .prj file.
I can't find the projection in the spatial_ref_sys table (it looks
quite strange, it says "IGNBelg_Lam72").
How can I insert a record for this projection in the
spatial_ref_sys table ?
Here is the .prj file content :
PROJCS["IGNBelg
Michael Fuhr a écrit :
Arnaud has probably already realized that postgis-users would be a
better place to ask this. Here's the same thread on that list:
http://postgis.refractions.net/pipermail/postgis-users/2006-July/012790.html
Yes sorry for that, I receive everything in the same folder an
83 matches
Mail list logo
