I updated odbc drivers and it worked.
Thanks everyone
Regards,
Juliano
Sent with [ProtonMail](https://protonmail.com) Secure Email.
Original Message
Subject: Re: [GENERAL] Import data from MS SQL Server 2014 to Postgresql 9.6
using dbi-link and fdw (error: utf-8/uft-16)
Loc
Hi everyone,
How can I use pg_dump to do a backup of "system catalogs" only?
Regards,
Juliano
On 25/11/2016 13:11, Juliano wrote:
Hi everyone,
How can I *use pg_dump* to do a backup of *"system catalogs"* only?
pg_dump --schema=pg_catalog
Regards,
Juliano
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
Hi,
I'm doing simple tests with lsof on data catalog with bash script:
#!/bin/bash
for i in {0..2000}
do
psql -U postgres -c '*BEGIN; select pg_sleep(30); COMMIT*'&
done
and i measure number of open files and what files are affected by specific
command.
Lsof has shown me that the only fil
Hello,
we need to replicate hundreds of thousands of rows (for reporting) between
Postgresql Database nodes that are in different locations.
Actually, we use Rubyrep with Postgresql 8.4.22.
It works fine but it is very slow with a massive numbers of rows.
With Postgresql 9.x, are there some way
On 25 November 2016 at 06:23, Job wrote:
> Hello,
>
> we need to replicate hundreds of thousands of rows (for reporting) between
> Postgresql Database nodes that are in different locations.
>
> Actually, we use Rubyrep with Postgresql 8.4.22.
8.4 is now end-of-life. You should move to the latest
On 11/25/2016 04:40 AM, pinker wrote:
Hi,
I'm doing simple tests with lsof on data catalog with bash script:
#!/bin/bash
for i in {0..2000}
do
psql -U postgres -c '*BEGIN; select pg_sleep(30); COMMIT*'&
done
and i measure number of open files and what files are affected by specific
comm
On 11/24/2016 02:14 PM, azhwkd wrote:
Adrian Klaver mailto:adrian.kla...@aklaver.com>> schrieb am Do., 24. Nov. 2016 um
22:34 Uhr:
On 11/24/2016 01:23 PM, azhwkd wrote:
> It should not be possible because a group does not return to the
> update pool before the update hasn't finished
Adrian Klaver-4 wrote
> I can not replicate using 50 clients instead of 2000. I suspect either
> has to do with the extreme number of clients or it is an artifact of
> from some other process.
And I have replicated it with 50 clients as well... lsof output:
51 data/base/13328/2601
command: wat
Il 25/11/2016 15:23, Job ha scritto:
Hello,
Hello, we are using rybyrep with postgresql 9.1 and 9.5 to have
(almost-) real time synchronization for 5 years ATM.
Unfortunately, it seems a dead project, so we had to find a good JRuby
developer to make some customizations.
we need to replicate hu
On 11/25/2016 07:04 AM, pinker wrote:
Adrian Klaver-4 wrote
I can not replicate using 50 clients instead of 2000. I suspect either
has to do with the extreme number of clients or it is an artifact of
from some other process.
And I have replicated it with 50 clients as well... lsof output:
51
pinker writes:
> I'm doing simple tests with lsof on data catalog with bash script:
> #!/bin/bash
> for i in {0..2000}
> do
> psql -U postgres -c '*BEGIN; select pg_sleep(30); COMMIT*'&
> done
> and i measure number of open files and what files are affected by specific
> command.
> Lsof ha
On Wed, Nov 23, 2016 at 10:16 AM, Israel Brewster
wrote:
> I was wondering if someone could inform me about, or point me to an online
> article about best practices for backing up a postgresql database cluster?
> At the moment, I have two servers running with streaming replication for
> failover
Hello ??
I'am a Postgre fan.
Now, I have a problem, the table name is stored in lower case , but i
want to change it into upper case. Can i have a simple method? Such as modify
a parameter.
Thank you!
Hey Tom,
I appreciate you're busy, but did you ever get a chance to look at this?
On 19/09/2016 08:40, Chris Withers wrote:
On 16/09/2016 15:29, Tom Lane wrote:
Chris Withers writes:
On 16/09/2016 14:54, Igor Neyman wrote:
So, what is the value for "end ts", when the record is inserted (the
On 24/11/16 20:52, wrote:
Hello ??
I'am a Postgre fan.
Now, I have a problem, the table name is stored in lower case
, but i want to change it into upper case. Can i have a simple
method? Such as modify a parameter.
Thank you!
Why?
I can't see any practical
On Thu, Nov 24, 2016 at 5:44 PM, Yogesh Sharma <
yogesh1.sha...@nectechnologies.in> wrote:
> Dear All,
>
> Thanks in advance.
> I found below deadlock in postgresql logs.
> I cannot change calling of REINDEX and insert query sequence because it is
> execute automatically through some cron script.
On 11/23/2016 11:52 PM, wrote:
> Hello ??
>
> I'am a Postgre fan.
> Now, I have a problem, the table name is stored in lower case ,
> but i want to change it into upper case. Can i have a simple method?
> Such as modify a parameter.
https://www.postgresql.org/docs/9.5
"=?gb18030?B?zfWyqA==?=" <853372...@qq.com> writes:
> Now, I have a problem, the table name is stored in lower case , but i
> want to change it into upper case. Can i have a simple method? Such as
> modify a parameter.
No.
We have looked into making that configurable, and the conclusio
19 matches
Mail list logo
