Re: Query: Migrating from SQLServer to Postgresql
Hi On Mon, Aug 13, 2018 at 1:37 PM Darnie Graceline wrote: > Hi, > Iam looking into a process of migrating from SQLServer to Postgresql, and > I see that DBMigration is one of the tools you have offered, however when > analysed DBMigration does not support migrating all components under free > version. > > 1.Could you help suggest a free tool that we can use to migrate all the > components from SQLServer DB to Postgresql. > > Not having experience on actual migration but below links may help you: https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL https://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding https://github.com/dalibo/sqlserver2pgsql https://sourceforge.net/projects/mssql2pgsql/ https://www.devbridge.com/articles/migrating-from-mssql-to-postgresql/# http://www.sqlines.com/sql-server-to-postgresql-tool https://dbconvert.com/mssql/postgresql/ Search for migration tool at : https://www.postgresql.org/download/products/1/ 2. Also could you suggest the best suitable driver while communicating from > .Net to Postgresql. > > For .Net connection PostgreSQL used npgsql drivers. https://github.com/npgsql/npg Thanks & Regards, > Darnie. > > > > -- Thanks and Regards, Sachin Kotwal
Re: Query: Migrating from SQLServer to Postgresql
Complete URL for npgsql is : https://github.com/npgsql/npgsql On Mon, Aug 13, 2018 at 2:43 PM Sachin Kotwal wrote: > Hi > > On Mon, Aug 13, 2018 at 1:37 PM Darnie Graceline > wrote: > >> Hi, >> Iam looking into a process of migrating from SQLServer to Postgresql, and >> I see that DBMigration is one of the tools you have offered, however when >> analysed DBMigration does not support migrating all components under free >> version. >> >> 1.Could you help suggest a free tool that we can use to migrate all the >> components from SQLServer DB to Postgresql. >> >> Not having experience on actual migration but below links may help you: > > > https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL > > https://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding > > https://github.com/dalibo/sqlserver2pgsql > https://sourceforge.net/projects/mssql2pgsql/ > https://www.devbridge.com/articles/migrating-from-mssql-to-postgresql/# > > http://www.sqlines.com/sql-server-to-postgresql-tool > https://dbconvert.com/mssql/postgresql/ > > Search for migration tool at : > https://www.postgresql.org/download/products/1/ > > 2. Also could you suggest the best suitable driver while communicating >> from .Net to Postgresql. >> >> For .Net connection PostgreSQL used npgsql drivers. > https://github.com/npgsql/npg > > Thanks & Regards, >> Darnie. >> >> >> >> > > -- > > Thanks and Regards, > Sachin Kotwal > -- Thanks and Regards, Sachin Kotwal
Impact on PostgreSQL due to Redhat acquisition by IBM
Hi PostgreSQL lovers, I heard news that Redhat is going to acquired by IBM. IBM has its on database. And they have history of selling applications with their own hardware (software and hardware together). As per my knowledge PostgreSQL community has better support for Redhat family than any other platforms. Does community is going to support/focus more Debian platforms ? Does community has any plan to switch their main supported platform? Please share if any other plan. -- Thanks and Regards, Sachin Kotwal
Re: Impact on PostgreSQL due to Redhat acquisition by IBM
On Wed, Nov 14, 2018 at 7:08 PM Adrian Klaver wrote: > On 11/13/18 11:04 PM, Sachin Kotwal wrote: > > Hi PostgreSQL lovers, > > > > I heard news that Redhat is going to acquired by IBM. IBM has its on > > database. And they have history of selling applications with their own > > hardware (software and hardware together). > > > > As per my knowledge PostgreSQL community has better support for Redhat > > family than any other platforms. > > Not seeing it: > > https://www.postgresql.org/download/ > > > > > Does community is going to support/focus more Debian platforms ? > > Does community has any plan to switch their main supported platform? > > There is no main supported platform. There is the source and there are > packaging built off the source. The packaging is done by a diverse group > of people. So for example the RPMS: > > https://yum.postgresql.org/contact.php > > Devrim Gündüz EDB > > Jeff Frost PGX > > Craig Ringer2ndQuadrant > > > > Please share if any other plan. > > > > > > -- > > > > Thanks and Regards, > > Sachin Kotwal > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > Looks like no one have clear idea yet and deal also not completely done. Hope Redhat community support will continue same as earlier. Let's wait until something will announce by community is coming days. Thanks all for your inputs. Regards, Sachin -- Thanks and Regards, Sachin Kotwal
Re: Impact on PostgreSQL due to Redhat acquisition by IBM
On Thu 15 Nov, 2018, 7:59 PM Adrian Klaver On 11/14/18 10:39 PM, Sachin Kotwal wrote: > > > > > > > Looks like no one have clear idea yet and deal also not completely done. > > Barring some regulatory intervention(which I do not see) the deal will > be completed. > > > Hope Redhat community support will continue same as earlier. > > > > Let's wait until something will announce by community is coming days. > > Not sure what announcement you are expecting? From what I see nothing > has changed so there is no need for any. > does. > I know community does not provide postgresql binaries for windows, EnterpriseDB and OpenSCG I feel community has most of linux based instance in thier buildfarm for testing, might be very few Ubuntu based. I might be wrong here. Anyways , we can conclude discussion with "No need to worry about Redhat acquisition as PostgreSQL having really strong position in market" Thanks, Sachin > > > > Thanks all for your inputs. > > > > Regards, > > Sachin > > > > -- > > > > Thanks and Regards, > > Sachin Kotwal > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
Re: Impact on PostgreSQL due to Redhat acquisition by IBM
On Fri 16 Nov, 2018, 1:06 AM Alvaro Herrera On 2018-Nov-15, Sachin Kotwal wrote: > > > I feel community has most of linux based instance in thier buildfarm for > > testing, might be very few Ubuntu based. > > If you feel the need to run more buildfarm members on Ubuntu, run some > yourself. It's self-service. > Missed to do reply all so doing here. I would love to do it. Only help me if i found any issue while doing it and I know community always do that , that is why i love PostgreSQL and it's community. We already have 120+ production instances running on Ubuntu. I will start testing new releases from source on Ubuntu as well. Thanks, Sachin > -- > Álvaro Herrerahttps://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services >
Re: Impact on PostgreSQL due to Redhat acquisition by IBM
On Fri 16 Nov, 2018, 3:36 AM Thomas Munro On Fri, Nov 16, 2018 at 5:07 AM Adrian Klaver > wrote: > > On 11/15/18 7:59 AM, Sachin Kotwal wrote: > > > I feel community has most of linux based instance in thier buildfarm > for > > > testing, might be very few Ubuntu based. > > > I might be wrong here. > > > > Easy enough to see: > > > > https://buildfarm.postgresql.org/cgi-bin/show_members.pl > > Out of curiosity, here are the current counts for HEAD: > > Linux distros: > Amazon Linux: 1 > Arch Linux: 1 > CentOS: 9 > Debian: 34 > Fedora: 5 > Photon: 1 > Raspbian: 2 > RHEL: 8 > SUSE: 7 > Ubuntu: 7 > > BSD diaspora: > DragonflyBSD: 1 > FreeBSD: 6 > NetBSD: 2 > OpenBSD: 1 > > OpenSolaris diapora: > OmniOS: 1 > SmartOS: 1 > > Other Unixen: > AIX: 4 > HP-UX: 3 > macOS: 4 > > Windows: > Windows: 6 > Cygwin: 1 > > I wouldn't be too worried about any of these, especially the open > ones. Closed Solaris, though, is apparently dead to us. Nobody cares > enough to build HEAD on it anymore, and for example 3a769d82 (reflink > support for pg_upgrade) went in without consideration of Solaris 11.4 > reflink(). I've personally moved to the 'acceptance' phase of grief; > all three Unixes that I cut my teeth on in the 90s are now either > formally dead and buried or in this case, a zombie. > > From personal observations, I know that we have developers and > committers doing their primary development work on at least Debian, > Fedora, FreeBSD, macOS, Ubuntu and Windows. > Thanks for detail head count and explanation. It cleared me and i believe should have clear to all new community member that topic/subject doesn't make any effect on PostgreSQL future. Regards, Sachin > -- > Thomas Munro > http://www.enterprisedb.com >
Re: Error: server closed the connection unexpectedly
see. > > Perhaps an ill-configured network component closes idle connection? > In that case, try keepalive. > > Yours, > Laurenz Albe > -- > Cybertec | https://www.cybertec-postgresql.com > > > > -- Thanks and Regards, Sachin Kotwal
Update blocking another update
Hi All, As update operation is "ROW Exclusive" It should not block another update operation. In below case we are updating all values for in one column. It is blocking another update operations. It this expected behavior ? Please clarify . 1. Setup database by initializing with pgbench with some scale. pgbench -p 5432 -d postgres -s 500 -i -n 2. pgbench -p 5432 -d postgres -T 1200 -n -c 10 3. update pgbench_accounts set name ='dummy'; 4. Cancel running pgbench with Ctrl + C. 5. After canceling pgbench process , we are still able to see running transaction by pgbench as below : select datname, pid, usename, application_name, query_start, state, query from pg_stat_activity where state='active' and query not ilike 'END;'; datname | pid | usename | application_name | query_start| state | query --+--+--+--+--++-- postgres | 6409 | postgres | psql | 2018-01-11 06:11:37.180834+05:30 | active | select datname, pid, usename, application_name, query_start, stat e, query from pg_stat_activity where state='active' and query not ilike 'END;'; postgres | 6426 | postgres | psql | 2018-01-11 05:58:22.246781+05:30 | active | update pgbench_accounts set name ='dummy'; postgres | 6434 | postgres | pgbench | 2018-01-11 06:00:22.665211+05:30 | active | UPDATE pgbench_accounts SET abalance = abalance + 1802 WHERE aid = 390426; postgres | 6435 | postgres | pgbench | 2018-01-11 06:00:54.866775+05:30 | active | UPDATE pgbench_accounts SET abalance = abalance + 3517 WHERE aid = 865230; postgres | 6436 | postgres | pgbench | 2018-01-11 06:00:32.504115+05:30 | active | UPDATE pgbench_accounts SET abalance = abalance + -2488 WHERE aid = 469975; postgres | 6437 | postgres | pgbench | 2018-01-11 05:59:54.809692+05:30 | active | UPDATE pgbench_accounts SET abalance = abalance + -3039 WHERE aid = 385296; postgres | 6438 | postgres | pgbench | 2018-01-11 06:00:16.971491+05:30 | active | UPDATE pgbench_accounts SET abalance = abalance + 1489 WHERE aid = 87498; postgres | 6439 | postgres | pgbench | 2018-01-11 05:59:22.330281+05:30 | active | UPDATE pgbench_accounts SET abalance = abalance + 507 WHERE aid = 69858; postgres | 6440 | postgres | pgbench | 2018-01-11 05:59:53.27686+05:30 | active | UPDATE pgbench_accounts SET abalance = abalance + 4955 WHERE aid = 378685; postgres | 6441 | postgres | pgbench | 2018-01-11 06:00:41.727319+05:30 | active | UPDATE pgbench_accounts SET abalance = abalance + -3107 WHERE aid = 722157; postgres | 6442 | postgres | pgbench | 2018-01-11 06:00:48.311869+05:30 | active | UPDATE pgbench_accounts SET abalance = abalance + 2679 WHERE aid = 304148; postgres | 6443 | postgres | pgbench | 2018-01-11 06:00:04.269291+05:30 | active | UPDATE pgbench_accounts SET abalance = abalance + -2954 WHERE aid = 400782; (12 rows) Ideally it should cancel queries thrown by pgbench once pgbench process is canceled. Is this problem with pgbench ? -- Thanks and Regards, Sachin Kotwal
