PG_Dump Problem

Questions and answers regarding general SQL and backend databases

PG_Dump Problem

Postby alk » Wed Nov 02, 2016 9:05 pm

Good evening,
I'm running Postgres 9.5, I installed the pgadmin 4 Version 1.1.
And started a pg_dump for one Database "BIB".
Now I alway getting this screen:

And see no chance to stopp this process, it's counting seconds on and on.
Restarting PGadmin did not work
Stopping SQLPostgres did not work

Any Idea?
Thanks from Berlin
Ralf
Attachments
Pg_dump.JPG
Pg_dump.JPG (21.55 KiB) Viewed 2244 times
alk
 
Posts: 23
Joined: Wed May 21, 2014 8:34 pm
Location: Berlin

Re: PG_Dump Problem

Postby Bernd.N » Wed Nov 02, 2016 10:32 pm

I had the same problem when restoring a 9.4.1 database on Postgres 9.6.
Robert told me I would have to use "plain text" when switching
https://forum.servoy.com/viewtopic.php?f=4&t=21467

But you say you see this when you backup a database, right?
In my case above, it seems that the new pgAdmin 4 did not recognize when something went wrong (because I did not use 'plain text' with pgDump), it just continued to count the seconds, while it already did go wrong with the message
'utf8' codec can't decode byte 0xbb in position 50: invalid start byte

I would try to bypass pgAdmin and use a command line in DOS for the backup, and then look what happens and what postgres respectively pgdump is telling you.
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 480
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: PG_Dump Problem

Postby alk » Thu Nov 03, 2016 10:24 am

Thanks Bernd,
my problem is:
I find no way to stopp this stupid window (this morning a had 56388.953 seconds passed.....)
is there in Postgres something like a "kill process" - command?

Since you are involved in Postgres, do you know a script, a book for beginner?

Greetings to Langenhorn

Ralf
alk
 
Posts: 23
Joined: Wed May 21, 2014 8:34 pm
Location: Berlin

Re: PG_Dump Problem

Postby Ruben79 » Thu Nov 03, 2016 11:35 am

In your OS process list, do yo also see that pg_dump is still running? Because I think it is one of the many bugs in pgAdmin 4.
I tried working with it for a couple of days with it but just gave up.

They really screwed up pgAdmin 4, it is not a working tool in my opinion and worse in every way compared to pgAdmin 3.
Ruben de Jong
Stb Software Development
SAN Partner

Stb Software Development - http://www.stb.nl
User avatar
Ruben79
 
Posts: 75
Joined: Wed Apr 18, 2007 12:43 pm

Re: PG_Dump Problem

Postby Bernd.N » Thu Nov 03, 2016 2:00 pm

Hi Ralf,
I had to use the task manager to stop the pgAdmin counting seconds.
I would not use the new pgAdmin 4 at the moment, it seems to still have bugs.
However, they just announced a new version with 40 bug fixes, see here:
https://www.pgadmin.org/

If that does not help, it may be more easy to install a postgres version with an older pgAdmin, or install the former pgAdmin separately, while I do not know if pgAdmin3 is compatibel to the latest postgres. postgres experts should know that, maybe you ask in a forum like stack overflow.

pgAdmin itself has not a forum but a mailing list, as far as I know.

For me it was a big help to use pgAdmin 3, as I did not like to type in commands at a DOS prompt for simple tasks like backup and restore.

You can google "postgres tutorial" and you get a lot of links, like http://www.postgresqltutorial.com/.
However postgres is in its heart SQL, and postgres itself has a good documentation: https://www.postgresql.org/docs/
You might also want to google "pgadmin tutorial"
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 480
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: PG_Dump Problem

Postby ROCLASI » Fri Nov 04, 2016 9:38 am

Hi Ralf,

PgAdmin 4 is a 100% rewrite (the 4th already, hence the '4' moniker) so it's bound to have bugs. It is designed to work as standalone, single-user app and as a multi-user server (web) app.
I am currently at the PostgreSQL Europe conference in Tallinn, Estonia and talked about your issue with the project lead of PgAdmin (Dave Page) and it seems you are bitten by a bug where PgAdmin looses track of the pg_dump/pg_restore process. So it thinks it's still running when in fact it is not, or even never ran at all.

See issue : https://redmine.postgresql.org/issues/1679

This bug is actively being worked on so is hopefully fixed in the upcoming version.

Update: should be fixed in version 1.2
Robert Ivens
ROCLASI Software Solutions / JBS Group, Partner
SAN Developer / Servoy Valued Professional / Servoy Certified Developer
Twitter: @roclasi / @servoyforge
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5230
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: PG_Dump Problem

Postby alk » Sun Nov 06, 2016 2:49 pm

Hi Robert and all the others,

thanks for your help and investigation.
I removed admin 4 and will use admin 3 a while.

And than I will make the switch form Postgres 9.5 to 9.6 (seemed to be some basic changings) an PDAdmin 4 1.2

Thanks,
Ralf
alk
 
Posts: 23
Joined: Wed May 21, 2014 8:34 pm
Location: Berlin

Re: PG_Dump Problem

Postby ROCLASI » Sun Nov 06, 2016 3:50 pm

Hi Ralf, Ruben and others,

pgAdmin 4 is quite different in the sense that it is written in Python (with use of Flask and QT) and is in fact a web app on the desktop (pgAdmin 3 is written in C++ with QT). This also means you can run it as a web application on a server. You can use it in single-user mode (desktop only) and in multi-user mode (desktop/server).
It does support all the features of pgAdmin 3 with the exception of hardly used features like managing Operators and other low level features (you can still use SQL to manage those). pgAdmin 4 also only supports PostgreSQL 9.2 and up where pgAdmin 3 supports 8.4 and an up. The reason for dropping the support for these versions is simple, PostgreSQL 9.1 and older are now End-Of-Life.

Support for pgAdmin 3 is also dropped with the release of pgAdmin 4. The people at BigSQL decided to fork the project to make the phasing out of pgAdmin 3 less sudden by providing Long Term Support (LTS) including for upcoming PostgreSQL 10.0 (out next year).
Their statement :
As v1.0 of pgAdmin4 was released in September of 2016, the pgAdmin Development Team decided to no longer support pgAdmin III with any more fixes. We believe that pgAdmin3 usage should fade out over time and have forked the code to include basic support for PostgreSQL 9.6 (no annoying warnings at startup).

The plan is for us to produce new Windows and OSX binaries for PostgreSQL 10 next year as well. pgAdmin3 LTS supports PostgreSQL 8.4 thru 9.6 whilst our pgAdmin4 Desktop only supports 9.2+.


For their pgAdmin 3 LTS Windows/macOS installers see : http://pgadmin3.org/
pgAdmin 4 is at https://www.pgadmin.org

So now you have a choice :)

Hope this helps.
Robert Ivens
ROCLASI Software Solutions / JBS Group, Partner
SAN Developer / Servoy Valued Professional / Servoy Certified Developer
Twitter: @roclasi / @servoyforge
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5230
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: PG_Dump Problem

Postby alk » Fri Feb 17, 2017 10:46 am

Hi Robert,
there seems to be a new version of PgAdmin.
Is it more stable and the above problems gone?
Or should I wait?

Annother short question.
I deleted my tables of the example_date database.
Yes, I can install the complete Servoy and its back,
but: can you send me a dump of this database (seems easier and I can experiment with the restore etc. function .....)
e-mail: [email protected]
Thanks
Ralf
alk
 
Posts: 23
Joined: Wed May 21, 2014 8:34 pm
Location: Berlin

Re: PG_Dump Problem

Postby ROCLASI » Tue Feb 21, 2017 10:30 am

Hi Ralf,

alk wrote:there seems to be a new version of PgAdmin.
Is it more stable and the above problems gone?
Or should I wait?

I haven't used the new version yet, but the ticket of the issue has the status 'Resolved'. However, they did link another issue that kind of describes the same thing and is planned for the next release (1.3)
Bug #1499
Subject: pgAdmin 4 - import file
Description
The file does not import. There is no progress bar, no messages. Selected the file, entered in all of the appropriate information, clicked on OK and nothing happened. Works fine in pgAdmin 3.

So it looks like it's not fully fixed.

alk wrote:Annother short question.
I deleted my tables of the example_date database.
Yes, I can install the complete Servoy and its back,
but: can you send me a dump of this database (seems easier and I can experiment with the restore etc. function .....)
e-mail: [email protected]
Thanks
Ralf

It might be easier to install Servoy again (in another directory for instance), I don't have the example database anymore.
Unless someone else is willing to send a dump of that database to you.

Hope this helps.
Robert Ivens
ROCLASI Software Solutions / JBS Group, Partner
SAN Developer / Servoy Valued Professional / Servoy Certified Developer
Twitter: @roclasi / @servoyforge
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5230
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: PG_Dump Problem

Postby Bernd.N » Tue Feb 21, 2017 1:46 pm

We decided to stick with postgres 9.4 as the pgAdmin3 in that version was very stable.
What I do not really understand is why the problems described above have not been detected during the pgAdmin4 beta phase, because dump and restore are most basic tasks for the pgAdmin.
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 480
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: PG_Dump Problem

Postby ROCLASI » Tue Feb 21, 2017 5:56 pm

Hi Bernd,

Bernd.N wrote:We decided to stick with postgres 9.4 as the pgAdmin3 in that version was very stable.

You can use pgAdmin 3 with 9.5 and 9.6 without any issues. And the command-line tools work fine too.

Bernd.N wrote:What I do not really understand is why the problems described above have not been detected during the pgAdmin4 beta phase, because dump and restore are most basic tasks for the pgAdmin.

This happens with pretty much every piece of software, after launch suddenly things start breaking in situations that they haven't tested it against.
It's also one of the reasons that a company like Apple has a long beta program now, just to get things more stable before it gets released.
Robert Ivens
ROCLASI Software Solutions / JBS Group, Partner
SAN Developer / Servoy Valued Professional / Servoy Certified Developer
Twitter: @roclasi / @servoyforge
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5230
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 2 guests