Re: Naming Object commands "Delete" is a source of user errors

On 16 July 2025 08:19:09 Darren Duncan wrote: I am finding that it is a recurring and damaging source of user error that Object/Explorer commands named "Delete" actually correspond to SQL DROP rather than SQL DELETE or TRUNCATE. Multiple times I have accidentally dropped tables when I meant t

Re: Unable to access local server

he tree-view, and if pgAdmin has saved a password then there'll be a option, "Clear saved password". Click this, and then you can re-enter the password on next connection. HTH, Ray. Please advise. On Mon, Jun 9, 2025 at 5:46 AM Ray O'Donnell wrote: You want eithe

Re: Unable to access local server

You want either "localhost" or 127.0.0.1 as the host. Ray. On 9 June 2025 09:55:19 B A wrote: Hi, I tried downloading and for host I put "local" (without quotes) and it gives this error:Unable to connect to server: [Errno 11001] getaddrinfo failed So I cannot use pgadmin on Windows PC.

Re: pgadmin4 data browsing

On 07/05/2025 02:30, Andrew Protasov wrote: Browsing of query result set using page up/page down keys is very slow and the slowest that I have seen in any sql tool. You need to user proper js widget like slickgrid for it, which has decent performance. Pgadmin3 did not have this issue at all.

Re: Server list on query tool workspace

On 07/04/2025 06:00, Aditya Toshniwal wrote: Hi Ray, You can raise a bug here - https://github.com/pgadmin-org/pgadmin4/issues Thanks Aditya - bug raised here: https://github.com/pgadmin-org/pgadmin4/issues/8636 Ray. -- Raymond O'Donnell // Galway // Ireland r...@rodonnell.ie

Re: Server list on query tool workspace

On 05/04/2025 15:20, Ray O'Donnell wrote: Hi all, A small but annoying thing - in the query tool workspace, on the "Welcome" tab, servers in the "Existing server" drop-down list seem to be ordered randomly certainly they bear no resemblance to the neat alphabe

Server list on query tool workspace

Hi all, A small but annoying thing - in the query tool workspace, on the "Welcome" tab, servers in the "Existing server" drop-down list seem to be ordered randomly certainly they bear no resemblance to the neat alphabetical list in the default workspace tree-view. This is a particular pai

Re: Mystery button

On 10/02/2025 03:17, Khushboo Vashi wrote: Hi, On Mon, Feb 10, 2025 at 1:17 AM Ray O'Donnell wrote: Hi all, I look the new look/layout introduced in pgAdmin4 v.9. However, there's one button which has me mystified - it's greyed out all the time, so I ca

Mystery button

Hi all, I look the new look/layout introduced in pgAdmin4 v.9. However, there's one button which has me mystified - it's greyed out all the time, so I can't press it to see what happens. It's in the vertical toolbar on the left, the fourth button down, and has an icon with two rectangles and

Re: Logging in error

On 05/12/2024 20:53, Dawn Fischer wrote: The program worked fine until the Final Exam for the course I am taking at UAA Anchorage. The course is GIS A458 Spatial Database Management. Full error message is attached in a word document. I can't speak for anyone else on this list, but personally

Re: Wants latest MSI file for windows

; <http://www.linkedin.com/company/zones><https://twitter.com/Zones><http://www.youtube.com/user/ZonesITSolutions><http://blog.zones.com/> *From:*Ray O'Donnell *Sent:* 04 December 2024 21:53 *To:* Maruthi Prathap ; pgadmin-support@lists.postgresql.org *Subject:* Re: Wants lates

Re: Wants latest MSI file for windows

On 04/12/2024 12:49, Maruthi Prathap wrote: Can you please provide an update on this? Have you tried here? - https://www.pgadmin.org/download/ Ray. -- Raymond O'Donnell // Galway // Ireland r...@rodonnell.ie

Re: Some databases not listed in treeview

