-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Le 08/07/2015 22:25, CS DBA a écrit :
>
>
> On 07/08/2015 02:20 PM, John R Pierce wrote:
>> On 7/8/2015 1:16 PM, dinesh kumar wrote:
>>> We recently done the similar migration for one of our customer.
>>> We used all opensource tools to achieve this
Hi,
Thanks very much Daniel ! :))
You hit the problem.
lc_messages were configured with 'French_France.1252' (as usual)
Setting it to 'C' resolve the issue.
Another way is to set client_min_messages to 'error'
So, it seems that a 32 bits PG 9.4.4 return to client the UTF8 error
generated b
Adrian Klaver-4 wrote
> That is sort of dangerous:) As an example, do you really want --inserts
> or --column-inserts, they really slow down a restore.
I know, but this time I need it more for versioning/demo version
prepariation so performence isn't important at all, what I care about is
only dd
Tom Lane-2 wrote
> $ time pg_dump -f /z/q regression
> pg_dump: [archiver] could not open output file "/z/q": No such file or
> directory
>
> real0m1.164s
> user0m0.062s
> sys 0m0.034s
>
> However, I don't see that with any of the non-plain-text output formats:
In my case this is:
p
Thanks! I'll check into this.
On 7/9/15 1:34 AM, Tom Lane wrote:
"Chas. Munat" writes:
I recently upgraded to Ubuntu 15.04 with PostgreSQL 9.4.4 with uuids and
plv8 coffeescript extensions. I can access the database via psql. My web
application uses node.js via pg-bricks. It works perfectly on
On 07/09/2015 01:24 AM, pinker wrote:
Tom Lane-2 wrote
$ time pg_dump -f /z/q regression
pg_dump: [archiver] could not open output file "/z/q": No such file or
directory
real0m1.164s
user0m0.062s
sys 0m0.034s
However, I don't see that with any of the non-plain-text output formats:
On 7/3/15 8:08 AM, howardn...@selestial.com wrote:
> Thanks everyone.
>
> I am trying to move away from pg_dump as it is proving too slow. The
> size of the database clusters are approaching 1TB (with multiple
> individual compressed pg_dumps of around 100GB each, but the pace of
> change is relati
Hi,
in oracle regexp_like(entered
date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i')
for postgres i have regexp_matches ,But i need how to match [:digit:] in
postgres when we pass date..?
any help
Rames,
Hope this will be useful
http://www.postgresql.org/docs/9.1/static/functions-string.html
Jimit Amin
On Thu, Jul 9, 2015 at 9:54 PM, Ramesh T
wrote:
> Hi,
> in oracle regexp_like(entered
> date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i')
>
> for postgres i have regex
Hi All.
I have a website db that is 90% read-only. I have 50 (or so) tiny
lookup tables, something like:
\d m_zone
Column | Type | Modifiers
-+-+---
code| integer | not null
zone_id | text|
descr | text|
This one has less than 10 rows, others mig
On 7/9/2015 11:24 AM, Ramesh T wrote:
Hi,
in oracle regexp_like(entered
date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i')
for postgres i have regexp_matches ,But i need how to match [:digit:] in
postgres when we pass date..?
any help
\d
per:
http://www.postgresql.org/docs/de
> Hi,
> in oracle regexp_like(entered
> date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i')
>
> for postgres i have regexp_matches ,But i need how to match [:digit:] in
> postgres when we pass date..?
> any help
[:digit:] is Posix syntax, supported by Postgres.
Looks good to me:
On 07/09/2015 09:24 AM, Ramesh T wrote:
Hi,
in oracle regexp_like(entered
date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i')
for postgres i have regexp_matches ,But i need how to match [:digit:]
in postgres when we pass date..?
any help
Konsole output
The tilde operator wor
Andy Colson writes:
> My question is: Will PG cache only the index (assuming it can always do
> an Index Only Scan), or will it cache the table as well?
The table blocks would fall out of cache if they're never touched.
regards, tom lane
--
Sent via pgsql-general mai
Guys
Is there a way to get total count of queries hitting Postgresql
DB(verison 9.3) per day or per hour ? I cannot turn on log_statement=all coz
that's too much logging for our log file to handle. Is there another way to do
that.
Thanks
Prabhjot
On 7/9/2015 12:41 PM, Tom Lane wrote:
Andy Colson writes:
My question is: Will PG cache only the index (assuming it can always do
an Index Only Scan), or will it cache the table as well?
The table blocks would fall out of cache if they're never touched.
regards, tom
On 7/9/2015 1:04 PM, Sheena, Prabhjot wrote:
Guys
Is there a way to get total count of queries hitting
Postgresql DB(verison 9.3) per day or per hour ? I cannot turn on
log_statement=all coz that’s too much logging for our log file to
handle. Is there another way to do that.
Than
On Wed, Jul 8, 2015 at 10:17 PM, Francisco Reyes wrote:
> Anyone knows of a way to test the SSL connection such that it validates
> against the CA? Preferably an open source application. Connecting through
> psql works fine on SSL with what I have setup, but the application, xtuple,
> seems to st
On Thu, Jul 9, 2015 at 12:04 PM, Sheena, Prabhjot
wrote:
> Guys
>
> Is there a way to get total count of queries hitting
> Postgresql DB(verison 9.3) per day or per hour ? I cannot turn on
> log_statement=all coz that’s too much logging for our log file to handle. Is
> there another
I did try that but that’s too much logging as well.
Prabhjot Singh
Database Administrator
CLASSMATES
1501 4th Ave., Suite 400
Seattle, WA 98101
206.301.4937 o
206.301.5701 f
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Thursday, July 9, 2015 1:07 PM
To:
Run two cron jobs, each runs exacty 24 hours apart.
Each gets the result of the following query:
SELECT SUM(xact_commit + xact_rollback)
FROM pg_stat_database;
Then subtract the result of the first cron from the second.
That's the number of transactions in a 24 hr period.
On Thu, Jul 9, 2015
Thanks a lot. That’s what I am looking for
Thanks
Prabhjot Singh
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Thursday, July 9, 2015 1:24 PM
To: Scott Marlowe
Cc: Sheena, Prabhjot; pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to get total count of queries hitting DB per da
On 07/09/2015 01:26 PM, Sheena, Prabhjot wrote:
Thanks a lot. That’s what I am looking for
Might also want to look at:
http://www.postgresql.org/docs/9.4/static/pgstatstatements.html
Thanks
*/Prabhjot Singh/*
*From:*Melvin Davidson [mailto:melvin6...@gmail.com]
*Sent:* Thursday, July 9, 2
On 07/08/2015 10:52 PM, Tom Lane wrote:
What's the complaint exactly?
The error we are getting is:
The security of this transaction may be compromised. The following SSL
errors have been reported:
* The issuer certificate of a locally looked up certificate could not be
found.
* The root C
On 07/09/2015 03:07 PM, Vick Khera wrote:
On Wed, Jul 8, 2015 at 10:17 PM, Francisco Reyes mailto:li...@natserv.net>> wrote:
openssl s_client -connect HOST:PORT -CAfile /path/to/CA.pem
According to this post:
http://serverfault.com/questions/79876/connecting-to-postgresql-with-ssl-using-open
25 matches
Mail list logo
