Re: Just downloaded the installer file

[Ray O'Donnell]

On 14/05/2024 16:01, Jarod Steed wrote:


I can’t tell where the program got saved to in my c drive, do you know 
what the default file path is for downloading the pgadmin-4-8.6-x64.exe?





I'd imagine that depends on your browser websites don't have control 
over that sort of thing, to my knowledge. Look in your browser settings 
and see where it is set to save downloads.


Ray..


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Last 2 versions with problems forcing me to use v8.3 from Feb 9

[Ray O'Donnell]

On 01/05/2024 15:06, Melanie Arnett wrote:


The March release does not provide a window for search and replace, 
thus, I cannot search and replace.




In the query tool, click the Edit menu (pencil icon), and you'll find 
Search & replace under there.


Ray.


The April release times out so I have to close out every query, close 
the application, and reopen every query each time there is a flicker 
in connectivity, which I experience somewhat regularly.


*Melanie Arnett*

Data Coordinator

Wyoming Natural Diversity Database

University of Wyoming

315 Berry Center, Dept. 3381

1000 E. University Ave

Laramie, WY 82071-3381

Phone: 307.766.2296

Email: arn...@uwyo.edu 

Web: http://www.uwyo.edu/wyndd 




--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Entity Relationship Diagrams

[Ray O'Donnell]

On 04/04/2024 20:54, Gus Spier wrote:
Didn't pgAdmin, once upon a time, have a feature that helped to create 
Entity Relationship Diagrams (ERD)?


Has it been dropped or moved to another feature?




I haven't used it, but it's still there, under the Tools menu.

Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: pgAdmin 8

[Ray O'Donnell]

On 27/11/2023 15:22, Dave Caughey wrote:
Please, don't remove the ability to close those system type tabs.   The 
ability to close them is a small but super improvement.

+1

There's a "Reset layout" item under the File menu.

Ray.




Agreed, there has to be an obvious way to reopen them, if you want them 
and accidentally close them, but I've waited years for the ability to be 
able to close them!


Cheers,
Dave


On Mon, 27 Nov 2023 at 10:11, Joe Tailleur > wrote:


Hi there,

In the new version of PGAdmin (8.0) the tabs, such as "Dashboard,
Properties, Statistics, SQL, etc) all have an "x" beside them now;
making them super easy to accidentally close.  Is there a way to
remove the 'x' for the system type tabs?

I also no longer see the "Lock Layout" option when I click on 'File"
in the menu.

I am running on Windows 11 Pro (22H2)


Joe.



--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: howto export txt

[Ray O'Donnell]

On 25/04/2023 07:10, Aykan Inal wrote:

Hi

I have reslt export to csv

But I request   export txt

How to  export txt file ? please help  step by step and screenshot please


I haven't used it, but pgAdmin does have a plain-text export option: 
right-click on the table you want to export, select "Import/export 
data", then "Export" in the dialog, and under "Format" choose "text".


Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Issues Restoring

[Ray O'Donnell]

On 04/01/2023 13:53, Tiffany wrote:
Hello, I’m on Windows. I installed pgadmin through Chrome, I hope that 
answers your question. When I try to restore, I don’t even see the 
pgadmin app available on my end and it keeps just re-installing. I only 
have the pgadmin exe available, not the pgadmin app.


Hi,

Please do reply-all so that your answer goes to the list as well.

I'm not sure what you mean by installing using Chrome... presumably you 
downloaded an installer and ran that? Since you're on Windows, I'm 
guessing that you got the installer here:


https://www.pgadmin.org/download/pgadmin-4-windows/

I'm afraid I don't know anything about Windows these days; I haven't 
used it in a long time. Maybe others on the list can help.


Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Issues Restoring

[Ray O'Donnell]

Hi there,

What platform are you on? And how did you install pgAdmin in the first 
instance?


Ray.


On 4 January 2023 09:40:17 Tiffany  wrote:
Good afternoon, I am taking a SQL course with Udemy and when I try to 
restore the pgadmin app, it doesn't appear. I have uninstalled/reinstalled 
several times and have not been successful.

Re: Configure my server

[Ray O'Donnell]

On 26/11/2022 18:10, William Torrez Corea wrote:

Where can I change the username and password?


On the server or in pgAdmin?

On the server, you execute:

  alter role willitc9888 password 'super-secret-password';

In pgAdmin, you first need to clear whatever password is already saved 
for this server, then set the new one. Right-click the server in the 
tree-view on the left, and click "Clear saved password"; when that's 
done, right-click the server once again, select "Properties", then the 
"Connection" tab, and the password field should be there.


Hope this helps,

Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Configure my server

[Ray O'Donnell]

On 26/11/2022 13:46, William Torrez Corea wrote:

I want make a connection but this fail:

I get the following message:

*Unable to connect to server connection to server at "localhost" (::1),*

* port 5432 failed: FATAL: password authentication failed for user
*

* "willitc9888" connection to server at "localhost" (::1), port 5432



This is coming from the server (or at least from whatever client library 
pgAdmin uses to communicate with the server), not from pgAdmin itself - 
it's the standard message you get when the wrong password is supplied.


Make sure that you have entered the correct password for (database user) 
"willitc9888".


Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: error open app

[Ray O'Donnell]

On 18/11/2022 10:48, Alina wrote:
Hello, when I open pgadmin4 app, I have this error message attached. 
Please help me with this error.


I'd be very wary about opening a Word file (or what claims to be a Word 
file) - you'd have a better chance of getting help by simply pasting the 
error message as plain text into your email.


Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: UI freezes on closing a tab

[Ray O'Donnell]

On 28/10/2022 11:43, Aditya Toshniwal wrote:

Hi Ray,

The issue is logged https://github.com/pgadmin-org/pgadmin4/issues/5465 
 and we're looking 
into it.

 From initial findings it looks related to NW.js wrapper.


Ah, OK, that's grand - thanks Aditya.

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: UI freezes on closing a tab

[Ray O'Donnell]

On 28/10/2022 10:57, Ray O'Donnell wrote:

Hi all,

Since the most recent update to 6.15, it sometimes happens that the 
pgAdmin UI freezes for several seconds after I click on the "Close" 
button for a tab.


Forgot to add: I'm running Kubuntu 22.04.

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

UI freezes on closing a tab

[Ray O'Donnell]

Hi all,

Since the most recent update to 6.15, it sometimes happens that the 
pgAdmin UI freezes for several seconds after I click on the "Close" 
button for a tab.


I haven't noticed any particular pattern, though the best I can make out 
is that when I start pgAdmin after a cold start of my laptop, it works 
fine - closing tabs is quick and the UI is as responsive as you'd 
expect. Once it start happening, though, it can take anything up to 10 
seconds for the tab to close and the UI to begin responding again.


I occasionally (often?) put my laptop to sleep by closing the lid, 
rather than shutting it down completely, i f this makes any difference.


What can I do to start diagnosing this? I'd like to create an issue on 
GitHubb, but I don't have any other details as yet.


Many thanks,

Ray O'Donnell.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Tree view stuck on fixed height

[Ray O'Donnell]

On 05/10/2022 16:51, Calle Hedberg wrote:

Hi,

Same here (windows 10 and 11).

Have you formally reported the bug?


Good point - I've created an issue:

https://github.com/pgadmin-org/pgadmin4/issues/5402

Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Tree view stuck on fixed height

[Ray O'Donnell]

On 04/10/2022 17:15, Richard Greenwood wrote:

Same here on Linux Mint 21.


Glad to hear it's not just me! :-)

I forgot to add that I've tried the "Reset layout" button, but no change.

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Tree view stuck on fixed height

[Ray O'Donnell]

Hi all,

Since the most recent update to pgAdmin4 6.14, the tree view on the left 
seems to be stuck at a specific height. When the pgAdmin window is 
taller, the tree view doesn't expand vertically to fill the available 
space; and when the window is smaller, the tree view extends out of 
sight below the bottom of the window.


I'm on Kubuntu 22.04, and here are some details from the "About" dialog:

Version: 6.14
Application Mode: Desktop
Current User: pgadm...@pgadmin.org
NW.js Version: 0.62.2
Browser: Chromium 99.0.4844.84
Operating System: Linux-5.15.0-48-generic-x86_64-with-glibc2.35
pgAdmin Database File: /home/rod/.pgadmin/pgadmin4.db
Log File: /home/rod/.pgadmin/pgadmin4.log

I haven't seen any other reports of this on the mailing list, so maybe 
it's just me


Thanks,

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Port 5432 failed password authentication failed

[Ray O'Donnell]

On 05/09/2022 13:57, Rasiklal Limbani wrote:

Dear support team
I recently installed postgresql on my Mac operating system. After 
successful installation I was able to connect with the sever and all was 
working fine.
Few days later I attempted to log in again, and as I had forgot my 
master password I did a reset password reset. This was successful, but 
now I find

myself not able to log on to my server as this password is incorrect.


This is a PostgreSQL issue rather than a pgAdmin one - as the message 
says, the password you are supplying for user "postgres" is incorrect.


As the PostgreSQL server is on your local Mac, you ought to be able to 
change it easily. One way is to edit pg_hba.conf and set the appropriate 
authentication mechanism to "trust", so that a password isn't required 
at all you can then connect and set the password for the "postgres" 
user:


alter role postgres password 'your new password';

Don't forget to change the authentication mechanism in pg_hba.conf back 
to what it was.


Hope this helps,

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: query tool - current_timestamp

[Ray O'Donnell]

On 03/09/2022 09:57, Polgár Benedek wrote:

Dear Support Team!

I noticed that in pgadmin4 version 6.13 the current_timestamp and now 
functions are not updated within the query tool.
So when I issue the command several times at later times in same query 
tool pane,

it always returns the same time (when the query tool was opened).


It works OK for me - repeatedly clicking the "Execute" button with

   select current_timestamp, now()

in the query tool returns an updated result every time.

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Autofocus on master password field

[Ray O'Donnell]

On 22/08/2022 05:24, Khushboo Vashi wrote:

Hello,

On Sun, Aug 21, 2022 at 2:42 AM Ray O'Donnell <mailto:r...@rodonnell.ie>> wrote:


Hi all,

A small niggle which would be very nice, if 'twere possible to do
When pgAdmin starts up and the master-password dialog pops up, it would
be very nice indeed if focus were already on the password input, rather
than the user having to click into it.

Please log this request @ 
https://redmine.postgresql.org/projects/pgadmin4/issues 
<https://redmine.postgresql.org/projects/pgadmin4/issues>


Done - created as issue 7633.

Thanks Khushboo,

Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Autofocus on master password field

[Ray O'Donnell]

Hi all,

A small niggle which would be very nice, if 'twere possible to do 
When pgAdmin starts up and the master-password dialog pops up, it would 
be very nice indeed if focus were already on the password input, rather 
than the user having to click into it.


It's only a small thing, but IMHO would make a difference to the user 
experience.


Thanks in hopeful advance

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Slow Scripts - Create Script

[Ray O'Donnell]

On 04/08/2022 14:09, endre_peka...@yahoo.com wrote:
Requesting Scripts-_Create Script_ for Tables or Views is very slow in 
PGAdmin r4 version 6.12.  I have version 4.24 also, using this version, 
it is almost instant.


PGAdmin 4 version 6.12, it takes 30-40 seconds

PGAdmin 4 version 4.24, it takes 2-3 seconds

Is it expected behavior for later versions?


I takes only 2-3 seconds for me, and I'd guess that a lot of that is 
just rendering the window. I'm on version 6.12.


Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Reorder servers?

[Ray O'Donnell]

On 25/10/2021 05:30, Khushboo Vashi wrote:
On 6.1, the object listing order is alphanumeric, so it should work, 
please clear your browser cache and check again.


Hello Khushboo - thanks for responding. I should have been clearer; I'm 
using the desktop version of pgAdmin, rather than a browser. It's 
pgAdmin 6.1 on Ubuntu (actually Kubuntu) 21.04 (Hirsute), installed from 
the package "pgadmin4-desktop" from the pgAdmin apt repo.


Anyway, having posted about the issue, when I started up pgAdmin today 
(after a cold start of the laptop), the servers were in fact sorted 
alphabetically, as I'd expect them to be! Sigh


I wonder if it's related to this issue:

https://redmine.postgresql.org/issues/6955

I won't create a new issue for the moment. However, it would be nice to 
be able to rearrange the servers to an arbitrary order.


Thanks again,

Ray.



--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Reorder servers?

[Ray O'Donnell]

Hi all,

In pgAdmin's tree view (on the left) of servers, databases, etc etc, is 
it possible to reorder servers as listed?


On my installation servers are showing in the order in which I added them:

- Local 13/main
- Local 14/main
- Local 11/main

I find the non-alphabetical sequence a tad off-putting! - so I'd like to 
be able to select the order in which they're listed. I'm running 
pgAdmin4 6.1, on Ubuntu.


Thanks,

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Starting pgAdmin4 on Ubuntu 21.04

[Ray O'Donnell]

On 16/06/2021 11:28, Ray O'Donnell wrote:

On 16/06/2021 11:22, Anthony DeBarros wrote:
Hello! I just did a fresh install of pgAdmin 4 v5.3 on Ubuntu 21.04 
Hirsute using the steps at 
https://www.pgadmin.org/download/pgadmin-4-apt/ 
<https://www.pgadmin.org/download/pgadmin-4-apt/>.


I followed those install steps after the ones I normally try, at 
https://wiki.postgresql.org/wiki/Apt 
<https://wiki.postgresql.org/wiki/Apt>, led to a message that pgAdmin 
was not available for Hirsute.


Hi there,

It is available for Hirsute - I've running Kubuntu, and installed it via 
apt as above.


Sorry - I should have said that you need to get it from the pgAdmin 
repo, rather than the PostgreSQL one:


  https://www.pgadmin.org/download/pgadmin-4-apt

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Starting pgAdmin4 on Ubuntu 21.04

[Ray O'Donnell]

On 16/06/2021 11:22, Anthony DeBarros wrote:
Hello! I just did a fresh install of pgAdmin 4 v5.3 on Ubuntu 21.04 
Hirsute using the steps at 
https://www.pgadmin.org/download/pgadmin-4-apt/ 
.


I followed those install steps after the ones I normally try, at 
https://wiki.postgresql.org/wiki/Apt 
, led to a message that pgAdmin 
was not available for Hirsute.


Hi there,

It is available for Hirsute - I've running Kubuntu, and installed it via 
apt as above.


In any event, the application icon now appears in the Activities 
overview, and I can launch pgAdmin successfully.


Question:

In past pgAdmin installs when I used the steps on the PostgreSQL wiki, I 
was able to launch pgAdmin by entering "pgadmin" at my Terminal prompt. 
This does not work under my new install. Is that expected behavior now 
that pgAdmin is a standalone app?


I'd imagine that this is down to the packaging rather than pgAdmin 
itself. Anyway, examining the menu entry on my laptop reveals the 
following command launches it:


   /usr/pgadmin4/bin/pgadmin4

So you could maybe add /usr/pgadmin4/bin to your PATH, or set up an 
alias in your .profile, or something like that.


I hope that this helps.

Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: pgAdmin4 on Kubuntu Hirsute

[Ray O'Donnell]

On 04/05/2021 08:39, Dave Page wrote:

Hi

On Tue, May 4, 2021 at 6:34 AM Aditya Toshniwal 
> wrote:


Hi Ray,

A working solution would be to recreate the symlink to match your
python. Use the below command -

*|sudo rm /usr/pgadmin4/venv/bin/python3 && sudo ln -s
/usr/bin/python3.9 /usr/pgadmin4/venv/bin/python3|*

There's a pretty good chance that won't work; any of the python modules 
in the venv that use cpython will be linked against Python 3.8.


Hi Dave,

Indeed - it didn't work when I ran /usr/bin/python3.9 directly.

Ray, we do have snapshot builds for Hirsute - you would probably be best 
using them until 5.3 is released: 


I've done that, and it works - thanks a million!

Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: pgAdmin4 on Kubuntu Hirsute

[Ray O'Donnell]

On 03/05/2021 07:17, Akshay Joshi wrote:
I would suggest activating the virtual environment  "source 
/usr/pgadmin4/venv/bin/activate" and then try to run 
"/usr/pgadmin4/venv/bin/python3 -s /usr/pgadmin4/web/pgAdmin4.py" and

check whether it works or the same error.


Hello Akshay,

Thanks for responding. I tried that the "activate" command worked, 
and the command prompt now had "(venv)" in front of it. However, the 
second command failed with:


/usr/pgadmin4/venv/bin/python3: No such file or directory

When I look into that directory, /usr/pgadmin4/venv/bin/python3 is 
symlinked to /usr/bin/python3.8. However, on my system I see instead 
/usr/bin/python3.9. Just for fun, I tried running:


/usr/bin/python3.9 -s /usr/pgadmin4/web/pgAdmin4.py

However, it failed with:

Traceback (most recent call last):
  File "/usr/pgadmin4/web/pgAdmin4.py", line 16, in 
from cheroot.wsgi import Server as CherootServer
ModuleNotFoundError: No module named 'cheroot'

As I said in my first email, I appreciate that my Kubuntu version is 
ahead of the supported ones; so I'm happy enough to wait until a pgAdmin 
version which works on my computer is released - at the rate at which 
you guys work, I'm sure that won't be long! In the meantime, I still 
have psql. :-)


Thanks,

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

pgAdmin4 on Kubuntu Hirsute

[Ray O'Donnell]

Hi all,

I've just installed the latest Kubuntu (21.04 Hirsute) onto a new 
laptop, and I can't get pgAdmin4 5.2 to start. I know that Hirsute isn't 
supported (yet), but I'd appreciate a pointer or two if possible.


I added the apt repo for Groovy (as there's none for Hirsute) to my 
/etc/apt/sources.list.d, and did:


   sudo apt update
   sudo apt install pgadmin4-server

All seemed to go OK with the installation. On trying to start it, I get 
the "Waiting for pgAdmin 4 to start..." dialog, which eventually times 
out with "The pgAdmin4 server could not be contacted". The runtime 
environment info given in the error dialog is appended below.


I have the python-is-python3 package installed, which maps the "python" 
command to python3. The python version installed is 3.9.4. The 
pgadmin4-desktop and pgadmin4-server packages are installed


I could run pgAdmin from a docker image; but then (I presume?) I'd have 
to access it from a browser window... I will if I have to, but I'd 
prefer to use the self-contained application window.


Thanks in advance for any pointers.

Ray.


pgAdmin Runtime Environment

Python Path: "/usr/pgadmin4/venv/bin/python3"
Runtime Config File: "/home/rod/.config/pgadmin/runtime_config.json"
pgAdmin Config File: "/usr/pgadmin4/web/config.py"
Webapp Path: "/usr/pgadmin4/web/pgAdmin4.py"
pgAdmin Command: "/usr/pgadmin4/venv/bin/python3 -s 
/usr/pgadmin4/web/pgAdmin4.py"

Environment:
  - LANGUAGE: en_IE:en
  - USER: rod
  - PAM_KWALLET5_LOGIN: /run/user/1000/kwallet5.socket
  - XDG_SEAT: seat0
  - XDG_SESSION_TYPE: x11
  - SSH_AGENT_PID: 1153
  - SHLVL: 0
  - HOME: /home/rod
  - DESKTOP_SESSION: plasma
  - XDG_SEAT_PATH: /org/freedesktop/DisplayManager/Seat0
  - DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus
  - LOGNAME: rod
  - XDG_SESSION_CLASS: user
  - XDG_SESSION_ID: 3
  - PATH: 
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin

  - XDG_SESSION_PATH: /org/freedesktop/DisplayManager/Session1
  - XDG_RUNTIME_DIR: /run/user/1000
  - DISPLAY: :0
  - LANG: en_IE.UTF-8
  - XDG_CURRENT_DESKTOP: KDE
  - XDG_SESSION_DESKTOP: KDE
  - XAUTHORITY: /home/rod/.Xauthority
  - SSH_AUTH_SOCK: /tmp/ssh-HDY6xIceY9TG/agent.1039
  - SHELL: /bin/bash
  - QT_ACCESSIBILITY: 1
  - GPG_AGENT_INFO: /run/user/1000/gnupg/S.gpg-agent:0:1
  - XDG_VTNR: 1
  - PWD: /home/rod
  - XDG_CONFIG_DIRS: 
/etc/xdg/xdg-plasma:/etc/xdg:/usr/share/kubuntu-default-settings/kf5-settings
  - XDG_DATA_DIRS: 
/usr/share/plasma:/usr/local/share:/usr/share:/var/lib/snapd/desktop

  - XCURSOR_THEME: breeze_cursors
  - XCURSOR_SIZE: 24
  - QT_AUTO_SCREEN_SCALE_FACTOR: 0
  - KDE_FULL_SESSION: true
  - KDE_SESSION_VERSION: 5
  - KDE_SESSION_UID: 1000
  - KDE_APPLICATIONS_AS_SCOPE: 1
  - GTK_RC_FILES: /etc/gtk/gtkrc:/home/rod/.gtkrc:/home/rod/.config/gtkrc
  - GTK2_RC_FILES: 
/etc/gtk-2.0/gtkrc:/home/rod/.gtkrc-2.0:/home/rod/.config/gtkrc-2.0
  - SESSION_MANAGER: 
local/novaray:@/tmp/.ICE-unix/1316,unix/novaray:/tmp/.ICE-unix/1316

  - GDK_BACKEND: x11
  - NO_AT_BRIDGE: 1
  - PGADMIN_INT_PORT: 45797
  - PGADMIN_INT_KEY: caf0f743-c156-4960-80a0-ff395dee49b4
  - PGADMIN_SERVER_MODE: OFF


Failed to launch pgAdmin4. Error:
Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT



--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: PgAdmin 4 V5.0

[Ray O'Donnell]

On 06/03/2021 21:14, Paulo Toledo wrote:

Hello,
I write only to thank the excellent work you have done in pgAdmin v5.0 4.
Everyone is to be congratulated.


Amen to this! I particularly like the fact that it's no longer confined 
to the browser. Well done Dave and all the team!


Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Query issue

[Ray O'Donnell]

On 27/02/2021 13:32, Sachin Kumar wrote:

Hi Team,

Please help me out in running DESCRIBE TABLE in pgadmin 5.0,  which is 
being used in psql with \d 


I don't think you can run the backslash-commands in the query window in 
pgAdmin. Instead, just click on a table and look at the information 
given in the various tabs - all the data returned by \d (and lots more) 
is there.


Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: AW: i need help

[Ray O'Donnell]

On 11/02/2021 16:22, Ralf Bezzenberger wrote:

I am on localhost and I don't find postgresql.conf.


Please send your replies to the list - "Reply-all" will do this.

I haven't used Windows in a long time, so I don't know where to look for 
postgresql.conf... others here will be able to advise.



Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: i need help

[Ray O'Donnell]

On 11/02/2021 15:53, Ralf Bezzenberger wrote:

Hallo,

I am using pgAdmin 4.30 and have the following problem:

I had a server running and then removed it. When trying to add a new 
server with the same name I get the message that localhost:5432 cannot 
be connected (see Attachment).


Using netstat tell me there is no process on that port.


Is the PostgreSQL server on localhost or on a remote machine?

If it's localhost, check the port which it's listening on - it might be 
something other than 5432. You should find this in postgresql.conf.


Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: pgAdmin4 won't start after OS upgrade

[Ray O'Donnell]

On 02/09/2020 08:50, Dave Page wrote:
> 
> 
> On Tue, Sep 1, 2020 at 5:28 PM Ray O'Donnell  <mailto:r...@rodonnell.ie>> wrote:



> One thing caught my eye: the Python path in the above output includes
> both Python 3.5 and 3.7 stuff... Any thoughts?
> 
> 
> Hmm, yeah - looks like you may have a Python installation in
> /home/rod/.local/lib/python3.5 that got into the path?
> 
> Try temporarily moving it out of the way and see if that helps. Also,
> check in ~/.config/pgadmin/pgadmin4.conf to see if there's a PythonPath
> key that's confusing things.

That sorted it! I renamed /home/rod/.local/lib/python3.5, and pgAdmin
was then able to start.

I looked into  ~/.config/pgadmin/pgadmin4.conf as you suggested, and
there is indeed a PythonPath line:

PythonPath="/home/rod/.local/lib/python3.5;/home/rod/.local/lib/python3.5/site-packages"

Can I safely delete this line?

I think the Python 3.5 installation is cruft from historical
installations of pgAdmin4, before the deb packages became available...
I'll leave it there for the moment, and if nothing else breaks I'll
eventually delete it.

Thanks a million for your help!

Ray.


-- 
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: pgAdmin4 won't start after OS upgrade

[Ray O'Donnell]

On 01/09/2020 17:07, Dave Page wrote:
> 
> 
> On Tue, Sep 1, 2020 at 5:03 PM Ray O'Donnell  <mailto:r...@rodonnell.ie>> wrote:
> 
> Hi Dave,
> 
> Thanks for responding so quickly. I should have been clearer - I did
> that before the OS upgrade, going for the big-bang approach to the
> upgrade (yes, I know that that's living dangerously!), so my current
> installation is from the buster repo. I assumed that the pgAdmin and
> Python libraries would have been upgraded along with everything else
> when I did the OS upgrade - was I wrong?
> 
> 
> I don't know if dist-upgrade would have dealt with pgAdmin as well or
> not. It's possible there's some dependency or other missing now though I
> guess, so it probably wouldn't hurt to uninstall and then reinstall the
> packages.
> 
> If that doesn't work, try running the pgAdmin binary from the command
> line and see if it complains about anything that's missing.

I removed (dpkg --purge) the packages, and reinstalled them:

rod@rambo:~$ sudo apt install pgadmin4-server pgadmin4-desktop
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
  pgadmin4-desktop pgadmin4-server
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 67.8 MB of archives.
After this operation, 0 B of additional disk space will be used.
Get:1 https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/buster
pgadmin4/main amd64 pgadmin4-server amd64 4.25 [67.4 MB]
Get:2 https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/buster
pgadmin4/main amd64 pgadmin4-desktop amd64 4.25 [384 kB]

Fetched 67.8 MB in 15s (4,554 kB/s)


Selecting previously unselected package pgadmin4-server.
(Reading database ... 476665 files and directories currently installed.)
Preparing to unpack .../pgadmin4-server_4.25_amd64.deb ...
Unpacking pgadmin4-server (4.25) ...
Selecting previously unselected package pgadmin4-desktop.
Preparing to unpack .../pgadmin4-desktop_4.25_amd64.deb ...
Unpacking pgadmin4-desktop (4.25) ...
Setting up pgadmin4-server (4.25) ...
Setting up pgadmin4-desktop (4.25) ...
Processing triggers for mime-support (3.62) ...
Processing triggers for desktop-file-utils (0.23-4) ...

I then tried running it from the command line as you suggested:

rod@rambo:~$ cd /usr/pgadmin4/bin/
rod@rambo:/usr/pgadmin4/bin$ ls -l
total 600
-rwxr-xr-x 1 root root 613792 Aug 18 13:54 pgadmin4
rod@rambo:/usr/pgadmin4/bin$ ./pgadmin4
QCoreApplication::applicationFilePath: Please instantiate the
QApplication object first
QCoreApplication::applicationFilePath: Please instantiate the
QApplication object first
Semaphore name: "pgadmin4-rod-ee77a0244675220dc7dad994b4311b50-sema"
Shared memory segment name:
"pgadmin4-rod-ee77a0244675220dc7dad994b4311b50-shmem"
Python path:
"/home/rod/.local/lib/python3.5/site-packages:/usr/pgadmin4/venv/lib/python3.7:/usr/lib/python3.7/lib-dynload:/usr/pgadmin4/venv/lib/python3.7/site-packages:/home/rod/.local/lib/python3.5"

Python Home:  "/usr/pgadmin4/venv"
Webapp path:  "/usr/pgadmin4/web/pgAdmin4.py"
"Failed to launch the application server, server thread exiting."

One thing caught my eye: the Python path in the above output includes
both Python 3.5 and 3.7 stuff... Any thoughts?

Thanks,

Ray.



-- 
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: pgAdmin4 won't start after OS upgrade

[Ray O'Donnell]

On 01/09/2020 16:58, Dave Page wrote:
> Hi
> 
> On Tue, Sep 1, 2020 at 4:33 PM Ray O'Donnell  <mailto:r...@rodonnell.ie>> wrote:
> 
> Hi all,
> 
> I upgraded my laptop yesterday from Debian 9 to 10 (Buster), and now
> pgAdmin4 won't start. It tries to start for a while, and then I get a
> little dialog saying "An error occurred initialising the pgAdmin server:
> Failed to launch the application server, server thread exiting."



> 
> 
> Probably due to the library differences in stretch vs. buster. 
> 
> I would remove the existing pgAdmin packages with dpkg, then
> edit /etc/apt/sources.list.d/pgadmin4.list and correct the URL (change
> stretch to buster). Then do an apt get update before installing pgAdmin
> again.

Hi Dave,

Thanks for responding so quickly. I should have been clearer - I did
that before the OS upgrade, going for the big-bang approach to the
upgrade (yes, I know that that's living dangerously!), so my current
installation is from the buster repo. I assumed that the pgAdmin and
Python libraries would have been upgraded along with everything else
when I did the OS upgrade - was I wrong?

Ray.

-- 
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

pgAdmin4 won't start after OS upgrade

[Ray O'Donnell]

Hi all,

I upgraded my laptop yesterday from Debian 9 to 10 (Buster), and now
pgAdmin4 won't start. It tries to start for a while, and then I get a
little dialog saying "An error occurred initialising the pgAdmin server:
Failed to launch the application server, server thread exiting."

I have the pgadmin4-server, pgadmin4-desktop and pgadmin4-doc packages
installed, version 4.25, all installed via apt from the pgAdmin repo.
Removing and reinstalling them makes no difference. I have also deleted
the settings database at ~/.pgadmin/pgadmin4.db, but no difference. The
log file at ~/.pgadmin/pgadmin4.log is empty.

Where else should I be looking? I know nothing about Python, so I don't
know where to start.

Thanks in advance - any help will be greatly appreciated.

Ray.

-- 
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: help

[Ray O'Donnell]

On 17/01/2020 10:00, Kaab Rustam wrote:
> What platform?
> MacOS Catalina 10.15.3 Beta (19D62e)
> 
> - How did you install PostgreSQL?
> 
> I installed it downloading Postgres from their web, and ticked pgadmin 4
> during installation
> 
> - Are you trying to connect from the same machine on which PG is
> installed, or from another machine?
> 
> 
> same machine 
> I'd also check a couple of things:
> 
> - Is PostgreSQL running? Look for PG processes:
> 
>   ps ax | grep postgres
> 
> here is the result
> (
> 
>  ps ax | grep postgres
> 
>  1587   ??  Ss     0:01.70 postgres: logger    
> 
>  1589   ??  Ss     0:00.67 postgres: checkpointer    
> 
> 11377 s002  S+     0:00.00 grep postgres)


Hi there,

Please reply to the list as well as to me - "Reply-all" should do the job.

I'm not an expert, but I'd have expected to see more processes than
that... here's what I see (Debian 9, with both 11 and 12 installed):

 717 ?Ss 0:00 /usr/lib/postgresql/12/bin/postgres -D
/var/lib/postgresql/12/main -c
config_file=/etc/postgresql/12/main/postgresql.conf
  718 ?S  0:00 /usr/lib/postgresql/11/bin/postgres -D
/var/lib/postgresql/11/main -c
config_file=/etc/postgresql/11/main/postgresql.conf
  738 ?Ss 0:00 postgres: 12/main: checkpointer
  739 ?Ss 0:00 postgres: 12/main: background writer
  740 ?Ss 0:00 postgres: 12/main: walwriter
  741 ?Ss 0:00 postgres: 12/main: autovacuum launcher
  742 ?Ss 0:00 postgres: 12/main: stats collector
  743 ?Ss 0:00 postgres: 12/main: logical replication
launcher
  745 ?Ss 0:00 postgres: 11/main: checkpointer
  746 ?Ss 0:00 postgres: 11/main: background writer
  747 ?Ss 0:00 postgres: 11/main: walwriter
  748 ?Ss 0:00 postgres: 11/main: autovacuum launcher
  749 ?Ss 0:00 postgres: 11/main: stats collector
  750 ?Ss 0:00 postgres: 11/main: logical replication
launcher
 7038 pts/1S+ 0:00 grep postgres


Ray.


-- 
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: help

[Ray O'Donnell]

On 17/01/2020 08:14, Kaab Rustam wrote:
> Dear Sir,
> I am trying to install postgresql, but it gives following error, what
> should I do? please help 
> 
> "could not connect to server: Connection refused Is the server running
> on host "localhost" (::1) and accepting TCP/IP connections on port 5433?
> could not connect to server: Connection refused Is the server running on
> host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5433?"

First off, this mailing list is for PgAdmin, not for PostgreSQL itself;
the pgsql-general list is probably more appropriate and has a wider
audience. Having said that, some more information would be helpful:

- What platform?

- How did you install PostgreSQL?

- Are you trying to connect from the same machine on which PG is
installed, or from another machine?

I'd also check a couple of things:

- Is PostgreSQL running? Look for PG processes:

  ps ax | grep postgres

- If you're connecting from a different machine, look for the
list_addresses setting in postgresql.conf; depending on how PG was
installed, it's often set to listen on localhost only.

Ray.

-- 
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Seriously? MASTER PASSWORD REQUIRED Again?!#$@!

[Ray O'Donnell]

On 18/10/2019 13:51, richard coleman wrote:
That would be just a wee more helpful if you actually *included* a 
/config_local.py/ in that directory for users to update, or better yet, 
didn't require users to make changes to config files and just kept the 
settings in the Preferences UI, as you have done with *ALL* the others 
settings a user might be interested in changing.


While I personally feel that something of a mountain is being made out 
of this particular molehill, the above idea isn't a bad one - it would 
be helpful if the packagers included a dummy or placeholder 
config.local.py, perhaps containing a few commented-out examples which 
would be a boon to non-Python people like me.


Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Thanks to the packagers

[Ray O'Donnell]

Hi all,

A quick word of thanks to whoever maintains the deb packages for 
pgAdmin, for getting the latest one out so quickly - I moaned a bit in 
the past about delays in getting them out, so now I'd like to rebalance 
things by saying thanks!


Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: pgAdmin bug

[Ray O'Donnell]

On 26/08/2019 06:32, Tony Bazeley wrote:
Apparently this issue 
<https://redmine.postgresql.org/issues/4640#change-17896> is fixed in v4.12
Anyone have any idea of how long it usually takes for version changes to 
make their way through the package management stage


Tony



On 26/8/19 4:10 am, Ray O'Donnell wrote:

Hi all,

Running pgAdmin 4.11 on Debian 9, installed via apt from the 
PostgreSQL apt repo.


On opening a query editor window and running any query at all, I get:

    not enough values to unpack (expected 5, got 4)

I'm getting this for the simplest query (select * from table_name).


Just wondering when deb packages for 4.12 might be out pgAdmin is 
virtually unusable for me at the moment because of this bug.


Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

pgAdmin bug

[Ray O'Donnell]

Hi all,

Running pgAdmin 4.11 on Debian 9, installed via apt from the PostgreSQL 
apt repo.


On opening a query editor window and running any query at all, I get:

not enough values to unpack (expected 5, got 4)

I'm getting this for the simplest query (select * from table_name).

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: save SQL in PgAdmin4

[Ray O'Donnell]

On 18/07/2019 14:43, Michael Shapiro wrote:

Then what?

On Thu, Jul 18, 2019 at 8:31 AM Ray O'Donnell <mailto:r...@rodonnell.ie>> wrote:


On 18/07/2019 14:28, Michael Shapiro wrote:
 > After selecting an object (eg a view) how do I save the SQL that
 > PgAdmin4 extracts from the server? I don't see a "SAVE" button.
 >

Hi there,

Right-click on it in the object tree (Left of screen), then select
Scripts -> (type of script required).


[Please keep replies on-list, and avoid top-posting - thanks.]

Now that you ask, that's a good question I just tried it myself 
(Scripts -> Create script), and the "Save" button is greyed out.


You can activate it by making some small edit in the generated SQL, but 
this seems like a bug.


Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: save SQL in PgAdmin4

[Ray O'Donnell]

On 18/07/2019 14:28, Michael Shapiro wrote:
After selecting an object (eg a view) how do I save the SQL that 
PgAdmin4 extracts from the server? I don't see a "SAVE" button.




Hi there,

Right-click on it in the object tree (Left of screen), then select 
Scripts -> (type of script required).


Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: rpm stuck at v4.8

[Ray O'Donnell]

Hi all,

Slightly off-topic for this thread, but related - any sign of deb 
packages for pgAdmin 4.10?


I appreciate that they're probably prepared in someone's spare time, so 
I'm not complaining - just wondering if they will be coming at some point.


Thanks,

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Request help for installation

[Ray O'Donnell]

On 09/07/2019 05:39, Renata Halim wrote:

Hi,

My name is renata and I'm a student in one of the university in 
Indonesia. Right now I'm doing my final project to get my degree. My 
subject is about making database for a company and right now I'm using 
postgreSQL but I'm facing a hard time to install it. Can you help me 
with this issue? The point is I can't set the passowrd for my database.

I'm looking forward to your reply.


Hi there,

This list is for pgAdmin, which is a management tool for PostgreSQL - 
you probably want the pgsql-general mailing list which is for PostgreSQL 
itself.


Useful information to include with your post:

- What platform? - Linux, Windows, etc?

- How did you try to install? - OS package manager, build from source?

- What have you tried so far, and what error or other messages did you get?

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: I would like the old header back

[Ray O'Donnell]

On 17/06/2019 08:34, Avin Kavish wrote:
I might me on the wrong mailing list, is this the one for the pgAdmin 
developers?


I'm not a pgAdmin developer, and perhaps someone has replied privately, 
but just in case - this list is for general queries around pgAdmin. 
There is a separate list for those who hack on pgAdmin:


  https://www.postgresql.org/list/pgadmin-hackers/

Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Feature request: press in master password dialog

[Ray O'Donnell]

Hi all,

As it say in $subject - when pgAdmin starts up and the new dialog pops 
up to ask the master password, it would be nice to be able simply to 
type it and hit , rather than having to use the mouse to click 
the appropriate button. I've created a feature request on Redmine:


https://redmine.postgresql.org/issues/4363

I've no skill at all with Python or I'd have a go at it myself.

It's a small thing, but disproportionately annoying every time!

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: pgAdmin can't create Expression Indexes

[Ray O'Donnell]

On 15 May 2019 06:59:11 Michel Feinstein  wrote:
I will...but just to add my 2 cents, it would be a lot better if you guys 
could move to Github and use their Issue system instead.


Why? - Just curious.

Ray.










On Wed, May 15, 2019 at 1:43 AM Aditya Toshniwal 
 wrote:


Hi,


On Wed, May 15, 2019 at 7:46 AM Michel Feinstein 
 wrote:


I can't find a way to create an Expression Index such as:
Yes, it's not there. You can raise a feature request here - 
https://redmine.postgresql.org/projects/pgadmin4/issues



CREATE UNIQUE INDEX idx_lower_unique
  ON your_table (lower(the_column));
Am I missing something or does pgAdmin really doesn't support it?


Best wishes,


Michel.





--

Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

Re: pgAdmin auto-starting

[Ray O'Donnell]

On 21/01/2019 09:29, Dave Page wrote:


If the desktop-mode server is auto-starting, then it will
automatically open a browser window. Normally though, the server
doesn't run automatically (don't confuse my comments with what may
happen when running in server *mode* - you always have a pgAdmin
server, but you may use that in desktop or server mode. In server
mode, auto-start is quite usual).

So the question is, why is the desktop server app auto-starting on
your system? I'm not familiar with KDE so can't really suggest why
that's happening.


Hi Dave,

Thanks for responding. I think I've figured it out A bit more 
Googling tells me that KDE automatically tries to restart programs which 
are running when you shut it down - I didn't realise it did that, as I'm 
fairly assiduous (not to say obsessive!) about shutting things down 
before turning the machine off.


Anyway, if the pgAdmin server is running, then presumably KDE is 
restarting it when I boot up, and so a window pops up.


The solution (not that it was a problem to begin with, really) was to 
add "pgadmin4" to the list of "Applications to be excluded from 
sessions" under System Settings -> Startup & Shutdown -> Desktop 
Session. The window no longer pops up on boot, and I can start it when I 
want to from the system menu.


Thanks again,

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

pgAdmin auto-starting

[Ray O'Donnell]

Hi all,

Not a problem as such, more a surprise - every time I start my laptop 
and log in, a pgAdmin window starts up too. Is this expected behaviour?


I'm using pgAdmin 4 version 3.5, running on Debian Stretch with KDE 
Plasma, installed via apt from apt.postgresql.org; pgAdmin is running in 
desktop mode.


I know that the pgAdmin server has to start in the background, and 
indeed it does because I can see the icon in the system tray; and 
everything is working fine. But is it normal for it to open a window on 
first login to the computer? There's no entry for it where the KDE docs 
say to expect:


  ~/.config/autostart
  ~/.config/plasma-workspace/env

Thanks,

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: pgAdmin 4, no GUI window appears

[Ray O'Donnell]

On 13/01/2019 15:11, George Trialonis wrote:

Hi there,

I downloaded postgreSQL which includes pgAdmin 4 but when I click on 
pgAdmin from the Start up menu of programs the Interface does not show, 
only the little elephant icon at the bottom tray, which allows for 
configuration, etc. I suppose the Interface should pop up in order to 
create a database.. I even downloaded pgAdmin 4 separately but it, too, 
behaves the same. Can you help?


What platform are you on?

I'm on Debian Stretch, and I right-click on the elephant icon in the 
system tray; this gives me a menu which includes "New pgAdmin 4 window...".


Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: Does Not start

[Ray O'Donnell]

El Mon, 19 Nov 2018 16:44:30 +0300
Vladislav Ivanov  escribió:

I have installed PostgreSQL 4.11 on my Windows 7
But the pgadmin4 is not able to contact the local server
I have seen this (look at picture)
  Please help to run programme
However PostgreSQL v.3 works well


Are you sure about those version numbers for PostgreSQL? The current 
major version of Postgres is 11 version 4 would have been current 
very many years ago. In fact, there's no version 3 or version 4 listed 
on the Postgres website:


https://www.postgresql.org/ftp/source/

Ray.

--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: could not connect to server, in order to operate pgAdmin/PostgreSQL

[Ray O'Donnell]

  
  
On 24/11/18 13:26, Malik Rumi wrote:


  
  
1. What is your operating system? It looks like Windows,
  but I'm not sure. Also what version number for the OS?
2. Look in the url. You are at 127.0.0.1. That is the same
  as localhost. But then it says 49194. Postgres uses 5432 by
  default. That's why you got that part of the error message,
  but we need a lot more detail to help you. 
3. It might be that your OS is too old to run the more
  recent versions of Postgres. I don't use Windows anymore, but
  I know you have to be at Ubuntu 18 to run PG 10 +, there's
  probably something similar in Windows. That is one of the many
  reasons why knowing your OS is important information.




  
“None
  of you has faith until he loves for his brother or his
  neighbor what he loves for himself.”

  


  
  
  
On Fri, Nov 23, 2018 at 8:31 PM Anne Marie Harm
   wrote:


  
Hello, 
  
  Unfortunately I'm unable to operate
  pgAdmin/PostgreSQL; first of all I can only install
  version 9.5 (tried versions 11, 10, and 9.6 -- but
  cannot install). When I launch pgAdmin in order to try
  to use PostgreSGL 9.5, here is the full
  text of the error message I receive (also, screenshot
  attached):
  
  
  could
not connect to server: Connection refused
(0x274D/10061) Is the server running on host
"localhost" (::1) and accepting TCP/IP connections
on port 5432? could not connect to server:
Connection refused (0x274D/10061) Is the server
running on host "localhost" (127.0.0.1) and
accepting TCP/IP connections on port 5432?

  

  


[Removed pgsql-hackers and pgsql-admin, as this question is about
pgAdmin]

In addition to what Malik has said above, you might have a mix-up
between IPv4 and IPv6 - the error message above indicates that
pgAdmin is trying to connect using IPv6.

Ray.