Re: Migration from SQL Server to PostgeSQL

2020-11-29 Thread Pavel Stehule
po 30. 11. 2020 v 7:06 odesílatel Muthukumar.GK napsal: > Hi Pavel, > > Kindly let me know the following functionality can be possible in > postgresql. If possible,provide me with a sample program. > > 1. Call the procedure from/inside another procedure and insert the result > set into Temp Tabl

Re: Migration from SQL Server to PostgeSQL

2020-11-29 Thread Muthukumar.GK
Hi Pavel, Kindly let me know the following functionality can be possible in postgresql. If possible,provide me with a sample program. 1. Call the procedure from/inside another procedure and insert the result set into Temp Table. 2. Creating Dynamic procedure in postgresql. because We have dynami

Re: Migration from SQL Server to PostgeSQL

2020-11-29 Thread Pavel Stehule
po 30. 11. 2020 v 6:12 odesílatel Muthukumar.GK napsal: > HiTeam, > > We need to migrate tables,Records,Procedure and function from SQL server > to Postgresql. Kindly let me know, Is there any tool or easiest way > available to migrate from SQL Server to Postgresql. Please let me know if > there

Migration from SQL Server to PostgeSQL

2020-11-29 Thread Muthukumar.GK
HiTeam, We need to migrate tables,Records,Procedure and function from SQL server to Postgresql. Kindly let me know, Is there any tool or easiest way available to migrate from SQL Server to Postgresql. Please let me know if there are any limitations in *postgresql *compared to SQL server. Regards

Re: postgres_fdw insert extremely slow

2020-11-29 Thread Craig Ringer
On Thu, Nov 26, 2020 at 12:37 AM Mats Julian Olsen wrote: > > We have just set up postgres_fdw between two postgres databases, x and y, > with the plan to periodically insert data from x into y. > > We've successfully set up the connection with a few options: > `use_remote_estimate 'true'` and `f

Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

2020-11-29 Thread Martin Goodson
On 29/11/2020 18:46, David G. Johnston wrote: On Sun, Nov 29, 2020 at 11:06 AM Martin Goodson wrote: Hello. I wonder if anyone can assist with this? Some of my developers are reporting that they are getting the following message when attempting to connect to the database using jdbc: Caused

Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

2020-11-29 Thread David G. Johnston
On Sun, Nov 29, 2020 at 11:06 AM Martin Goodson wrote: > Hello. > > I wonder if anyone can assist with this? > > Some of my developers are reporting that they are getting the following > message when attempting to connect to the database using jdbc: > > Caused by: org.postgresql.util.PSQLExceptio

Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

2020-11-29 Thread Martin Goodson
On 29/11/2020 18:28, Adrian Klaver wrote: On 11/29/20 10:22 AM, Martin Goodson wrote: On 29/11/2020 18:10, Adrian Klaver wrote: On 11/29/20 10:06 AM, Martin Goodson wrote: Hello. I wonder if anyone can assist with this? Some of my developers are reporting that they are getting the following

Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

2020-11-29 Thread Adrian Klaver
On 11/29/20 10:22 AM, Martin Goodson wrote: On 29/11/2020 18:10, Adrian Klaver wrote: On 11/29/20 10:06 AM, Martin Goodson wrote: Hello. I wonder if anyone can assist with this? Some of my developers are reporting that they are getting the following message when attempting to connect to the

Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

2020-11-29 Thread Martin Goodson
On 29/11/2020 18:10, Adrian Klaver wrote: On 11/29/20 10:06 AM, Martin Goodson wrote: Hello. I wonder if anyone can assist with this? Some of my developers are reporting that they are getting the following message when attempting to connect to the database using jdbc: Caused by: org.postgre

Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

2020-11-29 Thread Adrian Klaver
On 11/29/20 10:06 AM, Martin Goodson wrote: Hello. I wonder if anyone can assist with this? Some of my developers are reporting that they are getting the following message when attempting to connect to the database using jdbc: Caused by: org.postgresql.util.PSQLException: Server versions pri

"Server versions prior to 8.0 do not support savepoints" when using JDBC ...

2020-11-29 Thread Martin Goodson
Hello. I wonder if anyone can assist with this? Some of my developers are reporting that they are getting the following message when attempting to connect to the database using jdbc: Caused by: org.postgresql.util.PSQLException: Server versions prior to 8.0 do not support savepoints at or

Re: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4

2020-11-29 Thread Adrian Klaver
On 11/28/20 9:32 PM, mark armon wrote: where to get pg_dump 13.0? Are both Postgres instances(12.4 and 13.0) on the same machine? If they are and you used the EDB installer the binaries(pg_dump for instance) will be under: C:\Program File\PostgreSQL\\bin If they are not then you will eith

Re: How to debug authentication issues in Postgres

2020-11-29 Thread Daniele Varrazzo
IIRC you need libpq at least 10 to use password encryption other than md5. Maybe your java client uses an older version, or no libpq at all and the client library misses that feature? -- Daniele On Sat, 28 Nov 2020, 16:12 Hemil Ruparel, wrote: > I am unable to connect using Java in general. An