Re: [pgadmin-hackers] Install of pgadmin4 from package fails ...
Hi, On Wed, 2017-05-10 at 10:02 -0700, Josh Berkus wrote: > So to make this work, pgadmin-v1-web needs to be a completely separate > package, no? I don't think so, we can define Requires: part separately. Give me some time please, let me push today's releases out first, then next week I can work on this while pushing 1.5 RPMs. Can you please do me a favor, and create a ticket? https://redmine.postgresql.org/projects/pgrpms/issues/new You will be asked for your community user/pass. Thanks! Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Install of pgadmin4 from package fails ...
Hi, On Mon, 2017-05-08 at 10:20 -0700, Josh Berkus wrote: > > > > > Devrim, where is the source for this rpm build? > > > > https://yum.postgresql.org/srpms/testing/10/redhat/rhel-7-x86_64/repoview/p > > gadmin4-v1.html > > No, I mean the rpm template files, not the source of the software. They are in git repo: https://git.postgresql.org/gitweb/?p=pgrpms.git;a=tree;f=rpm/redhat/10/pgadmin4-v1/F-25;h=38dd5c1ad761688b3e8c9602fb1b2b48ccbda983;hb=HEAD Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Install of pgadmin4 from package fails ...
Hi Josh, Sorry for the late response, I have 10K unread emails as of now: On Tue, 2017-04-25 at 08:24 -0700, Josh Berkus wrote: > I know how to fix my personal install (and container image). But I want > to fix the RPM package so that it's fixed for most users. Right now, > install from RPM is kind of broken. > > Here's the changes that need to happen on the RPM: > > 1. Remove the QT dependencies for pgadmin4-v1-web Why? I thought we need them to run pgadmin4? > 2. Have the RPM create /usr/share/httpd/.pgadmin, owned by apache user. > (is this the best location? If not, what is?) Good question. I think that location is good. > 3. Fix the systemd unit file so that the pgadmin4 unit is owned by apache. Why? I did not read all the emails in this thread (yet), but all of the unit files are owned by root, and I see no exception on my system. > 4. (optional) set up files according to FDL standards, putting configs > for pgadmin4 in /etc/pgadmin and the db in /var/run/pgadmin (or similar). Red Hat does not care about that that much, does it? Especially for /etc part. > Devrim, where is the source for this rpm build? https://yum.postgresql.org/srpms/testing/10/redhat/rhel-7-x86_64/repoview/pgadmin4-v1.html Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Some questions about configuration and the pgadmin4-v1-web package
Hi Josh, On Thu, 2017-04-20 at 13:50 -0700, Josh Berkus wrote: > If I install the pgadmin4-v1-web package from Yum, it's a bit unclear on > what actual configuration needs to be done after that. Things I know > need to be done: > > * running setup.py > * copying the httpd/conf.d/pgadmin4-web.conf.example file to a .conf file > > Things I don't know if they need to be done: > > 1. creating data and log directories and assigning permissions on them > 2. changing the permissions on the sqlite db > 3. creating a config_local.py file and setting the five settings in it > > Can you clarify? On RHEL 7 / Fedora 25: * systemctl enable pgadmin4-v1.service; systemctl start pgadmin4-v1.service * cp /etc/httpd/conf.d/pgadmin4-v1.conf.sample /etc/httpd/conf.d/pgadmin4- v1.conf * systemctl start httpd.service should be enough, at least this is what I just tested on my Fedora 25 box. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] 1.4 sphinx error on RHEL 6
Hi, On Wed, 2017-04-19 at 09:31 +0100, Dave Page wrote: > > 1.0.8, which comes from EPEL. > > Urgh. Way too old. In the CI system, we use 1.4.9 for Python 2.6 and > 3.3 (the most recent version supporting those Pythons). Ok, found what broke this. -W switch was added to sphinx-build command in Makefile.sphinx between 1.3 and 1.4. I removed this for RHEL 6 builds. Now the package builds. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] 1.4 sphinx error on RHEL 6
Hi Dave, On Tue, 2017-04-18 at 14:34 +0100, Dave Page wrote: > What Sphinx version do you have? 1.0.8, which comes from EPEL. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] 1.4 sphinx error on RHEL 6
Hi Dave, On Tue, 2017-04-18 at 09:12 +0100, Dave Page wrote: > Yeah, we see that with Python 2.6. Don't worrk about it. Ok, but this is treated as an error, and the build stops there. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] 1.4 sphinx error on RHEL 6
Hi, This is new in 1.4: Any suggestions? -- sphinx-1.0-build -W -b html -d _build/doctrees . _build/html Making output directory... Running Sphinx v1.0.8 /usr/lib/python2.6/site-packages/flask_security/forms.py:67: DeprecationWarning: Required is going away in WTForms 3.0, use DataRequired email_required = Required(message='EMAIL_NOT_PROVIDED') /usr/lib/python2.6/site-packages/flask_security/forms.py:69: DeprecationWarning: Required is going away in WTForms 3.0, use DataRequired password_required = Required(message='PASSWORD_NOT_PROVIDED') loading pickled environment... not yet created building [html]: targets for 87 source files that are out of date updating environment: 87 added, 0 changed, 0 removed reading sources... [100%] view_dialog Warning, treated as error: /var/lib/pgsql/rpm/BUILD/pgadmin4-1.4/docs/en_US/connect_error.rst:4: ERROR: Interpreted text role "index" not implemented. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] pgAdmin 4 commit: Update Babel version.
Hi, Ok,.got it. Thanks! Regards, Devrim On April 1, 2017 12:34:35 AM GMT+03:00, Dave Page <dp...@pgadmin.org> wrote: >On Friday, March 31, 2017, Devrim Gündüz <dev...@gunduz.org> wrote: > >> >> Hi Dave, >> >> On Fri, 2017-03-31 at 21:03 +, Dave Page wrote: >> > Update Babel version. >> >> Uh, this is the version on Fedora 25. >> >> RHEL 6 comes with 0.9.4, and RHEL 7 comes with 1.3. Just a FYI. >> > >Doesn't really matter - the bug in question will only affect developers >who >recompile the message catalogs using Python 3. > >Thanks. > > >-- >Dave Page >Blog: http://pgsnake.blogspot.com >Twitter: @pgsnake > >EnterpriseDB UK: http://www.enterprisedb.com >The Enterprise PostgreSQL Company -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Re: [pgadmin-hackers] pgAdmin 4 commit: Update Babel version.
Hi Dave, On Fri, 2017-03-31 at 21:03 +, Dave Page wrote: > Update Babel version. Uh, this is the version on Fedora 25. RHEL 6 comes with 0.9.4, and RHEL 7 comes with 1.3. Just a FYI. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Last few steps for pgadmin4 on RHEL 6
Hi Dave, On Fri, 2017-03-24 at 13:14 +, Dave Page wrote: > OK - please try dropping the updated version of that package into the > web/ directory, and removing it from the system - so you have: > > Crypto/ > ... > web/ > pgadmin/ > about/ > browser/ > ... > > Does that work? Sorry for the delay, I'll take a look at this today. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Last few steps for pgadmin4 on RHEL 6
Hi, On Mon, 2017-03-20 at 12:10 +, Dave Page wrote: > Hey, I know "someone"! Let's call him Devrim :-) :-) > So, I think the easy way to do this is just install whatever is > available from the dependency list, regardless of version. Then, add > the packages you've built for anything that doesn't exist at all. > Then, just try running pgAdmin, and see what happens. It may be that > it just works, or it may be that we can fix any issues in code. It first failed with passlib: self._from_dict(kwds) File "/usr/lib/python2.6/site-packages/passlib/context.py", line 473, in _from_dict raise KeyError("known scheme in deprecated list: %r" % (scheme,)) KeyError: "known scheme in deprecated list: 'auto'" This went away after upgrading to my version. Following that, pgadmin4 failed with: File "/usr/lib/python2.6/site-packages/pgadmin4-web/pgadmin/utils/driver/psycopg2/__init__.py", line 28, in from pgadmin.utils.crypto import decrypt File "/usr/lib/python2.6/site-packages/pgadmin4-web/pgadmin/utils/crypto.py", line 15, in from Crypto import Random ImportError: cannot import name Random ...and error goes away when I update python-crypto package. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Last few steps for pgadmin4 on RHEL 6
Hi Dave, On Mon, 2017-03-20 at 10:44 +, Dave Page wrote: > I think the first question to answer is, of the packages that already > exist in Centos/EPEL, which ones are actually too old to be used? Don't know. Needs some testing from someone. > As I mentioned earlier in the thread, the version numbers in our > requirements.txt file are really just "the oldest versions we're tried > and know work" rather than a definitive list of absolute minimum > versions. I just finished documenting my work here: https://docs.google.com/spreadsheets/d/1PULZkQUrJYslVsuhBriPr0EhxD_0gf15niyn3KRf8KU/edit?usp=sharing You can see and compare/comment on the versions. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Last few steps for pgadmin4 on RHEL 6
Hi, On Fri, 2017-03-17 at 09:40 +, Dave Page wrote: > Hmm. That might be tricky. It might work if you just install it into > the web/ directory. If we can make sure that it works, I can rename all packages (like pgadmin4- python-crypto), edit spec files, install them under the web/ directory. This will prevent the breakage that I mentioned at the end of this email. > Is the default version actually too old? It is 2.0.1 on RHEL 6 (vs 2.6.1 on RHEL 7, which is the version that I also used in the PGDG updated packages), and I'm seeing 2.6.1 in the requirements.txt file. > It's quite possible it will work, but we just haven't tested back that far. > The version numbers in requirements.txt are really just what we know works, > rather than what actually will in many cases. Just a FYI -- this is the list of the packages that I either added to RHEL 6 (via PGDG repo, not EPEL), or updated to a new version: python-beautifulsoup4 python-blinker python-crypto python-dateutil python-fixtures python-flask python-flask-babel python-flask-gravatar python-flask-htmlmin python-flask-login python-flask-mail python-flask-principal python-flask-security python-flask-sqlalchemy python-flask-wtf python-html5lib python-htmlmin python-importlib python-itsdangerous python-jinja2 python-markupsafe python-mimeparse python-passlib python-pbr python-pyrsistent python-simplejson python-speaklater python-sqlalchemy python-sqlparse python-werkzeug python-wsgiref python-wtforms At this point, I'm seriously considering to invent another sub-repo, at least to host these python dependencies, if installing under web/ won't work. The Python packages are purely static, and won't be updated frequently enough. We can host the main pgadmin4 package in our repo, but then it will be users' responsibility to install the dependencies by using our repo, which may break their systems (or not, no idea) Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Last few steps for pgadmin4 on RHEL 6
Hi Dave, On Fri, 2017-03-17 at 08:57 +, Dave Page wrote: > > However, I am not too excited about the current situation in the repo, as I > > updated some RHEL 6 packages (like -crypto, etc), which may mean breakage > > to > > some servers. I'll think about that for a while. > > Oh, urgh. Can we create private versions of them? That's what we had > to do with ICU for EPAS in EDB; we have an edb-icu package which uses > the specific version we required. We *can*, but not sure it will work. Eventually it will overwrite to the same files (say, -crypto), and RPM will complain about conflicting packages -- or let me ask it the other way: Any chance to tell pgadmin4 to look at to "other" -crypto package content (say, pgadmin4-python-crypto) , instead of the OS supplied one? Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Last few steps for pgadmin4 on RHEL 6
Hi Dave, On Thu, 2017-03-16 at 07:44 +, Dave Page wrote: > That one is easy, there's a setting in config.py to enable/disable HTML > minimisation. Put that in config_distro.py and set it to False. Thank you! 1.3-2 RPMs on RHEL 6 in 9.6 testing repo now builds and run on RHEL 6 (x86_64). 32-bit RPMs are due next week. However, I am not too excited about the current situation in the repo, as I updated some RHEL 6 packages (like -crypto, etc), which may mean breakage to some servers. I'll think about that for a while. > In 1.4, that'll happen automatically with Python 2.6. Great! Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] Last few steps for pgadmin4 on RHEL 6
Hi, I spent a couple of hours this morning to build pgadmin4 dependencies on RHEL 6. I think I made them work, but pgadmin4 does not run (actually it runs, but the window comes empty). Here is the console output. Can you please take a look? [devrim@CentOS6x8664 ~]$ pgadmin4 Python path: "/usr/lib/python2.6/site-packages:/usr/lib64/python2.6/site-packages" Python Home: "" Webapp path: "/usr/lib/python2.6/site-packages/pgadmin4-web/pgAdmin4.py" /usr/lib/python2.6/site-packages/flask_security/forms.py:67: DeprecationWarning: Required is going away in WTForms 3.0, use DataRequired email_required = Required(message='EMAIL_NOT_PROVIDED') /usr/lib/python2.6/site-packages/flask_security/forms.py:69: DeprecationWarning: Required is going away in WTForms 3.0, use DataRequired password_required = Required(message='PASSWORD_NOT_PROVIDED') /usr/lib64/python2.6/site-packages/Crypto/Util/number.py:57: PowmInsecureWarning: Not using mpz_powm_sec. You should rebuild using libgmp >= 5 to avoid timing attack vulnerability. _warn("Not using mpz_powm_sec. You should rebuild using libgmp >= 5 to avoid timing attack vulnerability.", PowmInsecureWarning) loaded the Generic plugin can't make "generic.orientation" because no QAccelerometer sensors exist Exception in thread Thread-3: Traceback (most recent call last): File "/usr/lib64/python2.6/threading.py", line 532, in __bootstrap_inner self.run() File "/usr/lib64/python2.6/threading.py", line 484, in run self.__target(*self.__args, **self.__kwargs) File "/usr/lib64/python2.6/SocketServer.py", line 573, in process_request_thread self.handle_error(request, client_address) File "/usr/lib64/python2.6/SocketServer.py", line 570, in process_request_thread self.finish_request(request, client_address) File "/usr/lib64/python2.6/SocketServer.py", line 332, in finish_request self.RequestHandlerClass(request, client_address, self) File "/usr/lib64/python2.6/SocketServer.py", line 627, in __init__ self.handle() File "/usr/lib/python2.6/site-packages/werkzeug/serving.py", line 216, in handle rv = BaseHTTPRequestHandler.handle(self) File "/usr/lib64/python2.6/BaseHTTPServer.py", line 329, in handle self.handle_one_request() File "/usr/lib/python2.6/site-packages/werkzeug/serving.py", line 251, in handle_one_request return self.run_wsgi() File "/usr/lib/python2.6/site-packages/werkzeug/serving.py", line 193, in run_wsgi execute(self.server.app) File "/usr/lib/python2.6/site-packages/werkzeug/serving.py", line 181, in execute application_iter = app(environ, start_response) File "/usr/lib/python2.6/site-packages/flask/app.py", line 2000, in __call__ return self.wsgi_app(environ, start_response) File "/usr/lib/python2.6/site-packages/flask/app.py", line 1991, in wsgi_app response = self.make_response(self.handle_exception(e)) File "/usr/lib/python2.6/site-packages/flask/app.py", line 1567, in handle_exception reraise(exc_type, exc_value, tb) File "/usr/lib/python2.6/site-packages/flask/app.py", line 1988, in wsgi_app response = self.full_dispatch_request() File "/usr/lib/python2.6/site-packages/flask/app.py", line 1643, in full_dispatch_request response = self.process_response(response) File "/usr/lib/python2.6/site-packages/flask/app.py", line 1862, in process_response response = handler(response) File "/usr/lib/python2.6/site-packages/flask_htmlmin.py", line 27, in response_minify remove_comments=True, reduce_empty_attributes=True, remove_optional_attribute_quotes=False) File "/usr/lib/python2.6/site-packages/htmlmin/main.py", line 98, in minify minifier.feed(input) File "/usr/lib64/python2.6/HTMLParser.py", line 108, in feed self.goahead(0) File "/usr/lib64/python2.6/HTMLParser.py", line 152, in goahead k = self.parse_comment(i) File "/usr/lib64/python2.6/markupbase.py", line 174, in parse_comment self.handle_comment(rawdata[i+4: j]) File "/usr/lib/python2.6/site-packages/htmlmin/parser.py", line 281, in handle_comment data[1:] if data[0] == '!' else data)) ValueError: zero length field name in format If you want to test it yourself, the RPMs will be available in 9.6 *testing* repo in next 50 mins. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] pgadmin4 1.2 RPMs are now available
Hi, Thanks to Dave, pgAdmin4 1.2 RPMs are now ready on RHEL/CentOS 7 and Fedora 24 and 25. We have RPMs back to PostgreSQL 9.4 at this point. Please install them with: {yum,dnf} -y install pgadmin4-v1 if you are already using PostgreSQL YUM repo. If not, please visit this page for more details. https://yum.PostgreSQL.org If you have previous pgadmin4 RPMs installed on your system, you may see an issue with django-htmlmin package, which has been replaced with python-htmlmin package. Please remove that package first before upgrading. Unfortunately, since python-htmlmin comes from distro repos, we cannot add Obsoletes: to the spec file. Unfortunately, due to growing dependency hell, I don't think RHEL 6 support will be available. Please let me know if you see any packaging issues. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] theme to use while building docs
Hi, On Wed, 2016-11-16 at 13:10 +0300, Devrim Gündüz wrote: > I can do it in the community repo, but not sure if EPEL update will be > accepted > (I have the power to do so, but EPEL policy may be boring sometimes) > > I'll take a look. I already added 20+ more packages to community repo for > pgadmin4. Adding another may not hurt, hopefully, at least for the build > servers. Oh, just saw python-sphinx10 package in EPEL 6. That brings 1.0.8 to EL6. However, I will need to apply this patch on EL 6: --- docs/en_US/Makefile.sphinx.old 2016-11-16 13:16:31.885343501 +0300 +++ docs/en_US/Makefile.sphinx 2016-11-16 13:16:58.297102473 +0300 @@ -3,7 +3,7 @@ # You can set these variables from the command line. SPHINXOPTS= -SPHINXBUILD = sphinx-build +SPHINXBUILD = sphinx-1.0-build PAPER = BUILDDIR = _build So that it will use that sphinx version. Ok, I think we have a easier solution now, though -docs is not the only blocker in EL6. Let me work on the rest. Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] theme to use while building docs
Hi, On Wed, 2016-11-16 at 09:54 +, Dave Page wrote: > > Not at all knowing what Devrim was thinking, but perhaps you need something > > like what postgresql.org does for "difficult build dependencies". Which is > > build a snapshot tarfile that includes the *prebuilt* documentation, and > the > > same for releases of course. They don't go in git, but they go in the > > tarballs (we do that both for the docs and for things like the bison output > > in pg.org). And the tarballs contain nothing platform-specific (I assume), > > so they can be built on a platform that has easy access to those tools. > > Yeah, that could work. Though "difficult dependencies" is a stretch > here - it's really just that sphinx hasn't been updated in EPEL in > ages. It might be easiest to just get that RPM refreshed and be done > with it. I can do it in the community repo, but not sure if EPEL update will be accepted (I have the power to do so, but EPEL policy may be boring sometimes) I'll take a look. I already added 20+ more packages to community repo for pgadmin4. Adding another may not hurt, hopefully, at least for the build servers. Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] theme to use while building docs
Hi, On Wed, 2016-11-16 at 09:22 +, Dave Page wrote: > We can't not ship the docs. Or are you suggesting we pull the RPM from > another build and use that? It is just HTML files and images after > all. Hmm, that should work in theory, but RPM headers will be different in distros, so it may not work. What we can do is creating a tarball of .html files somewhere else, make them available in pgadmin.org, and then create -docs RPM using that tarball. Easy, one click. What do you think? Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] theme to use while building docs
Hi Dave, On Mon, 2016-11-14 at 09:41 +, Dave Page wrote: > Hmmm. It's because the version of Sphinx for EL7 and friends is really > quite old. We could probably add some Makefile magic to detect and > change it, but frankly it's probably easier (and will certainly be > much quicker) for you to just patch conf.py. Ok, patched conf.py. That said, Sphinx in EL6 is 0.something, and even does not accept the default parameters. We may want to disable docs builds on EL 6. Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] pgAdmin 4 1.1 RPMs released for RHEL 7, and Fedora 23, 24 and 25
Hi, After a great help from Dave, I pushed pgadmin4 1.1 RPMs to PostgreSQL YUM repository. RPMs are currently for the following platforms: * RHEL 7 * Fedora 25 (testing repo) * Fedora 24 * Fedora 23 Please note that we changed the package name, and it is now: pgadmin4-v1 To install it, please run on RHEL 7: yum install pgadmin4-v1 on Fedora: dnf install pgadmin4-v1 The RPM package version is 1.1-5. Important: If you have installed 1.0 before, please remove all packages prior to installing new packages. After removing them, please also remove ~/.pgadmin ~/.config/pgadmin ~/.config/pgAdmin* /etc/pgAdmin* directories before installing 1.1-5 packages. To run pgadmin4, either run it from the command line (by running pgadmin4), or click the menu item in the GUI. Please let me know if you see any issues with the packages. Thanks! Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] theme to use while building docs
Hi, On Mon, 2016-11-14 at 09:41 +, Dave Page wrote: > It's because the version of Sphinx for EL7 and friends is really > quite old. Right. > We could probably add some Makefile magic to detect and > change it, but frankly it's probably easier (and will certainly be > much quicker) for you to just patch conf.py. Ok, I can patch for now, but given that EL7 will be out for a long time, if there is a Makefile hack for next versions, that would be awesome. Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] theme to use while building docs
Hi, Any comments on this? I put 1.1 RPM package announcement on hold until we have a fix for this. Thanks! Regards, Devrim On Sat, 2016-11-12 at 22:54 +0300, Devrim Gündüz wrote: > Hi, > > While building docs on EL7 and F-23, I got this error: > > "no theme named 'classic' found (missing theme.conf?)" > > The reason is that sphinx in these distros don't have the classic theme. So, > I > can patch docs/en_US/conf.py , and change > > html_theme = 'default' > > in these distros. However, that will be a hack. Is this something we can fix > upstream, or should I really patch it myself? > > Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] theme to use while building docs
Hi, While building docs on EL7 and F-23, I got this error: "no theme named 'classic' found (missing theme.conf?)" The reason is that sphinx in these distros don't have the classic theme. So, I can patch docs/en_US/conf.py , and change html_theme = 'default' in these distros. However, that will be a hack. Is this something we can fix upstream, or should I really patch it myself? Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Running pgadmin4 as desktop application
Hi, On Fri, 2016-10-07 at 13:44 +0100, Dave Page wrote: > How can I reproduce your setup? I testing on an existing CentOS 7 VM. I'm testing on my Fedora 24 box. I'll switch to CentOS 7 and will let you know soon. Cheers, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Running pgadmin4 as desktop application
Hi Dave, On Thu, 2016-10-06 at 13:42 +0100, Dave Page wrote: > The global config file that Qt will read by default seems to be > "/etc/pgAdmin Development Team/pgAdmin 4.conf". > > I may change that for 1.1 to use a less obnoxious path. The contents > of it seem to need to be: > > [General] > ApplicationPath=../../../../usr/lib/python2.7/site-packages/pgadmin4-web/ > PythonPath="/usr/lib64/python2.7/site-packages/;/usr/lib/python2.7/site- > packages/" > > The ApplicationPath is the directory containing pgAdmin4.py. Due to a > bugette in the way the runtime works, it needs to be relative to the > location of the runtime, hence all the back-tracking. The PythonPath > needs to include both the 32 and 64 bit directories, as it seems that > some of the Python modules end up in each. > > That was enough to get it to start for me. This did not work for me :( Cheers, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] Running pgadmin4 as desktop application
Hi, Can you please clarify how to start pgadmin4 in desktop application mode? I read https://www.pgadmin.org/docs4/dev/desktop_deployment.html but when I run /usr/pgadmin4-1.0/runtime/pgAdmin4 (installed via community RPMs), I get: " An error occurred initialising the application server: Failed to locate pgAdmin4.py, terminating server thread." (as reported 2 days ago on the list), followed by a segfault. There is an ini file at the same directory, with contents like this: $ cat /usr/pgadmin4-1.0/runtime/pgAdmin4.ini [General] ApplicationPath=/usr/lib/python3.5/site-packages/pgadmin4-web PythonPath= Can you please give me a clue so that I can fix the packaging? Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Finalizing pgadmin4 RPM work
Hi Dave, On Mon, 2016-09-19 at 12:03 +0100, Dave Page wrote: > https://www.pgadmin.org/download/linux4.php > > How's that? If you have instructions, please send me text (or better > yet, a patch), and I'll add them. I added packages for 9.4 and 9.5, too. Also wrote a basic blog post about this: https://people.planetpostgresql.org/devrim/index.php?/archives/91-Installing-pgadmin4-to-Red-Hat,-CentOS,-and-Fedora.html Cheers, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Finalizing pgadmin4 RPM work
Hi Seçkin, On Fri, 2016-09-16 at 11:42 +0300, Seçkin Alan wrote: > https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/9.6/pgadm > in4/F- > 24/pgadmin4.desktop.in;h=362c0368fe54bd9b83fa55f57458af150d7d0942;hb=ad00835b > 6bb3615eebde2f253ebef438d3c27d48 > > Could you look this file ? > > this variable is incorrect > Name=pgAdmin III > > Its should be > Name=pgAdmin 4 > or > Name=pgAdmin IV Good catch! Fixed, thanks! Cheers, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Finalizing pgadmin4 RPM work
Hi, On Mon, 2016-09-12 at 11:46 +0100, Dave Page wrote: > > Awesome - thanks Devrim! I owe you a nice cool glass of spring water :-) \o/ Can't wait ;) > Let me know when packages available and ready to use, and I'll add a > page to the website to point people at them. They are currently available for 9.6 only, on yum.postgresql.org. All testing has been good so far. Feel free to add info to pgadmin website. I am planning to write a short blog post about that soon, about installation instructions, running, etc. Cheers, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] python-click dependency
Hi, On Mon, 2016-09-12 at 09:21 +0100, Dave Page wrote: > Ah, OK - added to requirements. Thanks dude! Cheers, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] beautifulsoup4, and Python 2.6
Hi, On Wed, 2016-09-14 at 09:26 +0100, Dave Page wrote: > I think it's actually a dependency of something else, not a direct > dependency of pgAdmin. It is listed both in requirements_py2.txt and requirements_py3.txt. Cheers, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] beautifulsoup4, and Python 2.6
Hi, Per https://www.crummy.com/software/BeautifulSoup/ , beautifulsoup4 requires Python 2.7+, which is not available on RHEL 6, which includes PY 2.6. I don't intend to build PY 2.7 into RHEL 6 (*swh*) , so any recommendations here? If we cannot satisfy this requirement, should we keep supporting PY 2.6? Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] importlib dependency?
Hi, python-importlib is mentioned in requirements_py2.txt, but not in requirements_py3.txt. Is that expected? Do we need importlib only in PY2? (I'm tired of building the dependency hell...) Thanks! Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Startup error on RHEL 7
Hi Dave, On Mon, 2016-09-12 at 12:07 +0100, Dave Page wrote: > > I don't have config_distro.py > > Please move those two lines into config_distro.py - that's intended > for distro-specific configuration, whilst config_loca.py is for > user-specific. Done. Cheers, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Startup error on RHEL 7
Hi Dave, On Mon, 2016-09-12 at 13:50 +0300, Devrim Gündüz wrote: > > - What version of Babel? > > python-babel-0.9.6 Argh. Upgrading it to 1.3 fixed the issue. Sorry for the noise. Cheers, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Startup error on RHEL 7
Hi Dave, On Mon, 2016-09-12 at 10:05 +0100, Dave Page wrote: > Hmm, not sure. Questions: > > - What version of Babel? python-babel-0.9.6 > - I assume (hope) you haven't changed config.py, but what's in > config_distro.py and config_local.py? $ cat /usr/lib/python2.7/site-packages/pgadmin4-web/config_local.py SERVER_MODE = False HTML_HELP = '/usr/share/doc/pgadmin4-docs/en_US/html/' I don't have config_distro.py > - Is the web/pgadmin/translations/ directory present and containing > files (a test French message catalog)? Yes: /usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/translations /usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/translations/fr /usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/translations/fr/LC_MESSAGES /usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/translations/fr/LC_MESSAGES/messages.mo /usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/translations/fr/LC_MESSAGES/messages.po > - Is babel.cfg present? Yes: $ cat /usr/lib/python2.7/site-packages/pgadmin4-web/babel.cfg [python: **.py] [jinja2: **/templates/**.html] [jinja2: **/templates/**.js] extensions=jinja2.ext.autoescape,jinja2.ext.with_ Cheers, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Finalizing pgadmin4 RPM work
Hi Dave, On Mon, 2016-09-12 at 09:56 +0100, Dave Page wrote: > > Any chance to add .desktop file to git, like we did for pgadmin3? > > Sure - I'd want to put it alongside the spec file. Have you written one? Just committed my version to pgrpms git: https://git.postgresql.org/gitweb/?p=pgrpms.git;a=commit;h=ad00835b6bb3615eebde2f253ebef438d3c27d48 I replace PYTHONDIR and PYTHONSITELIB within the spec file using sed, so that the same desktop file can work on PY3 and PY2 environments. Cheers, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Finalizing pgadmin4 RPM work
Hi, On Fri, 2016-09-09 at 11:26 +0100, Dave Page wrote: > For users to run in desktop mode, nothing else should be required, > except possibly a shortcut to the runtime executable. Any chance to add .desktop file to git, like we did for pgadmin3? > For all users, a config_distro.py file may be needed to to override > any of the default config settings with distro specific values. Ok, noted. > For users running in web mode, an Apache HTTPD config snippet should > be adding in /etc/httpd/conf.d. That should look something like this > (for httpd 2.4 - the Require All Granted will be different on earlier > version): > > WSGIDaemonProcess pgadmin processes=1 threads=25 > WSGIScriptAlias /pgadmin4 /opt/pgAdmin4/web/pgAdmin4.wsgi > > > WSGIProcessGroup pgadmin > WSGIApplicationGroup %{GLOBAL} > Require all granted > Done. > Finally; are you building and including the docs? Their location will > need to be in the config. Done. Thank you! Cheers, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] python-click dependency
Hi, I think pgadmin4 depends on python-click, but I did not see it mentioned anywhere. If so, can you please add it to requirements files, and also let me know the minimum version required? Thanks! -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] Startup error on RHEL 7
Hi, Just saw this on my RHEL 7 test box. This is pgadmin4 1.0rc1, Python 2.7, python-flask-babel-0.11.1: # /usr/bin/python2 /usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.py Traceback (most recent call last): File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.py", line 58, in app = create_app() File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/__init__.py", line 226, in create_app driver.init_app(app) File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/__init__.py", line 40, in init_app DriverRegistry.load_drivers() File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/registry.py", line 88, in load_drivers module = import_module(module_name) File "/usr/lib64/python2.7/importlib/__init__.py", line 37, in import_module __import__(name) File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/psycopg2/__init__.py", line 33, in from pgadmin.utils.exception import ConnectionLost File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/exception.py", line 15, in from pgadmin.utils.ajax import service_unavailable File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/ajax.py", line 124, in def not_implemented(errormsg=_('Not implemented.'), info='', result=None, data=None): File "/usr/lib/python2.7/site-packages/flask_babel/__init__.py", line 539, in gettext t = get_translations() File "/usr/lib/python2.7/site-packages/flask_babel/__init__.py", line 208, in get_translations return support.NullTranslations() AttributeError: 'module' object has no attribute 'NullTranslations' What am I missing here? Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] Finalizing pgadmin4 RPM work
Hi, I committed pgadmin4 WIP spec file a few days ago, and now I'd like to finalize the packaging. Right now, we have 2 packages: * pgadmin4-1.0-rc1_1.f24.x86_64 , includes: /usr/pgadmin4-1.0/runtime/pgAdmin4 /usr/pgadmin4-1.0/runtime/pgadmin4.ini * pgadmin4-web-1.0-rc1_1.f24.noarch , includes: - the rest. So, what is next? I assume I'd need to add a unit file / init script, right? Anything I'm missing? Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] RC1 did not hit website
Hi Dave, On Thu, 2016-09-01 at 11:33 +0100, Dave Page wrote: > > pgadmin.org still mentions about beta 4, it needs an update for RC1. > > > > Yes. We always 'officially' release after PostgreSQL. For a moment I thought it was Friday. Sorry :) Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] RC1 did not hit website
Hi, pgadmin.org still mentions about beta 4, it needs an update for RC1. Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] pgAdmin III commit: Bump version for 1.20.0
Hi, On Mon, 2016-01-04 at 13:11 +, Dave Page wrote: > That's 1.22.0 of course :-p :-) When will you release the tarball? The RPM packager is asking :) Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] pgAdmin III commit: Bump version for 1.20.0
Hi, On Mon, 2016-01-04 at 22:17 +, Dave Page wrote: > About 11 hours ago :-p. They're in the normal place on ftp.postgresql > .org. Oh :-) Thanks! I built RPMs on RHEL 6, RHEL 7 and Fedora 22, 23. Will push on Thursday. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] 1.20.0 build error on Fedora 23
Hi, On Tue, 2015-11-10 at 14:07 +0300, Timon wrote: > it happened after "harden" all packages > https://fedoraproject.org/wiki/Changes/Harden_All_Packages Right. Thanks for the link, I know the hardening thing, but it seems I forgot to add -pie to CFLAGS and CXXFLAGS. Now I can build it. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] 1.20.0 build error on Fedora 23
arget 'all-recursive' failed make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory '/home/devrim/Documents/Devrim/Projects/repo/pgrpms/rpm/redhat/9.5/pgadmin3/F-23/pgadmin3-1.20.0' Makefile:468: recipe for target 'all' failed make[1]: *** [all] Error 2 make[1]: Leaving directory '/home/devrim/Documents/Devrim/Projects/repo/pgrpms/rpm/redhat/9.5/pgadmin3/F-23/pgadmin3-1.20.0' error: Bad exit status from /var/tmp/rpm-tmp.HyQHMQ (%build) -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] [Fwd: [Bug 1188674] New: [abrt] pgadmin3: pgadmin3 killed by SIGSEGV]
Hi, FYI. Regards, Devrim Forwarded Message From: bugzi...@redhat.com To: dev...@gunduz.org Subject: [Bug 1188674] New: [abrt] pgadmin3: pgadmin3 killed by SIGSEGV Date: Tue, 03 Feb 2015 14:07:57 + https://bugzilla.redhat.com/show_bug.cgi?id=1188674 Bug ID: 1188674 Summary: [abrt] pgadmin3: pgadmin3 killed by SIGSEGV Product: Fedora Version: 20 Component: pgadmin3 Assignee: dev...@gunduz.org Reporter: darthl...@gmail.com QA Contact: extras...@fedoraproject.org CC: dev...@gunduz.org Description of problem: Attempted to import a CSV file into a table. Altered an offending column without exiting the import dialog. Pressed import again after altering the column, leading to the crash. Version-Release number of selected component: pgadmin3-1.20.0-1.fc20 Additional info: reporter: libreport-2.2.3 backtrace_rating: 3 cmdline:/usr/bin/pgadmin3 executable: /usr/bin/pgadmin3 kernel: 3.17.8-200.fc20.x86_64 runlevel: N 5 type: CCpp uid:1000 Truncated backtrace: Thread no. 1 (10 frames) #0 ?? #1 frmImport::OnOK at frm/frmImport.cpp:209 #2 wxEvtHandler::ProcessEventIfMatches at src/common/event.cpp:1239 #3 wxEventHashTable::HandleEvent at src/common/event.cpp:906 #4 wxEvtHandler::ProcessEvent at src/common/event.cpp:1301 #5 wxWindowBase::TryParent at src/common/wincmn.cpp:2661 #6 gtk_button_clicked_callback at src/gtk/button.cpp:53 #7 _g_closure_invoke_va at gclosure.c:840 #10 gtk_real_button_released at gtkbutton.c:1712 #11 _g_closure_invoke_va at gclosure.c:840 -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] [Fwd: [Bug 1184884] New: [abrt] pgadmin3: operator+(): pgadmin3 killed by SIGSEGV]
Another one... Forwarded Message From: bugzi...@redhat.com To: dev...@gunduz.org Subject: [Bug 1184884] New: [abrt] pgadmin3: operator+(): pgadmin3 killed by SIGSEGV Date: Thu, 22 Jan 2015 12:05:27 + https://bugzilla.redhat.com/show_bug.cgi?id=1184884 Bug ID: 1184884 Summary: [abrt] pgadmin3: operator+(): pgadmin3 killed by SIGSEGV Product: Fedora Version: 21 Component: pgadmin3 Assignee: dev...@gunduz.org Reporter: webdesig...@meta.ua QA Contact: extras...@fedoraproject.org CC: dev...@gunduz.org Version-Release number of selected component: pgadmin3-1.20.0-0.fc21 Additional info: reporter: libreport-2.3.0 backtrace_rating: 4 cmdline:/usr/bin/pgadmin3 crash_function: operator+ executable: /usr/bin/pgadmin3 kernel: 3.17.8-300.fc21.x86_64 runlevel: N 5 type: CCpp uid:1000 Truncated backtrace: Thread no. 1 (10 frames) #0 operator+ at src/common/string.cpp:1191 #1 sqlTable::GetColLabelValue at frm/frmEditGrid.cpp:2549 #2 wxGrid::GetColLabelValue at src/generic/grid.cpp:9590 #3 ctlSQLGrid::GetColKeyValue at ctl/ctlSQLGrid.cpp:536 #4 ctlSQLGrid::OnGridColSize at ctl/ctlSQLGrid.cpp:62 #5 wxEvtHandler::ProcessEventIfMatches at src/common/event.cpp:1239 #6 wxEventHashTable::HandleEvent at src/common/event.cpp:906 #7 wxEvtHandler::ProcessEvent at src/common/event.cpp:1301 #9 wxScrollHelperEvtHandler::ProcessEvent at src/generic/scrlwing.cpp:208 #10 wxGrid::SendEvent at src/generic/grid.cpp:6890 -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] [Fwd: [Bug 1184842] New: [abrt] pgadmin3: length(): pgadmin3 killed by SIGSEGV]
Another bug. Forwarded Message From: bugzi...@redhat.com To: dev...@gunduz.org Subject: [Bug 1184842] New: [abrt] pgadmin3: length(): pgadmin3 killed by SIGSEGV Date: Thu, 22 Jan 2015 10:48:50 + https://bugzilla.redhat.com/show_bug.cgi?id=1184842 Bug ID: 1184842 Summary: [abrt] pgadmin3: length(): pgadmin3 killed by SIGSEGV Product: Fedora Version: 21 Component: pgadmin3 Assignee: dev...@gunduz.org Reporter: webdesig...@meta.ua QA Contact: extras...@fedoraproject.org CC: dev...@gunduz.org Version-Release number of selected component: pgadmin3-1.20.0-0.fc21 Additional info: reporter: libreport-2.3.0 backtrace_rating: 4 cmdline:/usr/bin/pgadmin3 crash_function: length executable: /usr/bin/pgadmin3 kernel: 3.17.8-300.fc21.x86_64 runlevel: N 5 type: CCpp uid:1000 Truncated backtrace: Thread no. 1 (10 frames) #0 length at /usr/include/wx-2.8/wx/string.h:412 #1 empty at /usr/include/wx-2.8/wx/string.h:422 #2 wxStringBase at /usr/include/wx-2.8/wx/string.h:354 #3 wxString at /usr/include/wx-2.8/wx/string.h:690 #4 getAlias at ../pgadmin/include/gqb/gqbQueryObjs.h:87 #5 gqbGridOrderTable::GetValue at gqb/gqbGridOrderTable.cpp:65 #6 GetCellValue at include/wx/generic/grid.h:1489 #7 wxGridCellStringRenderer::GetBestSize at src/generic/grid.cpp:1963 #8 wxGridCellStringRenderer::Draw at src/generic/grid.cpp:1987 #9 wxGrid::DrawCell at src/generic/grid.cpp:7775 -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] [Fwd: [Bug 1184593] New: [abrt] pgadmin3: wxWindowBase::Close(): pgadmin3 killed by SIGSEGV]
One more bug report. Forwarded Message From: bugzi...@redhat.com To: dev...@gunduz.org Subject: [Bug 1184593] New: [abrt] pgadmin3: wxWindowBase::Close(): pgadmin3 killed by SIGSEGV Date: Wed, 21 Jan 2015 18:50:41 + https://bugzilla.redhat.com/show_bug.cgi?id=1184593 Bug ID: 1184593 Summary: [abrt] pgadmin3: wxWindowBase::Close(): pgadmin3 killed by SIGSEGV Product: Fedora Version: 21 Component: pgadmin3 Assignee: dev...@gunduz.org Reporter: jesusbarbo...@gmail.com QA Contact: extras...@fedoraproject.org CC: dev...@gunduz.org Version-Release number of selected component: pgadmin3-1.20.0-0.fc21 Additional info: reporter: libreport-2.3.0 backtrace_rating: 4 cmdline:/usr/bin/pgadmin3 crash_function: wxWindowBase::Close executable: /usr/bin/pgadmin3 kernel: 3.17.8-300.fc21.x86_64 runlevel: N 5 type: CCpp uid:1000 Truncated backtrace: Thread no. 1 (10 frames) #0 wxWindowBase::Close at src/common/wincmn.cpp:428 #1 frmMain::OnClose at frm/events.cpp:170 #2 wxEvtHandler::ProcessEventIfMatches at src/common/event.cpp:1239 #3 wxEventHashTable::HandleEvent at src/common/event.cpp:906 #4 wxEvtHandler::ProcessEvent at src/common/event.cpp:1301 #6 wxWindowBase::Close at src/common/wincmn.cpp:428 #7 gtk_frame_delete_callback at src/gtk/toplevel.cpp:271 #8 _gtk_marshal_BOOLEAN__BOXED at gtkmarshalers.c:86 #13 gtk_widget_event_internal at gtkwidget.c:5017 #14 gtk_widget_event at gtkwidget.c:4814 Potential duplicate: bug 1043180 -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] 1.18.1 tarball wrapped...
Hi, On Mon, 2013-10-07 at 16:25 +0100, Dave Page wrote: ...and uploaded to ftp://ftp.pgadmin.org/release/v1.18.1/src/ Please yelp ASAP if any problems are found. Built fine for all RPM related platforms. Pushing to repos tomorrow. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] 1.18.0 tarball uploaded
Hi, On Fri, 2013-08-30 at 12:45 +0100, Dave Page wrote: I've uploaded the 1.18.0 GA tarball to ftp://ftp.pgadmin.org/release/v1.18.0/src/. Please take a look and yelp if there are any showstopper issues! Builds fine on all Red Hat / Fedora flavors. Great work, guys! Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Next 1.16 point release?
Hi, On Sun, 2013-04-14 at 10:43 +0200, Guillaume Lelarge wrote: Hopefully for next PostgreSQL minor releases. Why? I think we missed at least PostgreSQL 2 releases so far, and some bugs makes 1.16 series unusable for 9.2. Why do we need to wait for the next PostgreSQL release? I would vote for a release nowadays. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] Bug report on Red Hat Bugzilla #877011
Hi, This was just reported, regarding a SIGSEGV: https://bugzilla.redhat.com/show_bug.cgi?id=877011 Can someone please look at the backtrace given there? Thanks! Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Bug report on Red Hat Bugzilla #877011
Hi, On Thu, 2012-11-15 at 14:39 +, Dave Page wrote: Please try 1.16.0. 1.14.0 is quite old, and there have been tons of bug fixes since that minor version, as well as the major increment since then. Hmm, I just noticed that I pushed 1.16 to f17 already. Let me ask him to update. Thanks for looking at this. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Updated pgAgent tarball
Hi, On Sat, 2012-09-15 at 09:13 -0400, Dave Page wrote: I've pushed a new pgAgent source tarball (3.3.0) to add support for PostgreSQL 9.2. http://www.postgresql.org/ftp/pgadmin3/release/pgagent/ Thanks! Pushed packages to the RPM repository. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] Building pgagent on Linux
Hi, I'm trying to build a standalone pgagent RPM. This is the same environment that I can build pgadmin3 w/o any issues. After untarring pgAgent-3.0.1-Source.tar.gz, and running cmake, I got the following error: === -- The C compiler identification is GNU -- The CXX compiler identification is GNU -- Check for working C compiler: /usr/lib64/ccache/gcc -- Check for working C compiler: /usr/lib64/ccache/gcc -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Check for working CXX compiler: /usr/lib64/ccache/c++ -- Check for working CXX compiler: /usr/lib64/ccache/c++ -- works -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done CMake Error at cmake/FindWX.cmake:271 (MESSAGE): The selected wxWidgets configuration (version: 2.8, debug: no, static: yes, unicode: yes, modules: base) is not available. Call Stack (most recent call first): CMakeLists.txt:91 (FIND_PACKAGE) -- Configuring incomplete, errors occurred! === Ok, so apparently it does not like wx configuration: # wx-config --selected-config gtk2-unicode-release-2.8 (Oh, why does pgagent need wx libraries?) Anyway, I thought I could build pgagent on a machine that pgadmin3 can be built, per README: === - A wxWidgets 2.8.x installation, configured per the requirements for pgAdmin: === Here are the wx packages that I have: === wxGTK-media-2.8.12-1.fc16.x86_64 wxGTK-gl-2.8.12-1.fc16.x86_64 wxGTK-devel-2.8.12-1.fc16.x86_64 wxGTK-2.8.12-1.fc16.x86_64 wxBase-2.8.12-1.fc16.x86_64 What am I missing here? Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Building pgagent on Linux
On Tue, 2011-12-06 at 14:26 +0530, Dave Page wrote: Ok, so apparently it does not like wx configuration: # wx-config --selected-config gtk2-unicode-release-2.8 Yeah, my guess is you need to configure it for a dynamic build, not static. Try something like: cmake -D STATIC_BUILD:BOOL=OFF . It did not work, either. Any other comments? The 3.0.0-Linux prebuilt binary is linked to libssl.so.0, which is not available on my distros, so I cannot use it -- and building from source is a better way for RPMs. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Building pgagent on Linux
On Tue, 2011-12-06 at 17:31 +0530, Dave Page wrote: How can I export PostgreSQL_CONFIG_EXECUTABLE? I read README, but it talks about pressing c somewhere, which should not be possible while building RPMs :P :-) cmake -D PG_CONFIG_PATH:FILEPATH=/usr/bin/pg_config -D STATIC_BUILD:BOOL=OFF . If you configure interactively using ccmake, you can check the values that were chosen in the CMakeCache.txt file when you've finished. Great, thanks! It worked. I will push pgagent RPMs later today or tomorrow Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] [Fwd: [Bug 746349] New: pgadmin3 1.14.0-1 built without -g in CFLAGS]
Hi, I think this is CXXFLAGS, not CFLAGS, but... I think we need to fix in pgadmin, not in RPMs. See the link below, please. Forwarded Message From: bugzi...@redhat.com To: dev...@gunduz.org Subject: [Bug 746349] New: pgadmin3 1.14.0-1 built without -g in CFLAGS Date: Fri, 14 Oct 2011 17:22:32 -0400 Please do not reply directly to this email. All additional comments should be made in the comments box of this bug. Summary: pgadmin3 1.14.0-1 built without -g in CFLAGS https://bugzilla.redhat.com/show_bug.cgi?id=746349 Summary: pgadmin3 1.14.0-1 built without -g in CFLAGS Product: Fedora Version: rawhide Platform: Unspecified OS/Version: Unspecified Status: NEW Keywords: Regression Severity: unspecified Priority: unspecified Component: pgadmin3 AssignedTo: dev...@gunduz.org ReportedBy: ville.sky...@iki.fi QAContact: extras...@fedoraproject.org CC: dev...@gunduz.org Blocks: 496968 Estimated Hours: 0.0 Classification: Fedora Story Points: --- Type: --- pgadmin3 1.14.0-1 is built without -g in CFLAGS, making -debuginfo useless: http://kojipkgs.fedoraproject.org/packages/pgadmin3/1.14.0/1.fc17/data/logs/x86_64/build.log -- Configure bugmail: https://bugzilla.redhat.com/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] pgAdmin v1.14.0-rc1 Built
Hi, On Fri, 2011-08-19 at 15:45 +0100, Dave Page wrote: And available here: http://ftp.pgadmin.org/release/v1.14.0-rc1/ in source, windows and mac downloads. Builds fine on Fedora, and RHEL clones. RPM packages will be available along with PostgreSQL 9.1 RC1. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Replacing developer.pgadmin.org
On Fri, 2011-05-20 at 20:06 +, Dave Page wrote: We're going to be replacing developer.pgadmin.org. Of those of you with accounts on the current box, can you please let me know how often you use it, and what you use it for? I used to upload RPMs, but I don't do it anymore. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] 1.12.3 built
FWIW, I haven't seen any announcement or changelog anywhere about this release. On Thu, 2011-04-14 at 22:00 +0100, Dave Page wrote: Source, windows and osx builds at http://developer.pgadmin.org/ftp/release/v1.12.3/ Please give them a sanity check! -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] 1.12.3 built
On Thu, 2011-04-14 at 22:00 +0100, Dave Page wrote: Source, windows and osx builds at http://developer.pgadmin.org/ftp/release/v1.12.3/ Please give them a sanity check! Built fine on Fedora 14. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Support for Slony 2.0?
On Wed, 2011-01-19 at 21:19 +0100, Guillaume Lelarge wrote: snip But before working on this, I want to make sure this won't be a useless effort. So I guess I would like to have a final decision on this. Do we decide to drop Slony support in 1.14, or do we decide that I can work on it, fix it, add support for 2.0, etc.? Talk is cheap for me. All I can do is testing. ...from a PoV of a user or a DBA from field, we need a real GUI that helps people to setup a Slony-I cluster easily -- or say, as easy as possible. So, if it is not too much effort, I'd say we need to support Slony. Cheers, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Support for Slony 2.0?
On Thu, 2011-01-20 at 18:37 +, Peter Geoghegan wrote: ...from a PoV of a user or a DBA from field, we need a real GUI that helps people to setup a Slony-I cluster easily -- or say, as easy as possible. I'm just not sure that PgAdmin actually makes setting up a Slony-I cluster easier than writing a Slonik script. It probably makes maintaining an existing cluster easier though. I pretty much agree with you -- but not all people can use cli, or can maintain Slony-I using altperl tools. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] 1.12.2 builds
On Mon, 2010-12-13 at 22:18 +0100, Dave Page wrote: Source, Mac and Windows builds are at http://developer.pgadmin.org/ftp/release/v1.12.2/. Please check and report any major problems. Packages built fine w/o any issues on my platforms. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] New minor release?
On Sat, 2010-12-11 at 11:11 +0100, Guillaume Lelarge wrote: So, should we have a new minor release? Yes, please Devrim - the packager that wants to do optimum work :) -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] [pgadmin-support] pgAdmin v1.12.0 Released
On Wed, 2010-10-13 at 03:14 -0500, Jason Long wrote: It is in http://yum.pgrpms.org/9.0/fedora/fedora-13-x86_64/, but not in http://yum.pgrpms.org/9.0/fedora/fedora-13-i386/ Done: http://yum.pgrpms.org/9.0/fedora/fedora-13-i386/repoview/pgadmin3_90.html Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] [pgadmin-support] pgAdmin v1.12.0 Released
On Fri, 2010-10-08 at 15:21 -0500, Jason Long wrote: I now see it in the fedora12 repository, but not in the fedora13 repository. I already compiled it to get it working, but I prefer to use yum. Should be in repo as of this morning. Fedora-13 RPMs lagged a bit intentionally, because I pushed more items to it already. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] pgAdmin 1.12.1 tarball available
On Mon, 2010-10-04 at 13:54 +0100, Dave Page wrote: I just uploaded the Windows and Mac binaries to http://developer.pgadmin.org/ftp/release/v1.12.1/ /D FWIW, pushed 9.0/2.12.1 RPMs to yum.pgrpms.org . Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] 1.12.0 release date
Given that 9.0.0 will be wrapped on Thursday, what are the plans of releasing 1.12.0 this Thursday or so? It would make my life (a.k.a. the RPM guy) easier... Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] No new pgAdmin3 releases for openSUSE?
On Wed, 2010-09-01 at 14:21 +0200, Olav Reinert wrote: Is there something I can do to improve this situation? OpenSuSE has an open build service to the community. You can maintain pgadmin3 using that service. https://build.opensuse.org/ Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] pgAdmin III commit: Tag REL-1_0 has been created.
On Sat, 2010-07-24 at 08:33 +, Dave Page wrote: Author: Anonymous Committer pgadmin-hackers@postgresql.org Hmm? :) -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] pgAdmin III v1.10.2 released
On Sun, 2010-03-14 at 21:49 +0100, Guillaume Lelarge wrote: The pgAdmin Development Team is pleased to announce the release of pgAdmin 1.10.2, the Open Source graphical PostgreSQL administration tool for Windows, Linux, FreeBSD, Mac OS X and Solaris, now available for download in source and a variety of binary formats from: http://www.pgadmin.org/download/ ...and I'm pleased to announce ( ;) ) that this new great version is available via the new PostgreSQL RPM repository, located at: http://yum.pgrpms.org Also, I pushed packages for Fedora 11-12-13-rawhide to Fedora repositories, and they will be available in a day or less. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] New minor release?
On Tue, 2010-03-09 at 11:14 +, Dave Page wrote: Please give them a look over and report any major problems before we announce folks. No issues on Fedora 12. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] pgAdmin3 MySQL to PostgreSQL converter?
On Tue, 2009-12-08 at 09:56 +0100, Jean-Michel Pouré wrote: Where can I download your migration wizard, It is in EDB website: http://www.enterprisedb.com/openDownloads.do?productId=407redirectReason=trueproductVersion=otherDownload If you are using CentOS 5/Fedora 11-12, it is also available in yum repository. Regards, -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] v1.10.1 uploaded
On Thu, 2009-12-03 at 15:42 +, Dave Page wrote: Please check for major issues prior to announcements! It built fine on Fedora rawhide. Regards, -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Bug report from Fedora: #542553
On Mon, 2009-11-30 at 15:00 +, Dave Page wrote: With no description (that I can see) of what the user was doing exactly, it's hard to suggest anything. For the records, here is what user did: https://bugzilla.redhat.com/show_bug.cgi?id=542553#c4 Another bug report was just filed: https://bugzilla.redhat.com/show_bug.cgi?id=543175 Regards, -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] Bug report from Fedora: #542553
Hi, This was filed today against Fedora 12: https://bugzilla.redhat.com/show_bug.cgi?id=542553 Regards, -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] v1.10.0 GA builds
On Mon, 2009-06-29 at 09:41 +0100, Dave Page wrote: I've uploaded the source tarball and Mac Windows binaries for 1.10.0 to http://developer.pgadmin.org/ftp/release/v1.10.0/. Please take a peek and yell if you spot any major problems! Devrim; can you run the source through the RPM buildfarm please? Done. Built on RHEL4,5 and Fedora 7+ without any problem. Cheers, -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] Forking pgadmin3 project
Hi, Per Dave's announcement, I decided to fork pgadmin3 project. Here is Dave's announcement: http://pgsnake.blogspot.com/2009/04/goodbye.html Here is the new project website: http://www.openpgadmin.info Please keep visiting the website for updates. We are in the process of stealing current code. As written in the webside, we will rewrite the code using Ruby-GTK. Using WX has been a pain over years. Also, we will switch to bitkeeper. I will announce new mailing list addresses later in that website. Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Beta 2
On Fri, 2009-03-20 at 13:57 +, Dave Page wrote: I'm thinking Monday for Beta 2. Any objections? None from me -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] pgAdmin 1.10.0 Beta 1 uploaded
On Thu, 2009-03-12 at 15:09 +, Dave Page wrote: I've uploaded beta 1 in source, win32 and OSX formats to http://developer.pgadmin.org/ftp/release/v1.10.0-beta1/. Please download and sanity check before I announce more widely tomorrow! If someone can generate some RPMs (Devrim? :-) ) that would be most helpful. Dave, is configure script supposed to be a binary file? I can open it via nano, however vi treats it as a binary file. I need to patch configure scripts for RPMs, and after editing file with nano, I get a stupid diff. I just noticed that nano warns me while opening this file: [ Read 9022 lines (Converted from Mac format) ] Is that normal? Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] pgAdmin 1.10.0 Beta 1 uploaded
Hi Dave, On Thu, 2009-03-12 at 20:50 +, Dave Page wrote: It was generated on a mac (which is basically bsd), but it should be ascii. What does it look like if u cat it? Hard to define :) A binary file with ascii footprints :) -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] pgAdmin 1.10.0 Beta 1 uploaded
On Thu, 2009-03-12 at 21:10 +, Dave Page wrote: Looks fine here on a Linux box: Ok, per IM conversation and various tests with Dave, we figured out that it was nano's fault for some reason. Sorry for the noise. Cheers, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] pgadmin3 removed from Fedora 10+
Hi, Just a FYI: Because of license issues, pgadmin3 was removed from Fedora 10 repository, and also it won't be in Fedora 11 and beyond. I will continue packaging pgadmin3 as usual in http://yum.pgsqlrpms.org , as usual. Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] [Fwd: Re: [GENERAL] temp schemas]
May be a TODO item here. Forwarded Message From: Tom Lane [EMAIL PROTECTED] To: Roberts, Jon [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] temp schemas Date: Thu, 28 Aug 2008 14:23:10 -0400 Roberts, Jon [EMAIL PROTECTED] writes: I am noticing a large number of temp schemas in my database. We use temp tables but it doesn't appear that the schemas get dropped for some reason. That's intentional. There doesn't seem a lot of value in dropping a catalog entry that'll just have to be created again later. This greatly slows down how long it takes pgAdmin to connect because it retrieves thousands of pg_temp_% schemas. Why have you got thousands of them? If you are running with thousands of active backends, may I suggest a connection pooler? (It might be a good idea to fix pgAdmin so it ignores other sessions' temp schemas, though.) regards, tom lane -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Building pgadmin3 against PostgreSQL 7.4
Hi Dave, On Thu, 2008-06-19 at 09:19 +0100, Dave Page wrote: http://buildsys.fedoraproject.org/logs/fedora-4-epel/39320-pgadmin3-1.8.4-1.el4/i386/build.log How can this be fixed, or should we ignore 7.4 support? We support running against 7.4 servers. but we haven't supported building against 7.4 for many years - in fact, 1.4.x required 8.0 or above, and since 1.6 we required an 8.1 libpq, which remains the minimum today. Hmmm, ok then. I won't build RHEL-4 package (for EPEL -- My repository has some EL-4 packages). Cheers, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] Building pgadmin3 against PostgreSQL 7.4
I got a few requests to push pgadmin3 to EPEL-4, and here is the build log for i386: http://buildsys.fedoraproject.org/logs/fedora-4-epel/39320-pgadmin3-1.8.4-1.el4/i386/build.log How can this be fixed, or should we ignore 7.4 support? -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] v1.8.4 uploaded
On Wed, 2008-06-04 at 10:11 +0100, Dave Page wrote: Due to an ugly bug found by Erwin, I've updated the new release to v1.8.4, and uploaded new builds in src, win32, osx and slackware formats to http://developer.pgadmin.org/ftp/release/v1.8.4. Please give them a once-over, and hopefully I can announce them tomorrow! 1.8.4 is successfully built on Fedora 7,8,9, RHEL 4,5 , on 32 and 64 bit arches. I pushed them to Fedora repositories for testing, and will submit to stable once you send the changelog to the list. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Synching RPM spec file with the community spec
Hi, On Sun, 2008-01-27 at 11:30 +, Dave Page wrote: I'd really like to have one file for all platforms if we can. ...or people will drop using (Open)SuSE and Mandriva :-P -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Synching RPM spec file with the community spec
Hi, On Sun, 2008-01-27 at 11:45 +, Dave Page wrote: ...or people will drop using (Open)SuSE and Mandriva :-P Yeah, well - we can all wish :-). I'll put that on my list along with the Ferrari Enzo... Wait, you can buy a Ferrari Enzo with money -- I have no idea about the other :-P -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] Synching RPM spec file with the community spec
Hi, On Fri, 2008-01-25 at 20:51 +, Dave Page wrote: https://projects.commandprompt.com/public/pgcore/browser/rpm/redhat/8.3/pgadmin3/F-9/pgadmin3.spec?format=raw This is the spec used in Fedora/EPEL and PGDG packages. Sure - but will it work on other platforms? ie. can I replace the mandrake, suse and redhat packaging directories with a single one for RPMs? I don't think so. I don't have SuSE and Mandrake around, but I think these specs may not work there. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [pgadmin-hackers] pgAdmin Icons
Hi, On Fri, 2008-01-25 at 18:26 +0100, Zdenek Kotala wrote: I'm currently integrating pgAdmin into JDS menu (gnome) and I'm looking for pgAdmin icon. Is there any official icon 48x48 and .desktop file? For icon, see pkg/debian/pgadmin3.xpm In the RPMs, we are generating the desktop file with this (the macros are expanded automagically): desktop-file-install --vendor fedora --dir $RPM_BUILD_ROOT/%{_datadir}/applications \ --add-category X-Fedora\ --add-category Application\ --add-category Development\ ./pkg/%{name}.desktop and its output is: [Desktop Entry] Encoding=UTF-8 Name=pgAdmin III Exec=/usr/bin/pgadmin3 Icon=/usr/share/pgadmin3/pgadmin3.xpm Type=Application Categories=Application;Development;X-Fedora; MimeType=text/html; DocPath=/usr/share/pgadmin3/docs/en_US/index.html Comment=PostgreSQL Tools X-Desktop-File-Install-Version=0.13 -HTH. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
[pgadmin-hackers] Synching RPM spec file with the community spec
Hi , Could a committer please commit this spec to pkg/redhat/pgadmin3.spec ? https://projects.commandprompt.com/public/pgcore/browser/rpm/redhat/8.3/pgadmin3/F-9/pgadmin3.spec?format=raw This is the spec used in Fedora/EPEL and PGDG packages. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part