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