DBs with OIDs less than equal to 16383 as system DBs. So your DB here is considered a system DB. On Fri, Nov 29, 2024 at 6:32 PM Ray O'Donnell wrote: Hi all, I've just come across a funny in pgAdmin 4 version 8.13: when I connect from my laptop to a server on the same

Some databases not listed in treeview

Hi all, I've just come across a funny in pgAdmin 4 version 8.13: when I connect from my laptop to a server on the same laptop, not all databases are listed in the tree-view on the left. The server is PostgreSQL 16.6. Connecting to the server with psql and doing \l shows me 12 databases, incl

Re: pgAdmin - Post installation question/s ?

munity apt repo - see the instructions here:   https://apt.postgresql.org HTH, Ray. Peter On Tue, 26 Nov 2024 10:43:45 +1000 Peter Richards wrote: On Mon, 25 Nov 2024 10:27:40 + Ray O'Donnell wrote: It certainly sounds like a network issue. Can you connect to the server using

Re: pgAdmin - Post installation question/s ?

On 25/11/2024 21:00, Peter Richards wrote: On Mon, 25 Nov 2024 10:27:40 + Ray O'Donnell wrote: It certainly sounds like a network issue. Can you connect to the server using psql, from the same machine as the one with pgAdmin? I spent quite a bit of time yesterday viewing document

Re: pgAdmin - Post installation question/s ?

On 24/11/2024 23:23, Peter Richards wrote: Running Kubuntu 24.04 and needing to maintain a PostGreSQL database. Wanting to use pgAdmin and possibly some Python code to maintain the database. I have downloaded and installed the APT version from https://www.pgadmin.org/download/pgadmin-4-apt/ Kee

Re: Just downloaded the installer file

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 k

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

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 ha

Re: Entity Relationship Diagrams

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 // Ga

Re: pgAdmin 8

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

Re: howto export txt

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

Re: Issues Restoring

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 a

Re: Issues Restoring

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 severa

Re: Configure my server

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

Re: Configure my server

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" c

Re: error open app

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

Re: UI freezes on closing a tab

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 - than

Re: UI freezes on closing a tab

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

UI freezes on closing a tab

ing 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

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

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

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 b

Re: Port 5432 failed password authentication failed

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 pass

Re: query tool - current_timestamp

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 tim

Re: Autofocus on master password field

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 dialo

Autofocus on master password field

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 IM

Re: Slow Scripts - Create Script

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 ta

Re: Reorder servers?

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.

Reorder servers?

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-

Re: Starting pgAdmin4 on Ubuntu 21.04

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/>.

Re: Starting pgAdmin4 on Ubuntu 21.04

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 normal

Re: pgAdmin4 on Kubuntu Hirsute

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/

Re: pgAdmin4 on Kubuntu Hirsute

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 r

pgAdmin4 on Kubuntu Hirsute

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/so

Re: PgAdmin 4 V5.0

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. -- Raymon

Re: Query issue

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 gi

Re: AW: i need help

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.

Re: i need help

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 netst

Re: pgAdmin4 won't start after OS upgrade

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? > >

Re: pgAdmin4 won't start after OS upgrade

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,

Re: pgAdmin4 won't start after OS upgrade

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

pgAdmin4 won't start after OS upgrade

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 p

Re: help

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

Re: help

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 54

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

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 ha

Thanks to the packagers

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..

Re: pgAdmin bug

: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 quer

pgAdmin bug

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. -- Ra

Re: save SQL in PgAdmin4

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 > PgAdmi

Re: save SQL in PgAdmin4

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). R

Re: rpm stuck at v4.8

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 // Galw

Re: Request help for installation

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 ins

Re: I would like the old header back

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 th

Feature request: press in master password dialog

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://re

Re: pgAdmin can't create Expression Indexes

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

Re: pgAdmin auto-starting

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 ser

pgAdmin auto-starting

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 d

Re: pgAdmin 4, no GUI window appears

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

Re: Does Not start

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 v

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

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 th