Servoy users,
Since version 5.2 will now ship with PostgreSQL, I wanted to start a forum thread soliciting any questions you might have about PostgreSQL, its community, how it’s different from Sybase, etc. Ask below!
I am new to Servoy and just starting to work with it. As I understand it, the current Servoy runtime ships with SQL Anywhere. I will be making use of the runtime, although I will be working to move my current users to a web-based solution in the longer term. I’m wondering what the availability of a Postgresql runtime might be. If it’s a long way off, I probably should be building my tables in SQL Anywhere. If it’s coming relatively soon, I’d probably use Postgres.
Will there be tools available for converting the existing SQL Anywhere databases to Postgres? I wouldn’t doubt that they exist, but I guess what I’m asking if there will be a conversion tool that the Servoy folks will favor and be able to provide assistance with?
Thanks.
Ron
I’ve got a question - when eclipse shuts down, sometimes there are several postgres processes that continue to run (seen in Activity Monitor on Mac OSX). Why is that? There are no other connections to PG. What’s the correct way to handle this?
Thanks.
Also, any pointers on importing data from Excel into PG without using the Servoy Import, which is painfully slow for large spreadsheets.
I’d also like some tips on migrating a large Sybase DB (750k recs) into PG.
RonG:
Will there be tools available for converting the existing SQL Anywhere databases to Postgres?
Ron,
You can use Servoy to export a solution from sybase and import into postgres, it will create the datamodel for you in the target database.
If the data is not very large, you can use the ‘include sample data’ option in the export and Servoy will insert that in the target as well.
Rob
antonio:
I’ve got a question - when eclipse shuts down, sometimes there are several postgres processes that continue to run (seen in Activity Monitor on Mac OSX). Why is that? There are no other connections to PG. What’s the correct way to handle this?Thanks.
Tony,
When eclipse shuts down, the shutdown launcher (Preferences->Servoy->Startup) is called.
By default (Servoy 5.2) it calls ‘pg_ctl stop’ to stop the postgres db.
One reason for postgres to not immediately stop is existing other connections. Maybe there are other.
You can edit the shutdown launcher to add an option to pg_ctl to always shutdown, no matter what.
Rob
Thanks, Rob. Appreciate the info.
Ron
Hello,
I’am playing a bit with servoy developper 5.2 beta 2 but after closing it and re-launch it postgresql isn’t launched, i don’t know why.
I have importing datas from servoy developper 5.1.x with sybase in 5.2 beta 2 with postgresql, i have issues with login part of my solution.
what is the exactly way to migrate all datas from 5.1.x to 5.2.x ?
I’ve installed Postgres now, and managed to use one of the 3rd party utilities to convert my Access database to Postgres. So far so good. I’m also acquainting myself is pgAdmin III, and have a couple of questions…
-
I’m most likely missing something really obvious here, but how do you look at table relationships with pgAdmin? I’ve checked the doc, and seem to have missed it there as well.
-
Any thoughts on the available admin tools for Postgres? Is pgAdmin the tool of choice? Is there another that most people seem to use? I’ve seen a variety of admin tools, some of which are free and some that have a fee. There are a couple of commercial admin tools that look pretty impressive, but before I drop some money on one of them vs pgAdmin, I thought I’d get some other opinions.
Thanks.
Ron
Hello,
I have still issues when importing datas generated by servoy 5.1.x with sybase into 5.2.x with postgresql, i have an issue when i try to log into my solution, the datas was right saved into postgresql databse, i know the issue come from to an issue into the solution.
Hi Flo,
Depending on your setup the way to migrate data might vary.
Have you checked out the content on the wiki related to this? http://wiki.servoy.com/display/beta/Syb … +migration
If you say you have trouble at login, I think you might be experiencing the Enhanced Security behavior introduced with Servoy 5.2. See http://wiki.servoy.com/display/beta/Upg … d+Security for more info.
Paul
Paul, I would like to know, what the best way is to migrate your DATA from Sybase 10/11 to postgreSQL…
We dont use ANY DB related stuff, like triggers, stored procedures, db-sequences, stuff like that, just plain data.
the posgreSQL wiki, does not mention anything about Sybase 10/11
Is this on the roadmap of Servoy to build somekind of migration tool, like, the import/export of sample-data inside Servoy?
the sample-data import/export works perfectly for us, on development PC’s
But we have been warned (I believe by Jan B.) NOT, to use it with production-data en larges sets of data… (we don’t know why… )
so maybe you can explain a bit more? or tell us that you guys comming up with something
pbakker:
Hi Flo,Depending on your setup the way to migrate data might vary.
Have you checked out the content on the wiki related to this? http://wiki.servoy.com/display/beta/Syb … +migration
If you say you have trouble at login, I think you might be experiencing the Enhanced Security behavior introduced with Servoy 5.2. See http://wiki.servoy.com/display/beta/Upg … d+Security for more info.
Paul
Thanks i didn’t know that enhanced security can causing this can of issues. In the doc, it’s mentionned that disabling enhanced security it’s strongly discouraged. Why ?
I know that PgExperts (see first post of this very thread) is developing a migration service where you simply send them your database file and you get a postgresql backup file back which you can use to restore a PostgreSQL database.
Josh announced it on the webinar and said it would be ready at the moment that Servoy 5.2 would go final.
As for migration tools, I have been looking at some candidates but all required quite some work to get it going.
This question regards deployment planning. We have a couple of installations using Servoy 5.1.4. with Sybase. We have to decide - do we convert them to the current version of PostgreSQL, keep them on Sybase and use PostgreSQL for new installations (maybe convert old one later), or wait for PostgreSQL 9.0. It looks like there are major changes in 9.0. Any thoughts?
Hi Michael,
There is no real (technical) reason to wait for 9.0.
Sure it has a lot of changes but upgrading will be a matter of dumping the whole database cluster using pg_dumpall (the commandline backup tool), install 9.0 and restore your backup into the 9.0 installation.
The reason I ask about waiting for 9.0 is will there be much of a learning curve as far as installation and tools (whatever the equivalent of Sybase Central, etc.)? Rather not have to learn about something we would only be using a short time if those things change alot with 9.0
Hi Michael,
The learning curve with be pretty much the same for 9.0 as for 8.4.
The most used tool is PgAdmin (http://www.pgadmin.org)
All,
Sorry for delay in answering stuff. I thought I’d set up this forum to e-mail me on posts, but apparently not. I’ll answer one at a time.
RonG:
Our company (PostgreSQL Experts) will be offering a conversion service which will be supported by Servoy Inc. I expect to announce terms on that fairly soon. Of course, you can theoretically us any multi-database conversion tool to convert from Sybase to PostgreSQL.
You aren’t missing anything; pgAdmin doesn’t have diagramming capabilities yet. DBVisualizer’s free edition does a fairly impressive job of diagramming table relationships for PostgreSQL, though, and some of the other tools (SQLPower, etc.) have some ERD capabilities.
I don’t have an opinion on the various proprietary Admin tools since I haven’t really used them. See which ones have a try-and-buy option.
Antonio:
If you’re finding that PostgreSQL does not shut down when Servoy does in the beta, please file a bug with Servoy. It should shut down if there are no open connections. If you can reproduce this, feel free to post the list of PostgreSQL processes here on the forum and I’ll see if I can troubleshoot.
There’s a variety of tools for Excel–>PostgreSQL. I personally write Perl and use DBI, which can talk to both Excel and PostgreSQL and is quite fast, but that’s programming. Alternately, I know that SQLManager makes a tool which will move data from PostgreSQL to and from a variety of microsoft formats: http://www.sqlmanager.net/ For converting your Sybase database once 5.2 is official, you can either use Servoy, a tool like SQLManager, or pay us to do it.
Michael,
9.0 will be out sometime late this summer, although I don’t know when it will be officially supported by Servoy. So if you are going to use some of 9.0’s new features (like binary replication), it might be worthwhile to wait. If you’re not going to be using 9.0’s special features, though, then there’s no reason to. Also, 9.0 will be possible to upgrade-in-place using pgupgrade, so you can do 8.4 now and upgrade to 9.0 later with fairly brief (minutes) downtime. There is no real difference between learning 8.4 and 9.0; the PostgreSQL Project keeps backwards compatibility issues to a minimum.
OK, good advice friends, thanks.