Hi,
Please advise.
We have a product with a PostgreSQLdatabase (UTF-8, PG 8.0 and 8.3)
It has a (legacy) client app that uses client_encoding = win1521 on the
connection since it uses win1252 internally.
The legacy app will be around for several years.
It cannot change to unicode.
There is a
Hi all,
We have a product with a PostgreSQLdatabase (unicode)
It has a (legacy) client app that uses client_encoding = win1521
The legacy app will be around for several years.
It cannot change to unicode.
There also is a new client app, written in java.
It uses client_encoding = unicode.
The
On 01/11/2011 02:32 AM, J. Hondius wrote:
What are my options to stop the legacy app from failing?
IMO there aren't any good ones except fix the legacy app not to be
brain-dead about character encodings.
-Is there a setting to tell PostgreSQL to fail the character gracefully
by substuting
On 01/11/2011 02:03 PM, Karayappalli, Raghunath (Raghu) wrote:
1.We observe that database is growing very fast – many sets of files
with size more than 1 GB. Please see some sample snippets of the file
lists:
What version of Pg are you using?
Got lots of connections in 'IDLE IN TRANSACTION'
On 01/11/2011 03:02 PM, nicolas.garfink...@genesis-manlab.com.ar wrote:
well, what i mean is that hashname() function would return a different value
depending the pgsql version.
Yep. It seems to be an undocumented function with no particular defined
behaviour. This isn't especially
Indeed Craig, I would like to smack the guy as well, for this and many many
other creepy crawlers in my everyday job!
Violence aside, thanks for your answer. The C module is what I was planning to
do, but was not sure if there is another way. Of course using crypt would be
the right thing to
Yunior,
En Argentina el tramite de visado es personal y se realiza en la
Embajada de Cuba, incluso tiene un costo fijo. Se realiza
personalmente y no se aceptan gestores por el tramite. La visa es un
sello en el pasaporte, previo al viaje.
Como piensan resolver este aspecto? El visado
Hi,
I suggest you to recreate database in WIN1521 encoding, so Java will
not write unsupported characters. As well you can configure JDBC in way
it will allow You to change client encoding, so you can change it to
WIN. In both of above You will get error when you will try to write
Nicolas Garfinkiel wrote:
I'm trying to upgrade our pgsql from 8.1 to 8.4, but our system's
login uses the hashname() function in order to get the proper password
validation. Now pgsql's 8.4 hashname function is not compatible with
8.1's function. Do you have any ideas how I can reproduce
I am using the version 8.2.
I have enabled auto vacuum (assuming that you are referring to the
autovacuum = on configuration).
thanks/ regards,
raghu
-Original Message-
From: Craig Ringer [mailto:cr...@postnewspapers.com.au]
Sent: Tuesday, January 11, 2011 2:08 AM
To: Karayappalli,
On 10 Jan 2011, at 16:32, J. Hondius wrote:
Hi all,
We have a product with a PostgreSQLdatabase (unicode)
It has a (legacy) client app that uses client_encoding = win1521
The legacy app will be around for several years.
It cannot change to unicode.
There also is a new client app,
I am missing some of your questions: what are the tuning parameters are
you referring here that would prevent running auto vacuum?
thanks/ regards,
raghu
-Original Message-
From: Karayappalli, Raghunath (Raghu)
Sent: Tuesday, January 11, 2011 9:38 AM
To: 'Craig Ringer'
Cc:
Thanks a lot Greg!
On 11/01/2011, at 12:41, Greg Smith g...@2ndquadrant.com wrote:
Nicolas Garfinkiel wrote:
I’m trying to upgrade our pgsql from 8.1 to 8.4, but our system’s login uses
the hashname() function in order to get the proper password validation. Now
pgsql’s 8.4 hashname
On Tue, Jan 11, 2011 at 3:23 AM, J. Hondius jhond...@rem.nl wrote:
-Should i filter out all non win1252 charachters at the new java app and
substitute them? (not so nice, i'd like to have the chars in the db)
If one of your client's cannot handle the data stored in the DB, then
you should not
Dne 11.1.2011 19:11, Karayappalli, Raghunath (Raghu) napsal(a):
I am missing some of your questions: what are the tuning parameters are
you referring here that would prevent running auto vacuum?
There is a bunch of parameters influencing autovacuum - how often it
runs, how much work it does,
Hello,
My organization is in the process of getting a FIPS certification. I was
wondering if anyone who has experience with getting their application FIPS
certified using postgres. I have read a little bit about this and saw that
you need to compile postgres manually using a FIPS capable
Something to think about heredoes your database actually require
encryption? Or is the encryption handled between remote user and
application?
If your database is shared locally on the same server as your
application, then you shouldn't need FIPS encryption since the
communication between
I notice on the documentation page about Asynchronous Commit (
http://www.postgresql.org/docs/8.3/static/wal-async-commit.html*)*, it says
the follow The user can select the commit mode of each transaction, so that
it is possible to have both synchronous and asynchronous commit transactions
18 matches
Mail list logo