[GENERAL] pgAdmin3 backup over ssh tunnel
Hi all I have the same problem is it is described here http://stackoverflow.com/questions/32398311/pgadmin3-backup-over-ssh-tunnel I use pgadmin 1.22.1 and when I try to make backup it instead of working with database over ssh tunel works with localhost database. How to fix it? It this bug fired? Best regards, Alex
Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?
On 28 March 2015 at 02:14, Yuri Budilov yuri.budi...@hotmail.com wrote: I am new to PostgreSQL and Linux (coming across from Microsoft SQL Server). I installed PostgreSQL 9.4 on Oracle Linux 6.6 and its working ok (psql, etc). Now I try to install pgadmin3 on the same OS. I am having problems installing pdadmin3 rpms on Oracle Linux 6.6 64-bit. I'm often somewhat surprised that people expect to have GUI tools on database servers. Why would you really? You can connect from anywhere using your OS of choice (or rather, the choice of your employer in most cases) - it's perfectly fine to run pgadmin3 on Windows to connect to a PostgreSQL database on Oracle Linux. And why waste potential DB cycles on a graphical environment? You don't need it. For most things it's plenty (and frequently a lot more powerful and reliable) to have a textual user interface through a remote terminal session over SSH or equivalent. Of course, there is a learning curve to be able to use the UNIX (or Linux) shell and its tools - start with 'man man' if you're new ;) That said, of course I agree that it should be possible to install pgadmin3 on Oracle Linux if you'd want to. -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?
Change OS, or change GUI tool https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools 2015-03-29 9:59 GMT+02:00 John R Pierce pie...@hogranch.com: On 3/29/2015 12:48 AM, Yuri Budilov wrote: Red Hat/Oracle Linux 6.x is that anything like Ford/Chevy ? Oracle Linux, while originally forked from Red Hat Enterprise Linux aka RHEL, has diverged significantly and is now its own thing. AFAIK, the Postgres yum repository has made no effort at maintaining compatibility with Oracle. Oracle Linux exists almost solely to help Oracle keep its Oracle Database users captive, and for Oracle to capture support revenue that might otherwise go to Red Hat. If you want a free alternative to RHEL, may I suggest you install CentOS ? its a package by package replica of RHEL, without divergence, other than branding. # cat /etc/redhat-release CentOS release 6.6 (Final) # ls /etc/yum.repos.d/pg* /etc/yum.repos.d/pgdg-92-centos.repo (this system has postgres 9.2 on it for testing purposes) # yum install pgadmin3_92 Loaded plugins: fastestmirror, presto Setting up Install Process Loading mirror speeds from cached hostfile * base: centos.arvixe.com * extras: mirrors.sonic.net * updates: mirror.web-ster.com Resolving Dependencies -- Running transaction check --- Package pgadmin3_92.x86_64 0:1.18.1-2.rhel6 will be installed -- Processing Dependency: wxGTK for package: pgadmin3_92-1.18.1-2.rhel6. x86_64 -- Processing Dependency: libwx_gtk2u_xrc-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_stc-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_html-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_core-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8.5)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_adv-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu_xml-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu_net-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu-2.8.so.0(WXU_2.8.5)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_xrc-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_stc-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_html-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_core-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_adv-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu_xml-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu_net-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Running transaction check --- Package wxBase.x86_64 0:2.8.12-1.el6.centos will be installed --- Package wxGTK.x86_64 0:2.8.12-1.el6.centos will be installed -- Processing Dependency: libXxf86vm.so.1()(64bit) for package: wxGTK-2.8.12-1.el6.centos.x86_64 -- Processing Dependency: libSDL-1.2.so.0()(64bit) for package: wxGTK-2.8.12-1.el6.centos.x86_64 -- Running transaction check --- Package SDL.x86_64 0:1.2.14-3.el6 will be installed --- Package libXxf86vm.x86_64 0:1.1.3-2.1.el6 will be installed -- Finished Dependency Resolution Dependencies Resolved === Package Arch Version RepositorySize === Installing: pgadmin3_92 x86_64 1.18.1-2.rhel6 pgdg92 3.2 M Installing for dependencies: SDL x86_64 1.2.14-3.el6 base 193 k libXxf86vm x86_64 1.1.3-2.1.el6 base 16 k wxBase x86_64
Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?
On 03/29/2015 12:48 AM, Yuri Budilov wrote: thanks Tim, I ran yum whatprovides and received no matches found. What repos are you using? See Devims answer for the Postgres community repo. I believe that pgadmin3 uses wxWidgets (according to the web site) but I can not find them in installable rpm format for Red Hat/Oracle Linux 6.x on their web site. The expectation is that would be handled by the packaging system for the distribution. In the event that is not the case, the download site at pgAdmin (http://www.pgadmin.org/download/) gives you links to other options, including the link Devim mentioned. the gtk libraries are already installed on my Linux, as is postgres 9.4. The errors from pgadmin3 installation appear to be specific to libwx_gtk* libraries, which are probably part of wxWidgets.org. I find this hard to believe that to just install and use pgadmin3 (as a DBA, not as a C++ programmer!) on Red Hat/Oracle Linux I must be building complete C++ application from sources using all sorts of disparate libraries. wxWidgets, I am sure, will have a bunch of other prerequisites, its like a dog chasing its tail. I just want to install and use pgadmin3 on one of the most common Linux platforms, RHEL. No you want to use it on Oracle Linux which is a derived distro, created by a company who sees Postgres as a competitor. Not sure they are all that interested in making Postgres easy to use. I expected smooth sailing, the PostgreSQL 9.4 was certainly easy to install and get going on RHEL/OL. Alas, not pgadmin4. What have I missed? Is there a step by step document describing how to do this (i failed to find it)? Is the prerequisite for pdagmin3 *installation* requires mastery of all of: Linux, C++ and wsWidgets? Is pgadmin3 not a widely used tool by PostgeSQL DBA community which is why there is such lack of good documentation on how to install it? I would say psql is probably a more widely used tool. The only time I use pgAdmin is when I am trying to solve other peoples problems with it. From what I have seen it is a good tool, it just does not fit my way of working. Thank you for reading thus far. Yuri Budilov -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?
On 3/29/2015 12:48 AM, Yuri Budilov wrote: Red Hat/Oracle Linux 6.x is that anything like Ford/Chevy ? Oracle Linux, while originally forked from Red Hat Enterprise Linux aka RHEL, has diverged significantly and is now its own thing. AFAIK, the Postgres yum repository has made no effort at maintaining compatibility with Oracle. Oracle Linux exists almost solely to help Oracle keep its Oracle Database users captive, and for Oracle to capture support revenue that might otherwise go to Red Hat. If you want a free alternative to RHEL, may I suggest you install CentOS ? its a package by package replica of RHEL, without divergence, other than branding. # cat /etc/redhat-release CentOS release 6.6 (Final) # ls /etc/yum.repos.d/pg* /etc/yum.repos.d/pgdg-92-centos.repo (this system has postgres 9.2 on it for testing purposes) # yum install pgadmin3_92 Loaded plugins: fastestmirror, presto Setting up Install Process Loading mirror speeds from cached hostfile * base: centos.arvixe.com * extras: mirrors.sonic.net * updates: mirror.web-ster.com Resolving Dependencies -- Running transaction check --- Package pgadmin3_92.x86_64 0:1.18.1-2.rhel6 will be installed -- Processing Dependency: wxGTK for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_xrc-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_stc-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_html-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_core-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8.5)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_adv-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu_xml-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu_net-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu-2.8.so.0(WXU_2.8.5)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_xrc-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_stc-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_html-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_core-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_adv-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu_xml-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu_net-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Running transaction check --- Package wxBase.x86_64 0:2.8.12-1.el6.centos will be installed --- Package wxGTK.x86_64 0:2.8.12-1.el6.centos will be installed -- Processing Dependency: libXxf86vm.so.1()(64bit) for package: wxGTK-2.8.12-1.el6.centos.x86_64 -- Processing Dependency: libSDL-1.2.so.0()(64bit) for package: wxGTK-2.8.12-1.el6.centos.x86_64 -- Running transaction check --- Package SDL.x86_64 0:1.2.14-3.el6 will be installed --- Package libXxf86vm.x86_64 0:1.1.3-2.1.el6 will be installed -- Finished Dependency Resolution Dependencies Resolved === Package Arch Version RepositorySize === Installing: pgadmin3_92 x86_64 1.18.1-2.rhel6 pgdg92 3.2 M Installing for dependencies: SDL x86_64 1.2.14-3.el6 base 193 k libXxf86vm x86_64 1.1.3-2.1.el6 base 16 k wxBase x86_64 2.8.12-1.el6.centos extras 572 k wxGTK x86_64 2.8.12-1.el6.centos extras 2.9 M Transaction Summary
Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?
On 3/29/2015 1:39 AM, Yuri Budilov wrote: my employer runs Oracle Linux 6.x and also Red Hat 6.x, so if we were to drop Oracle database and take PostgreSQL instead, I am afraid, everything must work on those two Linux platforms. We pay for support from Oracle and Red Hat for Linux OS. its installing on redhat isn't it ? might be worth opening a ticket with Oracle to find out why its not working on their system, then. On the client OS we use Windows 7 64-bit so the PostgreSQL tools and all drivers (JDBC, .NET, etc) need to also work on Windows as well as on Linux. If this is not available and we need to switch to Centos or another flavour of Linux, I am afraid, PostgreSQL is dead in the water, it wont even get a look in. well, these were the only RPMs' it took to install pgadmin3 for postgres 9.2 on my EL 6.6 system... so I dunno why Oracle Linux is not working. SDL-1.2.14-3.el6.x86_64.rpm libXxf86vm-1.1.3-2.1.el6.x86_64.rpm pgadmin3_92-1.18.1-2.rhel6.x86_64.rpm wxBase-2.8.12-1.el6.centos.x86_64.rpm wxGTK-2.8.12-1.el6.centos.x86_64.rpm I just ran the install for 9.4 and other than the actual pgadmin3 rpm, the rest of the dependencies are the same. -- john, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?
Hi, http://yum.postgresql.org/ has all the packages for pgadmin3 and its dependencies for Oracle Linux 6.X. Regards, Devrim On Sat, 2015-03-28 at 12:14 +1100, Yuri Budilov wrote: Hello everyone. I am new to PostgreSQL and Linux (coming across from Microsoft SQL Server). I installed PostgreSQL 9.4 on Oracle Linux 6.6 and its working ok (psql, etc). Now I try to install pgadmin3 on the same OS. I am having problems installing pdadmin3 rpms on Oracle Linux 6.6 64-bit.I selected the RedHat compatible installation i.e. without the Oracle enterprise kernel.It complains about missing libwx_gtk* packages when I try to do yum install pgadmin3*.86_64.rpm. The ISO file for Oracle Linux 6.6 (Packages directory of the distribution) does not have libwx* rpms and the gtk* rpms are already installed on my Oracle Linux 6.6 if I try to install them again. Perhaps I am looking in the wrong place?? Is there any document or web site which clearly tells me what i need to pre-install so that I can install pgadmin3 on Oracle Linux 6.x 64-bit ? I prefer not downloading the source code and trying to build it all in-place, so looking for binaries ready to be installed using rpm or yum. I dont have Red Hat support contract, hoping to make it work on Oracle Linux 6.6 with RHEL kernel. If this is the wrong forum for this question - please tell me where to ask this question. many thanks in advanceYuri BudilovAUstralia -- 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: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?
thanks Tim, I ran yum whatprovides and received no matches found. I believe that pgadmin3 uses wxWidgets (according to the web site) but I can not find them in installable rpm format for Red Hat/Oracle Linux 6.x on their web site. the gtk libraries are already installed on my Linux, as is postgres 9.4. The errors from pgadmin3 installation appear to be specific to libwx_gtk* libraries, which are probably part of wxWidgets.org. I find this hard to believe that to just install and use pgadmin3 (as a DBA, not as a C++ programmer!) on Red Hat/Oracle Linux I must be building complete C++ application from sources using all sorts of disparate libraries. wxWidgets, I am sure, will have a bunch of other prerequisites, its like a dog chasing its tail. I just want to install and use pgadmin3 on one of the most common Linux platforms, RHEL.I expected smooth sailing, the PostgreSQL 9.4 was certainly easy to install and get going on RHEL/OL. Alas, not pgadmin4. What have I missed? Is there a step by step document describing how to do this (i failed to find it)?Is the prerequisite for pdagmin3 *installation* requires mastery of all of: Linux, C++ and wsWidgets? Is pgadmin3 not a widely used tool by PostgeSQL DBA community which is why there is such lack of good documentation on how to install it? Thank you for reading thus far.Yuri Budilov Date: Sat, 28 Mar 2015 10:56:34 + From: tim.cla...@manifest.co.uk To: pgsql-general@postgresql.org Subject: Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ? Yuri the 'gtk' part suggests graphics libraries to me. Since Oracle linux is built on RedHat you can usefully use 'yum' package manager to search that distribution's installed repositories for your file with: sudo yum whatprovides \*libwx\* You may want to pipe that to less since it may give a long answer. Scan down for packages that will provide your libwx* file(s) and then install with 'yum install (package)'. Good luck! Tim Clarke On 28/03/15 01:14, Yuri Budilov wrote: Hello everyone. I am new to PostgreSQL and Linux (coming across from Microsoft SQL Server). I installed PostgreSQL 9.4 on Oracle Linux 6.6 and its working ok (psql, etc). Now I try to install pgadmin3 on the same OS. I am having problems installing pdadmin3 rpms on Oracle Linux 6.6 64-bit. I selected the RedHat compatible installation i.e. without the Oracle enterprise kernel. It complains about missing libwx_gtk* packages when I try to do yum install pgadmin3*.86_64.rpm. The ISO file for Oracle Linux 6.6 (Packages directory of the distribution) does not have libwx* rpms and the gtk* rpms are already installed on my Oracle Linux 6.6 if I try to install them again. Perhaps I am looking in the wrong place?? Is there any document or web site which clearly tells me what i need to pre-install so that I can install pgadmin3 on Oracle Linux 6.x 64-bit ? I prefer not downloading the source code and trying to build it all in-place, so looking for binaries ready to be installed using rpm or yum. I dont have Red Hat support contract, hoping to make it work on Oracle Linux 6.6 with RHEL kernel. If this is the wrong forum for this question - please tell me where to ask this question. many thanks in advance Yuri Budilov AUstralia
Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?
thanks, my employer runs Oracle Linux 6.x and also Red Hat 6.x, so if we were to drop Oracle database and take PostgreSQL instead, I am afraid, everything must work on those two Linux platforms.We pay for support from Oracle and Red Hat for Linux OS. On the client OS we use Windows 7 64-bit so the PostgreSQL tools and all drivers (JDBC, .NET, etc) need to also work on Windows as well as on Linux. If this is not available and we need to switch to Centos or another flavour of Linux, I am afraid, PostgreSQL is dead in the water, it wont even get a look in. Date: Sun, 29 Mar 2015 00:59:36 -0700 From: pie...@hogranch.com To: pgsql-general@postgresql.org Subject: Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ? On 3/29/2015 12:48 AM, Yuri Budilov wrote: Red Hat/Oracle Linux 6.x is that anything like Ford/Chevy ? Oracle Linux, while originally forked from Red Hat Enterprise Linux aka RHEL, has diverged significantly and is now its own thing. AFAIK, the Postgres yum repository has made no effort at maintaining compatibility with Oracle. Oracle Linux exists almost solely to help Oracle keep its Oracle Database users captive, and for Oracle to capture support revenue that might otherwise go to Red Hat. If you want a free alternative to RHEL, may I suggest you install CentOS ? its a package by package replica of RHEL, without divergence, other than branding. # cat /etc/redhat-release CentOS release 6.6 (Final) # ls /etc/yum.repos.d/pg* /etc/yum.repos.d/pgdg-92-centos.repo (this system has postgres 9.2 on it for testing purposes) # yum install pgadmin3_92 Loaded plugins: fastestmirror, presto Setting up Install Process Loading mirror speeds from cached hostfile * base: centos.arvixe.com * extras: mirrors.sonic.net * updates: mirror.web-ster.com Resolving Dependencies -- Running transaction check --- Package pgadmin3_92.x86_64 0:1.18.1-2.rhel6 will be installed -- Processing Dependency: wxGTK for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_xrc-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_stc-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_html-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_core-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8.5)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_adv-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu_xml-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu_net-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu-2.8.so.0(WXU_2.8.5)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu-2.8.so.0(WXU_2.8)(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_xrc-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_stc-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_html-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_core-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_gtk2u_adv-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu_xml-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu_net-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Processing Dependency: libwx_baseu-2.8.so.0()(64bit) for package: pgadmin3_92-1.18.1-2.rhel6.x86_64 -- Running transaction check --- Package wxBase.x86_64 0:2.8.12-1.el6.centos will be installed --- Package wxGTK.x86_64 0:2.8.12-1.el6.centos will be installed -- Processing Dependency: libXxf86vm.so.1()(64bit) for package: wxGTK-2.8.12-1.el6.centos.x86_64 -- Processing Dependency: libSDL-1.2.so.0()(64bit) for package: wxGTK-2.8.12-1.el6.centos.x86_64 -- Running transaction check --- Package SDL.x86_64 0:1.2.14-3.el6 will be installed --- Package libXxf86vm.x86_64 0:1.1.3-2.1.el6 will be installed -- Finished Dependency Resolution Dependencies Resolved
Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?
Yuri the 'gtk' part suggests graphics libraries to me. Since Oracle linux is built on RedHat you can usefully use 'yum' package manager to search that distribution's installed repositories for your file with: sudo yum whatprovides \*libwx\* You may want to pipe that to less since it may give a long answer. Scan down for packages that will provide your libwx* file(s) and then install with 'yum install (package)'. Good luck! Tim Clarke On 28/03/15 01:14, Yuri Budilov wrote: Hello everyone. I am new to PostgreSQL and Linux (coming across from Microsoft SQL Server). I installed PostgreSQL 9.4 on Oracle Linux 6.6 and its working ok (psql, etc). Now I try to install pgadmin3 on the same OS. I am having problems installing pdadmin3 rpms on Oracle Linux 6.6 64-bit. I selected the RedHat compatible installation i.e. without the Oracle enterprise kernel. It complains about missing libwx_gtk* packages when I try to do yum install pgadmin3*.86_64.rpm. The ISO file for Oracle Linux 6.6 (Packages directory of the distribution) does not have libwx* rpms and the gtk* rpms are already installed on my Oracle Linux 6.6 if I try to install them again. Perhaps I am looking in the wrong place?? Is there any document or web site which clearly tells me what i need to pre-install so that I can install pgadmin3 on Oracle Linux 6.x 64-bit ? I prefer not downloading the source code and trying to build it all in-place, so looking for binaries ready to be installed using rpm or yum. I dont have Red Hat support contract, hoping to make it work on Oracle Linux 6.6 with RHEL kernel. If this is the wrong forum for this question - please tell me where to ask this question. many thanks in advance Yuri Budilov AUstralia
[GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?
Hello everyone. I am new to PostgreSQL and Linux (coming across from Microsoft SQL Server). I installed PostgreSQL 9.4 on Oracle Linux 6.6 and its working ok (psql, etc). Now I try to install pgadmin3 on the same OS. I am having problems installing pdadmin3 rpms on Oracle Linux 6.6 64-bit.I selected the RedHat compatible installation i.e. without the Oracle enterprise kernel.It complains about missing libwx_gtk* packages when I try to do yum install pgadmin3*.86_64.rpm. The ISO file for Oracle Linux 6.6 (Packages directory of the distribution) does not have libwx* rpms and the gtk* rpms are already installed on my Oracle Linux 6.6 if I try to install them again. Perhaps I am looking in the wrong place?? Is there any document or web site which clearly tells me what i need to pre-install so that I can install pgadmin3 on Oracle Linux 6.x 64-bit ? I prefer not downloading the source code and trying to build it all in-place, so looking for binaries ready to be installed using rpm or yum. I dont have Red Hat support contract, hoping to make it work on Oracle Linux 6.6 with RHEL kernel. If this is the wrong forum for this question - please tell me where to ask this question. many thanks in advanceYuri BudilovAUstralia
[GENERAL] Pgadmin3 v1.14.2 foreign keys
I searched the archives and didn't find the answer as to how to add foreign keys to a table using pgadminIII v1.14.2. I am very familiar with relational databases and foreign keys, indices, etc., but I am a newbie to postgresql. For instance, say I have two tables, address and addresstype, both within the same schema. The column named type in the address table is the foreign key to the addresstype table, the primary key of which is named addresstype_id. I created those columns and added the primary key constraints without any difficulty. I tried adding the foreign key constraint, by right-clicking the constraints object for the address table in the object browser window and selecting add foreign key. I cannot figure out the next steps. Any help, please? Thank you. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Pgadmin3 v1.14.2 foreign keys
On 08/04/2012 01:10 PM, Mary F. Masterson wrote: I searched the archives and didn't find the answer as to how to add foreign keys to a table using pgadminIII v1.14.2. I am very familiar with relational databases and foreign keys, indices, etc., but I am a newbie to postgresql. For instance, say I have two tables, address and addresstype, both within the same schema. The column named type in the address table is the foreign key to the addresstype table, the primary key of which is named addresstype_id. I created those columns and added the primary key constraints without any difficulty. I tried adding the foreign key constraint, by right-clicking the constraints object for the address table in the object browser window and selecting add foreign key. I cannot figure out the next steps. Any help, please? Thank you. Walk through the tabs. 1) Properties Enter name 2) Definition Select table to reference. Also what type of MATCH and other properties 3) Columns Select parent/child columns 4) Action Type of action for UPDATE/DELETE 5) SQL Will show definition. -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Pgadmin3 v1.14.2 foreign keys
Thank you Adrian!! I was missing step two, selecting the table to reference. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] PGAdmin3 for CentOS-5_186_64 and pgdg91
I need a version of pgadmin4 which can handle pg-9.1 and which runs on RHEL5_186_64 architectures. I have installed the pgdg-91-centos.repo yum repo file from pgdgrpm.org. However: yum whatprovides */pgadmin3 --enablerepo=pgdg91 does not return anything. If I do exactly the same thing on a Centos5_i686 box then I see this instead: pgadmin3_91-1.14.0-3.rhel5.i386 : Graphical client for PostgreSQL Repo: pgdg91 Matched from: Filename: /usr/pgsql-9.1/bin/pgadmin3 Filename: /usr/pgsql-9.1/share/pgadmin3 Does anyone reading this message know where I can get pgadmin3_91-1.14.0-3.rhel5.i86_64 or why it is not available from pgdgrpm.org? Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PGAdmin3 for CentOS-5_186_64 and pgdg91
Hi, On Wed, 2012-01-11 at 09:58 -0500, James B. Byrne wrote: Does anyone reading this message know where I can get pgadmin3_91-1.14.0-3.rhel5.i86_64 or why it is not available from pgdgrpm.org? (Sorry for not replying you on pgadmin list and the private email) pgadmin3 cannot be built on stock RHEL 5 x86_64. That's why I pushed 32-bit version to the repository, in case it works :( 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: [GENERAL] PGAdmin3 for CentOS-5_186_64 and pgdg91
This message has been digitally signed by the sender. Re___GENERAL__PGAdmin3_for_CentOS_5_186_64_and_pgdg91.eml Description: Binary data - Hi-Tech Gears Ltd, Gurgaon, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] PGAdmin3 for 9.1 and CentOS-5_x86_64
I cannot seem to find a copy of pgadmin3 built for 9.1 on the x86_64 platform for the CentOS-5 (RHEL5) distro. I can find a pgadmin3 v1.14.1 rpm package for rhel6.x86_64 but none for rhel5.x86_64. I sent a message off to the maintainer last week but with the holidays no doubt it is sitting in his inbox. Does anyone here know if there is reason why CentOS-5 has the i386 package built for pgadmin3 v1.14.1 but not the x86_64? Or does it exist and I am simply not finding it? -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgAdmin3 not working with Gnome3
On Thu, 1 Sep 2011 21:12:59 -0700, Mike Christensen m...@kitchenpc.com wrote: Hi all - I'm on openSuse running the latest stable release of Gnome3 (Just trying it out, so far the fact I can't minimize windows is perhaps more than my old school brain can handle).. I've noticed in pgAdmin, basically no popup works. If I right click on the Databases branch and select New Database, nothing happens. If I right click on the Tables brand and select New Table, nothing happens.. I know for a fact this works when I logon with KDE.. If anyone wants more info from my system, just lemme know what I can do to get that for you.. Thanks!! Okay good news is that these menus do come up, bad news is the bug is even more obscure. Here's my setup: I have two monitors. Gnome3 allows you to create multiple desktops to organize your windows, however this only affects your primary monitor. I actually kinda like this, since I have my web browser on my second monitor and I can scroll through apps on my primary monitor. In this case, I had pgAdmin on my second monitor and some random app, like Eclipse on the primary monitor. I selected Create Database on pgAdmin and apparently nothing happened. What it actually did it spawned the new dialog on my primary monitor BUT on another virtual desktop. I finally noticed it when I flipped over to that one.. pgAdmin displays the dialog where it was the last time you opened it. AFAICT, it works with multiple monitors. We don't set any virtual desktop. I also use Gnome 3, and never saw incompatibilities between this window manager and pgAdmin3. I guess the bug can be fixed as: If the bug is in pgAdmin3... 1) Always spawn new child windows on the same monitor. or 2) In Gnome 3, create the window on the virtual desktop that's currently active.. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgAdmin3 not working with Gnome3
On Fri, 2011-09-02 at 09:30 +0200, Guillaume Lelarge wrote: I guess the bug can be fixed as: If the bug is in pgAdmin3... Could not reproduce any of those issues on Fedora 15. -- 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: [GENERAL] pgAdmin3 not working with Gnome3
Hi all - I'm on openSuse running the latest stable release of Gnome3 (Just trying it out, so far the fact I can't minimize windows is perhaps more than my old school brain can handle).. I've noticed in pgAdmin, basically no popup works. If I right click on the Databases branch and select New Database, nothing happens. If I right click on the Tables brand and select New Table, nothing happens.. I know for a fact this works when I logon with KDE.. If anyone wants more info from my system, just lemme know what I can do to get that for you.. Thanks!! Okay good news is that these menus do come up, bad news is the bug is even more obscure. Here's my setup: I have two monitors. Gnome3 allows you to create multiple desktops to organize your windows, however this only affects your primary monitor. I actually kinda like this, since I have my web browser on my second monitor and I can scroll through apps on my primary monitor. In this case, I had pgAdmin on my second monitor and some random app, like Eclipse on the primary monitor. I selected Create Database on pgAdmin and apparently nothing happened. What it actually did it spawned the new dialog on my primary monitor BUT on another virtual desktop. I finally noticed it when I flipped over to that one.. I guess the bug can be fixed as: 1) Always spawn new child windows on the same monitor. or 2) In Gnome 3, create the window on the virtual desktop that's currently active.. Mike -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] pgAdmin3 not working with Gnome3
Hi all - I'm on openSuse running the latest stable release of Gnome3 (Just trying it out, so far the fact I can't minimize windows is perhaps more than my old school brain can handle).. I've noticed in pgAdmin, basically no popup works. If I right click on the Databases branch and select New Database, nothing happens. If I right click on the Tables brand and select New Table, nothing happens.. I know for a fact this works when I logon with KDE.. If anyone wants more info from my system, just lemme know what I can do to get that for you.. Thanks!! Mike -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] pgAdmin3 Issue
I'd like to use pgadmin3 for DDL tasks with an imported database. Using version 1.10.2 on Slackware-13.1 with postgres-9.0.1. The application starts. I learned to define the server as 'localhost' rather than the hostname, so I can see entries in the left side, tree window. However, pgadmin3 fails to see any of the installed databases (and yes, the server is running). Perhaps related to this, is when I click on the database branch (showing 0 databases), I get a series of warning boxes, including one that says version 1.10.2 is for postgres-8.4 and below and, since I'm running 9.0.1 I should upgrade pgadmin3! Makes no sense. What do I need to do to display the databases in pgadmin3? Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgAdmin3 Issue
On 25/02/2011 19:49, Rich Shepard wrote: I'd like to use pgadmin3 for DDL tasks with an imported database. Using version 1.10.2 on Slackware-13.1 with postgres-9.0.1. The application starts. I learned to define the server as 'localhost' rather than the hostname, so I can see entries in the left side, tree window. However, pgadmin3 fails to see any of the installed databases (and yes, the server is running). Perhaps related to this, is when I click on the database branch (showing 0 databases), I get a series of warning boxes, including one that says version 1.10.2 is for postgres-8.4 and below and, since I'm running 9.0.1 I should upgrade pgadmin3! Makes no sense. What do I need to do to display the databases in pgadmin3? Upgrade to 1.12? Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgAdmin3 Issue
On Fri, 25 Feb 2011, Raymond O'Donnell wrote: Upgrade to 1.12? Ray, That appears to have done the trick. I somehow thought I was working on the latest version; it's been that sort of a week. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgAdmin3 Issue
On 25/02/2011 20:37, Rich Shepard wrote: On Fri, 25 Feb 2011, Raymond O'Donnell wrote: Upgrade to 1.12? Ray, That appears to have done the trick. I somehow thought I was working on the latest version; it's been that sort of a week. No problem - glad you're sorted. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] pgadmin3 and pgdesigner source
I installed pgsql 9.0 from source on my linux box, where can I get the latest pgadmin3 and pgdesigner source? -- Kind Regards, Rajinder Yadav | DevMentor.org | Do Good! ~ Share Freely GNU/Linux: 2.6.35-22-generic Kubuntu x86_64 10.10 | KDE 4.5.1 Ruby 1.9.2p0 | Rails 3.0.1 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgadmin3 and pgdesigner source
On 05/12/2010 11:06, Rajinder Yadav wrote: I installed pgsql 9.0 from source on my linux box, where can I get the latest pgadmin3 and pgdesigner source? Dunno about pgDesigner, but pgAdmin is here: http://www.pgadmin.org/download/source.php Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] PgAdmin3 for PostgreSQL 9 Linux version
Hello, What version of pgadmin3 to be used for postgresql 9 running on CentOS 5? I encountered some errors when i used the pgadmin3 1.8.4. I've search for newer version of pgadmin3 for Linux but no luck at all. TIA for you valuable help. -- Geramel - Share your knowledge. It's a way to achieve immortality - Dalai Lama -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PgAdmin3 for PostgreSQL 9 Linux version
On 25/11/2010 10:02, Gera Mel Handumon wrote: Hello, What version of pgadmin3 to be used for postgresql 9 running on CentOS 5? I encountered some errors when i used the pgadmin3 1.8.4. I've search for newer version of pgadmin3 for Linux but no luck at all. The current version of pgAdmin is 1.12.1, and you get it here: http://www.pgadmin.org/download Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgadmin3 hangs during dump
Dennis Gearon wrote: I set up the same characteristics on the console, and it runs fine, (COPY commands will import back, right? That's what it output.) On the console, it was: pg_dump -vaF p -f dbase.sql -U user-name dbase-name More details: about 11 tables, practically empty. no other fancy stuff like functions/views/installed languages/blah,blah running on Ubuntu latptop I don't know if I have log files set up or where they'd be. Well, what is needed so that anyone can help are still more details, like the software versions involved, whether the problem is repeatable or not, whether pgAdmin III hangs in the database or not (pg_locks ?), if yes, in which query it hangs, what exactly is getting dumped when it hangs, and best of all a self-contained example that would enable somebody else to reproduce the problem. Yours, Larenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgadmin3 hangs during dump
Is this the right place to post this? No, pgsql-general@postgresql.org is no place for posting questions about PgAdmin3, or for fatuous left wing rants. Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] pgadmin3 hangs during dump
Is this the right place to post this? I set up the same characteristics on the console, and it runs fine, (COPY commands will import back, right? That's what it output.) On the console, it was: pg_dump -vaF p -f dbase.sql -U user-name dbase-name More details: about 11 tables, practically empty. no other fancy stuff like functions/views/installed languages/blah,blah running on Ubuntu latptop I don't know if I have log files set up or where they'd be. Dennis Gearon Signature Warning EARTH has a Right To Life I agree with Bolivian President Evo Morales # The right to life: The right for no ecosystem to be eliminated by the irresponsible acts of human beings. # The right of biosystems to regenerate themselves: Development cannot be infinite. There's a limit on everything. # The right to a clean life: The right for Mother Earth to live without contamination, pollution. Fish and animals and trees have rights. # The right to harmony and balance between everyone and everything: We are all interdependent. See the movie - 'Inconvenient Truth' See the movie - 'Syriana' -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] pgadmin3
Hi guys, What happened to pgadmin3 rpms for fedora core 10? Aren't they built yet? BR, Pedro Doria Meunier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgadmin3 1.6.3 problem with geom fields
Pedro Doria Meunier wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All, I've installed pgadmin3 1.6.3 from rpm, under Fedora 7 It runs ok, *except* when the tables have geometry fields! :O When one tries to open/view the table it takes **forever** to display the table's records! (?) Issue being discussed with Pedro on the pgadmin-support list: http://www.pgadmin.org/archives/pgadmin-support/2007-06/msg00046.php Regards, Dave ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] pgadmin3 1.6.3 problem with geom fields
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All, I've installed pgadmin3 1.6.3 from rpm, under Fedora 7 It runs ok, *except* when the tables have geometry fields! :O When one tries to open/view the table it takes **forever** to display the table's records! (?) This is what I get when ps aux: doria 21930 89.7 20.9 672256 434116 pts/2 R+ 20:28 1:53 pgadmin3 ^ | Look at this processor hogging! It's becoming apparent that besides (perhaps) having something to do with (either) geos, proj, postgis, it might also something to do with gtk+, wxWidgets btw: I compiled geos-3.0.0rc4, proj-4.5.0, postgis-1.2.1 from source My system has wxGTK-2.8.3-2.fc7 installed. Some testing: Some tables (with geom fields) do show after some time. trying to scroll the list of records freezes pgadmin, however... I've tried to downgrade pgadmin3 1.6.3 to 1.6.2 and it exhibits the same behaviour... Any thoughts highly appreciated since I rely heavily on pgadmin3 for my work! :) Kind regards, Pedro Doria Meunier -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Remi - http://enigmail.mozdev.org iD8DBQFGdVZW2FH5GXCfxAsRAsDvAJ9P8QnzN/ebOzV+aQWVzIEZqPy+8QCcDZBh GRrKkEP91pUtu3pd2XeZCrU= =XMIa -END PGP SIGNATURE- ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] pgAdmin3 question
# [EMAIL PROTECTED] / 2006-04-07 14:31:04 -0700: A further question: we are using Debian system. So when we leave the 'Address' box blank (on the Add Server page of pgAdmin), according to the help file, it will go to use the default Postgresql socket on the local machine. We actually have a line as 'local all all ident sameuser' in the pg_hba.conf file. But when I tried, pgAdmin couldn't log the user in and shows Ident Authentication Failed. Then I modified the line pg_hba.conf file to 'local all all ident', and aaded a map line in the pg_ident.conf file to map the new user to user 'postgres'. Still not work. Did you instruct postmaster to reread the config files? http://www.postgresql.org/docs/8.1/static/client-authentication.html#AUTH-PG-HBA-CONF The pg_hba.conf file is read on start-up and when the main server process (postmaster) receives a SIGHUP signal. If you edit the file on an active system, you will need to signal the postmaster (using pg_ctl reload or kill -HUP) to make it re-read the file. http://www.postgresql.org/docs/8.1/static/auth-methods.html#AUTH-IDENT The pg_ident.conf file is read on start-up and when the main server process (postmaster) receives a SIGHUP signal. If you edit the file on an active system, you will need to signal the postmaster (using pg_ctl reload or kill -HUP) to make it re-read the file. -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] pgAdmin3 question
-Original Message- From: lmyho [mailto:[EMAIL PROTECTED] Sent: 07 April 2006 22:31 To: Dave Page; pgsql-general@postgresql.org Subject: RE: [GENERAL] pgAdmin3 question --- Dave Page dpage@vale-housing.co.uk wrote: We have test database created in the initdb cluster, but on the Add Server page of pgAdmin3, the Maintenance DB dropdown box does not show this database. How can we make it to display this db in the dropdown box too? You can't without hacking the code. How to do this? Add the required lines to the dlgServer constructor in src/dlg/dlgServer.cpp, then recompile pgAdmin, eg. cbDatabase-Append(wxT(postgres)); cbDatabase-Append(wxT(template1)); // Add additional database options cbDatabase-Append(wxT(research)); cbDatabase-Append(wxT(sales)); Regards, Dave. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] pgAdmin3 question
Hi All, Have a question on pgAdmin3: We have test database created in the initdb cluster, but on the Add Server page of pgAdmin3, the Maintenance DB dropdown box does not show this database. How can we make it to display this db in the dropdown box too? As the Maintenance DB dropdown box doesn't show this test db, we have to allow the owner of this test db (a new user created for this test db only) to access 'all' database in the pg_hba.conf file in order to allow it to login through pgAdmin. And once loged in, it of course has access to all databases including the postgres. How can we control this situation through pgAdmin? Any help would be greatly appreciated. Thanks, leo __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] pgAdmin3 question
We have test database created in the initdb cluster, but on the Add Server page of pgAdmin3, the Maintenance DB dropdown box does not show this database. How can we make it to display this db in the dropdown box too? You can't without hacking the code. Those databases are just helpful defaults. As the Maintenance DB dropdown box doesn't show this test db, we have to allow the owner of this test db (a new user created for this test db only) to access 'all' database in the pg_hba.conf file in order to allow it to login through pgAdmin. And once loged in, it of course has access to all databases including the postgres. How can we control this situation through pgAdmin? No, you don't have to allow access to all databases. You can type the name of the preferred maintenance DB, or grant the user access to 'postgres' as well as any other databases they need. 'postgres' is intended for this sort of use... Regards, Dave -Unmodified Original Message- Hi All, Have a question on pgAdmin3: We have test database created in the initdb cluster, but on the Add Server page of pgAdmin3, the Maintenance DB dropdown box does not show this database. How can we make it to display this db in the dropdown box too? As the Maintenance DB dropdown box doesn't show this test db, we have to allow the owner of this test db (a new user created for this test db only) to access 'all' database in the pg_hba.conf file in order to allow it to login through pgAdmin. And once loged in, it of course has access to all databases including the postgres. How can we control this situation through pgAdmin? Any help would be greatly appreciated. Thanks, leo __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] pgAdmin3 question
--- Dave Page dpage@vale-housing.co.uk wrote: We have test database created in the initdb cluster, but on the Add Server page of pgAdmin3, the Maintenance DB dropdown box does not show this database. How can we make it to display this db in the dropdown box too? You can't without hacking the code. How to do this? As the Maintenance DB dropdown box doesn't show this test db, we have to allow the owner of this test db (a new user created for this test db only) to access 'all' database in the pg_hba.conf file in order to allow it to login through pgAdmin. And once loged in, it of course has access to all databases including the postgres. How can we control this situation through pgAdmin? No, you don't have to allow access to all databases. You can type the name of the preferred maintenance DB, Yea! Worked by typing the new db name! Sorry didn't notice that we can type a name into the dropdown box.:( Thank you! A further question: we are using Debian system. So when we leave the 'Address' box blank (on the Add Server page of pgAdmin), according to the help file, it will go to use the default Postgresql socket on the local machine. We actually have a line as 'local all all ident sameuser' in the pg_hba.conf file. But when I tried, pgAdmin couldn't log the user in and shows Ident Authentication Failed. Then I modified the line pg_hba.conf file to 'local all all ident', and aaded a map line in the pg_ident.conf file to map the new user to user 'postgres'. Still not work. What has I done wrong? Or how should I use the ident authen way through pgAdmin? Thank you for your help!! regards, leo __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] PgAdmin3 for Suse AMD64
Dear All,I have two questions:1) One can used select * from pg_group to get list of groups BUT how does one get group membership say for this example find users who are under the group sales?! booktown=# SELECT * FROM pg_group; groname | grosysid | grolist+--+- sales |1 | {7017,7016} accounting |2 | marketing |3 | (3 rows)2) Where can i find Pgadmin3 rpms for Suse 9.3 for AMD64 Opterons (dual core)?Thank youHrishi
Re: [GENERAL] PgAdmin3 for Suse AMD64
select groname, grosysid, usename from pg_user right outer join pg_group on usesysid = any(grolist); This should do the job for 1). - Chandra Sekhar Surapaneni From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hrishikesh DeshmukhSent: Thursday, February 09, 2006 12:52 PMTo: pgsql-general@postgresql.orgSubject: [GENERAL] PgAdmin3 for Suse AMD64 Dear All,I have two questions:1) One can used select * from pg_group to get list of groups BUT how does one get group membership say for this example find users who are under the group sales?!booktown=# SELECT * FROM pg_group; groname | grosysid | grolist+--+- sales |1 | {7017,7016} accounting |2 | marketing |3 | (3 rows)2) Where can i find Pgadmin3 rpms for Suse 9.3 for AMD64 Opterons (dual core)?Thank youHrishi
[GENERAL] pgadmin3 / postgresql newbie question
hi all, running amd64 fedora core 3 w/ default postgresql 7.4.7-3. did asu - , su postgres and createdb mydb as explained in the postgresql tutorial. installed the latest pgadmin3 and am trying to connect to this database. as i wasn't sure what the FC3 default password was for postgres, i changed it to something i could remember. i can't seem to connect to the new database using pgadmin3. i have the correct IP address of the local computer, default port 5432, mydb as the initaldb, postgres as the username, and my new password as the password. i keep getting the error Error connecting to the server: could not connect to server: Connection refused Is the server running on host 192.168.1.24 and accepting TCP/IP connections on port 5432? i also verified the postgresql service is running, and that i've added the following to /etc/raddb/postgresql.conf: login = postgres password = mynewpassword and right underneath it: tcpip = true i've also disabled my local firewall and SELINUX just for kicks. and yes, i did a reboot. so...anyone know what else i can look at? many thanks! jonathan ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] pgadmin3 / postgresql newbie question
Did you start the postmaster using '-i' to allow tcp/ip connections? Sean On Mar 2, 2005, at 6:15 AM, Jonathan Schreiter wrote: hi all, running amd64 fedora core 3 w/ default postgresql 7.4.7-3. did asu - , su postgres and createdb mydb as explained in the postgresql tutorial. installed the latest pgadmin3 and am trying to connect to this database. as i wasn't sure what the FC3 default password was for postgres, i changed it to something i could remember. i can't seem to connect to the new database using pgadmin3. i have the correct IP address of the local computer, default port 5432, mydb as the initaldb, postgres as the username, and my new password as the password. i keep getting the error Error connecting to the server: could not connect to server: Connection refused Is the server running on host 192.168.1.24 and accepting TCP/IP connections on port 5432? i also verified the postgresql service is running, and that i've added the following to /etc/raddb/postgresql.conf: login = postgres password = mynewpassword and right underneath it: tcpip = true i've also disabled my local firewall and SELINUX just for kicks. and yes, i did a reboot. so...anyone know what else i can look at? many thanks! jonathan ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] pgadmin3 / postgresql newbie question
On Wed, 2 Mar 2005, Jonathan Schreiter wrote: hi all, running amd64 fedora core 3 w/ default postgresql 7.4.7-3. did asu - , su postgres and createdb mydb as explained in the postgresql tutorial. installed the latest pgadmin3 and am trying to connect to this database. as i wasn't sure what the FC3 default password was for postgres, i changed it to something i could remember. i can't seem to connect to the new database using pgadmin3. i have the correct IP address of the local computer, default port 5432, mydb as the initaldb, postgres as the username, and my new password as the password. i keep getting the error Error connecting to the server: could not connect to server: Connection refused Is the server running on host 192.168.1.24 and accepting TCP/IP connections on port 5432? i also verified the postgresql service is running, and that i've added the following to /etc/raddb/postgresql.conf: This file is part of the freeradius package, and despite the name, has nothing to do with your PostgreSQL configuration. The default path for the real PostgreSQL configuration file is: /var/lib/pgsql/data/postgresql.conf I don't know if running TCP/IP is a requirement for pgadmin3, but if you need to access the _local_ PostgreSQL server, most clients would do w/o configuring TCP/IP support at all. login = postgres password = mynewpassword and right underneath it: tcpip = true These do not belong to PostgreSQL server configurarion. It's RADIUS stuff. i've also disabled my local firewall and SELINUX just for kicks. and yes, i did a reboot. so...anyone know what else i can look at? 1) make sure postgresql is running (use ps - look for a postmaster process) 2) if it's not there, run following command as root: service postgresql start 3) if you want it to run automatically at boot, and it doesn't, run the following command as root: chkconfig postgresql on this won't start the process if it's not running. It just sets a flag for the next boot. 4) i don't get what you mean for changing postgres password. To switch to the postgres user, I usually switch to root first, and then to postgres. Root can switch to any user w/o password. Actually, it's good security practice not to assign any password to system pseudo-accounts (postgres is one of them) and leave them locked. If you need a different access method, I strongly suggest to look at the PostgreSQL way to authenticate users and stop using the 'ident' method (see pg_hba.conf), which forces you to run clients with a certain Unix user id. 5) try and access to the db with the psql client first. Use the same connection method you're using with pgadmin3, and run it under the same user you run pgadmin3 with. E.g.: psql -h localhost -p 5432 -U postgres mydb see psql manual for details. If you successfully get to 5), it's likely it's a pgadmin3 problem. .TM. -- / / / / / / Marco Colombo ___/ ___ / / Technical Manager / / / ESI s.r.l. _/ _/ _/ [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] pgadmin3 / postgresql newbie question
Did you set up the pg_hba.conf file with the proper security rights? Jonathan Schreiter [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] hi all, running amd64 fedora core 3 w/ default postgresql 7.4.7-3. did asu - , su postgres and createdb mydb as explained in the postgresql tutorial. installed the latest pgadmin3 and am trying to connect to this database. as i wasn't sure what the FC3 default password was for postgres, i changed it to something i could remember. i can't seem to connect to the new database using pgadmin3. i have the correct IP address of the local computer, default port 5432, mydb as the initaldb, postgres as the username, and my new password as the password. i keep getting the error Error connecting to the server: could not connect to server: Connection refused Is the server running on host 192.168.1.24 and accepting TCP/IP connections on port 5432? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] pgadmin3 / postgresql newbie question
That particular error message is typically associated with a missing pg_hba.conf entry that tells the postgreSQL server which remote machines to allow connections FROM # If you want to allow non-local connections, you need to add more # host records. Also, remember TCP/IP connections are only enabled # if you enable tcpip_socket in postgresql.conf. # TYPE DATABASEUSERIP-ADDRESSIP-MASK METHOD local all all trust # IPv4-style local connections: hostall all 127.0.0.1 255.255.255.255 trust # IPv6-style local connections: hostall all ::1 :::::::trust host all all 10.1.10.23 255.255.255.255 trust Regards Jonathan Schreiter [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] hi all, running amd64 fedora core 3 w/ default postgresql 7.4.7-3. did asu - , su postgres and createdb mydb as explained in the postgresql tutorial. installed the latest pgadmin3 and am trying to connect to this database. as i wasn't sure what the FC3 default password was for postgres, i changed it to something i could remember. i can't seem to connect to the new database using pgadmin3. i have the correct IP address of the local computer, default port 5432, mydb as the initaldb, postgres as the username, and my new password as the password. i keep getting the error Error connecting to the server: could not connect to server: Connection refused Is the server running on host 192.168.1.24 and accepting TCP/IP connections on port 5432? i also verified the postgresql service is running, and that i've added the following to /etc/raddb/postgresql.conf: login = postgres password = mynewpassword and right underneath it: tcpip = true i've also disabled my local firewall and SELINUX just for kicks. and yes, i did a reboot. so...anyone know what else i can look at? many thanks! jonathan ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] pgadmin3 / postgresql newbie question
pgadmin3 does not seem to want to connect to the server using UNIX sockets, it only does it through TCP. Set up the Postgres server to use TCP (as well as UNIX sockets) - i.e. - starting postmaster with the -i option, sorting it pg_hba.conf etc. Eddy Jonathan Schreiter wrote: hi all, running amd64 fedora core 3 w/ default postgresql 7.4.7-3. did asu - , su postgres and createdb mydb as explained in the postgresql tutorial. installed the latest pgadmin3 and am trying to connect to this database. as i wasn't sure what the FC3 default password was for postgres, i changed it to something i could remember. i can't seem to connect to the new database using pgadmin3. i have the correct IP address of the local computer, default port 5432, mydb as the initaldb, postgres as the username, and my new password as the password. i keep getting the error Error connecting to the server: could not connect to server: Connection refused Is the server running on host 192.168.1.24 and accepting TCP/IP connections on port 5432? i also verified the postgresql service is running, and that i've added the following to /etc/raddb/postgresql.conf: login = postgres password = mynewpassword and right underneath it: tcpip = true i've also disabled my local firewall and SELINUX just for kicks. and yes, i did a reboot. so...anyone know what else i can look at? many thanks! jonathan ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] pgadmin3 / postgresql newbie question
Jonathan Schreiter wrote: i can't seem to connect to the new database using pgadmin3. i have the correct IP address of the local computer, default port 5432, mydb as the initaldb, postgres as the username, and my new password as the password. i keep getting the error Error connecting to the server: could not connect to server: Connection refused Is the server running on host 192.168.1.24 and accepting TCP/IP connections on port 5432? Make sure to include the above address (or most likely the hostname equivalent) to your list of listen_addresses in postgresql.conf. -- Guy Rouillier ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] pgadmin3 on Gentoo
Hi, I'm really happy to see that pgadmin3 will run on Linux! I tried to build it on Gentoo but got errors. Was anybody of you able to build it for Gentoo or will there be an emerge file? Regards, Christian ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] pgadmin3 on Gentoo
On Tue, 02 Sep 2003 08:42:32 +0200 Christian Traber [EMAIL PROTECTED] wrote: Hi, I'm really happy to see that pgadmin3 will run on Linux! I tried to build it on Gentoo but got errors. Was anybody of you able to build it for Gentoo or will there be an emerge file? Can't help with the build problems but I have found this client is better than pga3 in its current state. http://squirrel-sql.sourceforge.net/ http://jdbc.postgresql.org/download.html http://java.sun.com/j2se/1.4.2/download.html Regards, Christian ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster