[pgadmin-support] Detemine name of replication schema
Title: Detemine name of replication schema I tried searching the archive for a similar question, but found none. I am interested in knowing what query can be used to determine the name of the replication schema(s) installed. As pgadmin is "aware" of the replication schema(s), as the are listed for each database eg: Casts Languages Schemas Replication I am curious as to what function or sql query is used to obtain that information? IOW, I am looking for a generic way to get the names of all replication schemas in a cluster. Thank you in advance, Melvin Davidson
[pgadmin-support] Detemine name of replication schema
Title: Detemine name of replication schema I tried searching the archive for a similar question, but found none. I am interested in knowing what query can be used to determine the name of the replication schema(s) installed. Pgadmin is "aware" of the replication schema(s), as they are listed for each database eg: Casts Languages Schemas Replication So I am curious as to what function or sql query is used to obtain that information? IOW, I am looking for a generic way to get the names of all replication schemas in a cluster. Thank you in advance, Melvin Davidson
Re: [pgadmin-support] Detemine name of replication schema
Title: Detemine name of replication schema Dave, Much obliged for the suggestion. Here is the query to find all slony schemas. Maybe this will be of help to others. SELECT nspname AS “Slony Schema” FROM pg_namespace nsp JOIN pg_proc pro ON pronamespace=nsp.oid AND proname = 'slonyversion' ORDER BY nspname; From: Dave Page [mailto:[EMAIL PROTECTED] Sent: Friday, July 07, 2006 10:14 PMTo: Melvin Davidson; pgadmin-support@postgresql.orgSubject: RE: [pgadmin-support] Detemine name of replication schema From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Melvin DavidsonSent: 07 July 2006 21:12To: pgadmin-support@postgresql.orgSubject: [pgadmin-support] Detemine name of replication schema I tried searching the archive for a similar question, but found none. I am interested in knowing what query can be used to determine the name of the replication schema(s) installed. Pgadmin is "aware" of the replication schema(s), as they are listed for each database eg: Casts Languages Schemas Replication So I am curious as to what function or sql query is used to obtain that information? IOW, I am looking for a generic way to get the names of all replication schemas in a cluster. The easiest way is to turn on SQL query logging in pgAdmin or the server and see what ends up in the logfile. I suspect (but am too tired to check right now) that it looks for schemas who's name starts with _, and contains one of the slony tables. Regards, Dave
Re: [pgadmin-support] How to access a table from one database to another database
>Now i am in PAO database..now i want access table 'activity' in schema 'cas' in CAS database. >How it is posible. >i have 2 servers access i.e local and mainserver. >How access table from one server to another server? Please note, these are not question that are specific to Pgadmin. You should be asking these question of [EMAIL PROTECTED]g The short answer is that Postgresql currently does not support inter database / server connectivity. However, you can accomplish what you need by using the dblink utility provided in the contrib directory of source code. ie: postgresql-8.0.6/contrib/dblink From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of VivekanandaSwamy R.Sent: Friday, July 14, 2006 7:31 AMTo: pgadmin-support@postgresql.orgSubject: [pgadmin-support] How to access a table from one database to another database Hai all, I have 2 databases namee PAO and CAS. PAO contains 3 schemas named Public,pao,sts CAS contains 4 schemas named Public,cao,sts,reports Now i am in PAO database..now i want access table 'activity' in schema 'cas' in CAS database. How it is posible. 2nd thing is... i have 2 servers access i.e local and mainserver. How access table from one server to another server? please tel me...because we need this one Thanks and regards _Vivekananda.R | Software Engineer | CGDA Program. Infinite Computer Solutions India Pvt. Ltd.|Exciting Times ... Infinite Possibilities... SEI-CMMI level 5 | ISO 9001:2000 IT SERVICES | BPO | Telecom | Finance | Healthcare | Manufacturing | Energy & Utilities | Retail & Distribution | Government Tel +91-80-4133 -2 Ext:3006 | Mobile: 9986463365Fax +91-80-513-10853 | www.infics.com USA | United Kingdom | India | China | Singapore | Malaysia |Hong Kong _ Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or the entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at [EMAIL PROTECTED] and delete this email from your records.
Re: [pgadmin-support] pgAdmin 1.4.3 bug with delete button in win32
You just need to use position the cursor after the character and press 'Backspace' to delete it. You should not be using the "Delete" key to delete characters. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 9:47 AM To: pgadmin-support@postgresql.org Subject: [pgadmin-support] pgAdmin 1.4.3 bug with delete button in win32 I noticed one of the new features on the win32 side for pgAdmin is that when you're viewing a row and press "delete" you get a prompt to delete the row. That's a pretty cool feature, except it also triggers that prompt if you're editing a field within a row, and might be wanting to delete some characters within the field, not the whole row. I vote that should be changed. Anyone else? jl ---(end of broadcast)--- TIP 1: 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 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-support] pgAdmin 1.4.3 bug with delete button in win32
I cannot duplicate your problem either. Is it possible you are using/have a keyboard mapping utility program which has redefined the function of the delete key? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 10:20 AM To: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] pgAdmin 1.4.3 bug with delete button in win32 Dave Page wrote: >> That's a pretty cool feature, except it also triggers that prompt if >> you're editing a field within a row, and might be wanting to delete >> some characters within the field, not the whole row. > > I can't reproduce that here - it deletes the character to the right of > the cursor. Thanks for checking, Dave, but I just reproduced it again (and I've been noticing this pretty much ever since I installed 1.4.3). I'm running on WinXP SP2 with nothing else too funky going on. Can you think of anything in my configuration that might be causing this? jl ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings ---(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: [pgadmin-support] pgAdmin 1.4.3 bug with delete button in win32
OK everybody. So far we've determined this happens for some people and not for others. So how about being a little more specific on the conditions regarding the hardware in use? Run the System Information function and save the output to a file. The attach it to the report. "C:\Program Files\Common Files\Microsoft Shared\MSInfo\msinfo32.exe" Perhaps that will give the PgAdmin developers a little more to go on. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mauro Bertoli Sent: Thursday, August 03, 2006 5:15 AM To: Dave Page; George Pavlov; Selber, Heiko; [EMAIL PROTECTED]; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] pgAdmin 1.4.3 bug with delete button in win32 If can help: * Win XP SP2 with pgAdmin III 1.4.3 installed * - If I select the row and press CANC, pgAdmin ask about deleting - if I select a cell (no cursor inside) and press CANC, pgAdmin ask about deleting - if I click on a cell (cursor inside the cell) and press CANC to delete the char, pgAdmin ask about deleting Using backspace non problems. Hope this help! Mauro Chiacchiera con i tuoi amici in tempo reale! http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com ---(end of broadcast)--- TIP 1: 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 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: [pgadmin-support] Select statement doesn't work in Query tool
Gibson, Check that the schema is in the default path. eg: SHOW SEARCH_PATH; If not, either set the path to include it, or specify the schema with the table. eg: Select * from .user; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gibson Sent: Monday, August 21, 2006 1:02 AM To: pgadmin-support@postgresql.org Subject: [pgadmin-support] Select statement doesn't work in Query tool Hi, I have 1 record in the user table, but upon using the "Select * from user" statement, the statement doesn't return a single record in the query tool. Then when i use "Select * from user where membername = 'hey') where membername is a valid column and 'hey' is a valid record, i get a 'column "membername" does not exist' error which should not exist since the column "MemberName" is inside the "User" table too. Can anyone help me? -- Cheers Gibson Tang Game Programmer 179, River Valley Building #04-09 Singapore 179033 Nexgen Studio ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-support] How to access table from one database to another database
Vivekananda, 1. These question is not one for pgadmin. They are best addressed in postgres general forum. 2. Postgres does not facilitate inter-database connectivity. However, you can use the dblink utility that you will find in postgresql-8.0.3/contrib/dblink. 3. Please send any further inquiry regarding these questions to pgsql-general@postgresql.org From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of VivekanandaSwamy R.Sent: Wednesday, August 30, 2006 9:41 PMTo: [EMAIL PROTECTED]; pgadmin-support@postgresql.orgSubject: [pgadmin-support] How to access table from one database to another database Hai all, I have 2 databases namee PAO and CAS. PAO contains 3 schemas named Public,pao,sts CAS contains 4 schemas named Public,cao,sts,reports Now i am in PAO database..now i want access table 'activity' in schema 'cas' in CAS database. How it is posible. 2nd thing is... i have 2 servers access i.e local and mainserver. How access table from one server to another server? please tel me...because we need this one Thanks & Regards Vivekananda.R Ph.9986463365 Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or the entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at [EMAIL PROTECTED] and delete this email from your records.
Re: [pgadmin-support] Replication documentation
Information/documentation about slony is found at the url below. http://gborg.postgresql.org/project/slony1/genpage.php?howto_idx Slony clusters are what you create when you install slony. It is not part of postgresql. Complete information is in the documenatation. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ezequias Rodrigues da RochaSent: Thursday, September 28, 2006 6:03 AMTo: pgAdmin SupportSubject: [pgadmin-support] Replication documentation Hi list,I would like to know about replication. I need to make a replication of some tables to another server.First I would like to make a test from my workDB to my testDB (fully)After I would like to make the same work but with some tables choosen by me. Third I would like to know about "Slony cluster" what is it ? and "how I check if it is enabled on my postgresql server ?"-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Atenciosamente (Sincerely)Ezequias Rodrigues da Rocha=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorshipshttp://ezequiasrocha.blogspot.com/
Re: [pgadmin-support] question
With a custom query. :) From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MCDONNELL, JAMES PSent: Thursday, October 19, 2006 9:24 AMTo: pgadmin-support@postgresql.orgSubject: [pgadmin-support] question Hi how would I create custom report using Postgre Sql? James McDonnell Desktop Standards and Strategy Brooklyn, NY 718-312-5033 === CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information or otherwise protected by law. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Re: [pgadmin-support] About debugging trigger
In Postgresql
it's
RAISE NOTICE 'Your Message Goes Here %', value_to
_replace%_must_be_text_or_varchar;
Please note, this is not
a question for PgAdmin. It should go to
pgsql-general@postgresql.org
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael
SuSent: Tuesday, November 07, 2006 11:59 AMTo:
pgadmin-support@postgresql.orgSubject: [pgadmin-support] About
debugging trigger
Hi,I have a question about how to insert
standard output statement in trigger for debugging purpose. I have tried
using the following:
echo 'show debug
message' ;
echo "show debug
message" ;
print("show debug
message");
print('show debug
message');
dbms_output.put_line('show debug
message');
dbms_output.put_line("show debug
message");
However, I got the following error message:
ERROR:
syntax error at or near "echo" at character 1QUERY: echo 'show debug
message'
ERROR:
syntax error at or near "print" at character 1QUERY: print('show
debug message')
ERROR:
syntax error at or near "dbms_output" at character 1QUERY:
dbms_output.put_line("show debug message")
I know that in Oracle, the way to insert standard
output statement in trigger is using dbms_output.put_line() method, but it
doesn't seem to work in pgadmin. I have already checked the frequently
asked questions list as well as the pgAdmin documentation for a solution and I
also have tried searching Google, however I can not find a solution for it.
Please help when you get a chance! Thank you in
advance,
Michael
[pgadmin-support] Table count option
Right clicking on a table show the "count" option, which updates the Rows(counted) value in the properties window for the table. Is there an equivalent SQL command? ANALYZE table_name does not work as the equivalent.
Re: [pgadmin-support] [SQL] Grants
Look at your script. Your syntax is backward. > GRANT administradores TO ezequias; Also, you must create the administradores role _BEPORE_ you grant to it/ It should be: CREATE ROLE administradores NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE; GRANT ezequias TO administradores ; That should fix the problem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ezequias Rodrigues da Rocha Sent: Friday, December 01, 2006 7:04 AM To: imad Cc: Pgadmin-Support; pgsql-sql@postgresql.org Subject: Re: [pgadmin-support] [SQL] Grants Schema grants CREATE SCHEMA base AUTHORIZATION root; GRANT ALL ON SCHEMA base TO root; GRANT USAGE ON SCHEMA base TO administrators; Table grants GRANT ALL ON TABLE base."local" TO root; GRANT SELECT, UPDATE, INSERT ON TABLE base."local" TO administrators; Still the same problem. :( 2006/11/30, imad <[EMAIL PROTECTED]>: > You did not grant access privileges to schema. > Also GRANT administrators on the base schema as you did for the table. > > --Imad > www.EnterpriseDB.com > > > On 12/1/06, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: > > Hi list, > > > > I am having problem with grants and users on PostgreSQL. > > > > I am using pgAdmin to connect like other user to test my permissions. > > > > As the owner of the database I have criated two roles: > > > > administrators (cannot connect) > > ezequias (can connect) > > > > I give permissions to a table I have: > > GRANT SELECT, UPDATE, INSERT ON TABLE base.table1 TO administrators; > > > > > > My user: > > CREATE ROLE ezequias LOGIN > > NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE; GRANT > > administradores TO ezequias; > > > > My group > > > > When I try to access the table base.table1 with ezequias login the > > pgAdmin reports: > > (see attached image) > > > > Could someone tell me what I did wrong ? > > Ezequias > > > > > > > > ---(end of > > broadcast)--- > > TIP 5: don't forget to increase your free space map settings > > > > > > > > > -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(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: [pgadmin-support] Cannot connect to one specific postgres database on a server
I cannot tell you what is specificially wrong, but try the following: Can you telnet to that database and query? Is the postmaster running for that database? Do you get any errors returned when you try to connect via telnet? What are they? Is it possible your database is corrupted and you need to restore/rebuild? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matt Busby Sent: Monday, January 22, 2007 9:37 AM To: pgadmin-support@postgresql.org Subject: [pgadmin-support] Cannot connect to one specific postgres database on a server Hello, I am having trouble connecting to one specific database on my server. I can connect to the server via pgadmin and have pgadmin display 7 or 8 databases I have running on the server. I can successfully connect to all of the databases except one. This particular database I am trying to connect to will just cause pgadmin to hang/crash I have been using pgadmin for over 2 years to connect to this particular database that wont connect now. This just started happening a week ago and is frustrating me so bad! I have installed/reinstalled/uninstalled about every version on pgadmin with no success. I restarted postgres on the server with no success... My server is running linux, and I am using windows version of pgadmin... I WOULD REALLY APPRECIATE ANY HELP!!! THANKS SO MUCH!!! Matt Busby
Re: [pgadmin-support] Cannot connect to one specific postgres database on a server
When you say "The site that is using the database is also running fine", Do you mean users are accessing that database? If so, that check the port # you are using to connect. You might also try adding a new server connection to that database in pgadmin. postmaster is the postgresql process that is needed to access the database. Telnet to the server and do ps -ef | grep postmaster You should see something like admin 2986 1 0 Jan12 ?00:00:00 /home/pgsql/postgresql-8.0.6/bin/postmaster You will have a process for each database on a separate port. If all postmaster(s) are running, then perhaps someone or something(gremlins) :) has modified the pg_hba.conf file in the $PGDATA directory? From: Matt Busby [mailto:[EMAIL PROTECTED] Sent: Monday, January 22, 2007 12:10 PM To: Melvin Davidson Cc: pgadmin-support@postgresql.org Subject: RE: [pgadmin-support] Cannot connect to one specific postgres database on a server I can telnet to the database and query the database The site that is using the database is also running fine Not sure what postmaster is How can I check if its running? I did a google search for it, but not sure how to check it on my postgres db server I don't get any errors using telnet ... I can access the db every other way it seems, just using postgres If I restore/rebuild the db, will that cause the database to go down at all? I will try anything to get pgadmin working with the db... it makes my life SOOO much easier! Thanks very much for taking the time to help me with this issue! Much appreciated! Matt -Original Message----- From: Melvin Davidson [mailto:[EMAIL PROTECTED] Sent: Monday, January 22, 2007 2:01 PM To: Matt Busby Cc: pgadmin-support@postgresql.org Subject: RE: [pgadmin-support] Cannot connect to one specific postgres database on a server I cannot tell you what is specificially wrong, but try the following: Can you telnet to that database and query? Is the postmaster running for that database? Do you get any errors returned when you try to connect via telnet? What are they? Is it possible your database is corrupted and you need to restore/rebuild? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matt Busby Sent: Monday, January 22, 2007 9:37 AM To: pgadmin-support@postgresql.org Subject: [pgadmin-support] Cannot connect to one specific postgres database on a server Hello, I am having trouble connecting to one specific database on my server. I can connect to the server via pgadmin and have pgadmin display 7 or 8 databases I have running on the server. I can successfully connect to all of the databases except one. This particular database I am trying to connect to will just cause pgadmin to hang/crash I have been using pgadmin for over 2 years to connect to this particular database that wont connect now. This just started happening a week ago and is frustrating me so bad! I have installed/reinstalled/uninstalled about every version on pgadmin with no success. I restarted postgres on the server with no success... My server is running linux, and I am using windows version of pgadmin... I WOULD REALLY APPRECIATE ANY HELP!!! THANKS SO MUCH!!! Matt Busby
Re: [pgadmin-support] Cannot connect to one specific postgres database on a server
Yes, you are correct, but you can have multiple _clusters_ with different ports, so there would a separate postmaster for each cluster on a server/machine with a different port. Keep in mind the port for the database was not specified in the original description so it s entirely possible the unaccessible database was due to the postmaster for that port being down. BTW, we do have several servers/systems/machines running multiple postmasters on multiple ports so even of my "understanding" of postgresql is different than yours, I must be doing something right. :) -Original Message- From: Andy Shellam (Mailing Lists) [mailto:[EMAIL PROTECTED] Sent: Monday, January 22, 2007 2:35 PM To: Melvin Davidson Cc: Matt Busby; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Cannot connect to one specific postgres database on a server Melvin, Your understanding of how to set up a PostgreSQL server is wrong. One server process (it was called the postmaster up to 8.1, since 8.2 it's now called the Server process) can run any number of databases, you don't need multiple postmasters for multiple databases or your server is going to die quickly when you start adding more and more databases, not to mention the admin overhead of managing all the ports, and handling backups. Using PgAdmin you connect to a particular server, connecting to the "postgres" database by default, then once you're connected to a PostgreSQL server, you choose which database/s to connect to. Melvin Davidson wrote: > When you say "The site that is using the database is also running > fine", Do you mean users are accessing that database? If so, that > check the port # you are using to connect. This should be 5432 unless specifically changed during the build. > You might also try adding a new server connection to that database in > pgadmin. If the OP can connect to one database, he should be able to connect to another on the same server. > postmaster is the postgresql process that is needed to access the > database. > Telnet to the server and do > ps -ef | grep postmaster > You should see something like > admin 2986 1 0 Jan12 ? 00:00:00 > /home/pgsql/postgresql-8.0.6/bin/postmaster There are various processes for PostgreSQL, such as the auto-vacuum, stats-gatherer and background writer processes. > You will have a process for each database on a separate port. No - if yours is set up this way, your server is going to be unnecessarily overloaded. One PostgreSQL postmaster/server process can run any number of databases on one port. It's only advisable to run more than one PostgreSQL server process on different ports if you want to run two different versions of PostgreSQL, or want to dump one set of databases to a different server (popular during a major version upgrade.) > If all postmaster(s) are running, then perhaps someone or > something(gremlins) :) has modified the pg_hba.conf file in the > $PGDATA directory? If the OP can connect to one database on the same server, there's no reason (aside from data corruption) why he shouldn't be able to connect to the required one, especially if nothing has changed - he'd get an "no pg_hba.conf entry for if the pg_hba.conf file was mis-configured. I'd advise the OP to either turn on debug logging in PgAdmin and re-create the crash, or dump the database from the server, restore as a different database on the same machine and try to connect to it again. Matt, if you follow this method, it won't take the database down as long as you restore the dump to a different database name. If it works, I'd then advise to dump the original database again, drop it and re-create it. That will take it down for as long as the dump takes place. Hope this helps! Andy. > ------ > -- > *From:* Matt Busby [mailto:[EMAIL PROTECTED] > *Sent:* Monday, January 22, 2007 12:10 PM > *To:* Melvin Davidson > *Cc:* pgadmin-support@postgresql.org > *Subject:* RE: [pgadmin-support] Cannot connect to one specific > postgres database on a server > > I can telnet to the database and query the database The site that is > using the database is also running fine > > Not sure what postmaster is How can I check if its running? I did a > google search for it, but not sure how to check it on my postgres db > server > > I don't get any errors using telnet ... I can access the db every other > way it seems, just using postgres > > If I restore/rebuild the db, will that cause the database to go down > at all? I will try anything to get pgadmin working with the db... it > makes my life SOOO much easier! > > Thanks very much for taking the time to help me with this issue! Much > appreciated! > > Matt > ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-support] Cannot connect to one specific postgres database on a server
If you can query the database with telnet, than the postmaster has to be running. The next step is to check pg_hba.conf on that server and insure that your computers ip addess is listed as a trusted connection. eg: a line similar to hostall all 765.432.111.0 255.255.255.0 trust ^ replace with your ip address If nothing else works, I would delete that server connectrion it pgadmin and just re-add it again. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matt Busby Sent: Monday, January 22, 2007 12:10 PM To: Melvin Davidson Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Cannot connect to one specific postgres database on a server I can telnet to the database and query the database The site that is using the database is also running fine Not sure what postmaster is How can I check if its running? I did a google search for it, but not sure how to check it on my postgres db server I don't get any errors using telnet ... I can access the db every other way it seems, just using postgres If I restore/rebuild the db, will that cause the database to go down at all? I will try anything to get pgadmin working with the db... it makes my life SOOO much easier! Thanks very much for taking the time to help me with this issue! Much appreciated! Matt -Original Message- From: Melvin Davidson [mailto:[EMAIL PROTECTED] Sent: Monday, January 22, 2007 2:01 PM To: Matt Busby Cc: pgadmin-support@postgresql.org Subject: RE: [pgadmin-support] Cannot connect to one specific postgres database on a server I cannot tell you what is specificially wrong, but try the following: Can you telnet to that database and query? Is the postmaster running for that database? Do you get any errors returned when you try to connect via telnet? What are they? Is it possible your database is corrupted and you need to restore/rebuild? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matt Busby Sent: Monday, January 22, 2007 9:37 AM To: pgadmin-support@postgresql.org Subject: [pgadmin-support] Cannot connect to one specific postgres database on a server Hello, I am having trouble connecting to one specific database on my server. I can connect to the server via pgadmin and have pgadmin display 7 or 8 databases I have running on the server. I can successfully connect to all of the databases except one. This particular database I am trying to connect to will just cause pgadmin to hang/crash I have been using pgadmin for over 2 years to connect to this particular database that wont connect now. This just started happening a week ago and is frustrating me so bad! I have installed/reinstalled/uninstalled about every version on pgadmin with no success. I restarted postgres on the server with no success... My server is running linux, and I am using windows version of pgadmin... I WOULD REALLY APPRECIATE ANY HELP!!! THANKS SO MUCH!!! Matt Busby
Re: [pgadmin-support] Server order
Unfortunately, it is currently not that easy because that information is stored in the Windows registry. I think it would be a nice enhancement if it were stored in a small local PostgreSQL database table, (suggestion - PgAdminDB), but I guess that is something that may be considered for a future enhancement. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, May 22, 2007 2:05 PM To: pgadmin-support@postgresql.org Subject: [pgadmin-support] Server order Is there a way to change the order of the servers in the Servers list? It'd be nice if they were alphabetically sorted.
Re: [pgadmin-support] Server order
Hmmm! I agree with you. It would make absolutely no sense to have a PostgreSQL database when you just need to administer them? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mario Splivalo Sent: Tuesday, May 22, 2007 3:09 PM To: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Server order Melvin Davidson wrote: > Unfortunately, it is currently not that easy because that information > is stored in the Windows registry. > > I think it would be a nice enhancement if it were stored in a small > local PostgreSQL database table, (suggestion - PgAdminDB), but I guess > that is something that may be considered for a future enhancement. Which would make you to have locally installed postgres if you want to use PgAdmin? Please, don't do so! :) A file in user's home directory, .pgadmin or something should be sufficient. Mike ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-support] Feature Request -Show NULL
You can do that now with a little code as follows: SELECT column1, column2, CASE WHEN maybe_null_column IS NULL THEN 'NULL' ELSE maybe_null_column END FROM your_table; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ketema Harris Sent: Thursday, May 24, 2007 12:42 PM To: Pgadmin Support Subject: [pgadmin-support] Feature Request I was wondering if were possible in a future release of pgadmin, to display 'null' in all query result panes where its an actual null value instead of just a blank, because it is indistinguishable from an empty string at this time. Thanks. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ---(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: [pgadmin-support] Feature Request - Show Null
Here's another, quicker way to do it. SELECT column1, column2, COALESCE(maybe_null_column, 'NULL') FROM your_table; Note: If maybe_null_column is not a character data type, then you need to coerce it. ie: maybe_null_column::text ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-support] pg_dump: Exclude multiple tables in version 7.4
>I knw that I have to use include instead of excluding the tables.Do I
have to include each and
>>every tables manually or is there way to do that?
There's no guarantee. but the following query might be a
good starting point to build your include list.
It selects only tables with less than 3000 tuples
(naturally you will change the value to suit your needs.
Note that per the documenatation:
"This is only an estimate used by the planner.
It is updated by VACUUM, ANALYZE,
and a few DDL commands such as CREATE INDEX."
So a FULL VACUUM is advised before executing.
SELECT n.nspname || ' .' || c.relname AS tablename
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace
WHERE c.relkind = 'r'::"char"
AND reltuples < 3000
ORDER BY n.nspname;
Melvin Davidson
Database Developer
Computer & Communication Technologies, Inc.
6 Inverness Court East, Suite 220
Englewood, CO 80112
BEGIN:VCARD
VERSION:2.1
N:Davidson;Melvin
FN:Melvin Davidson
ORG:CCT
TEL;WORK;VOICE:303-708-9228x305
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;6 Inverness Ct East=0D=0ASuite 220;Englewood;CO;80112;United States
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:6 Inverness Ct East=0D=0ASuite 220=0D=0AEnglewood, CO 80112=0D=0AUnited Stat=
es
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20060518T221645Z
END:VCARD
---(end of broadcast)---
TIP 1: 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: [pgadmin-support] PROBLEM
That is an old version of PostgreSQL. "intended for testing puposes only" means just that. It is a Beta release. It is not intended/advised for a production environment. If you want the latest release, you should use 8.2.5. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Arley Daza Sent: Monday, October 01, 2007 2:34 PM To: pgadmin-support@postgresql.org Subject: [pgadmin-support] PROBLEM What is the meaning of this on the install PostgreSQL v7.5?: This is a pre-release version of PostgreSQL, intented for testing purposes only. Use at your own risk! Thanks for its quick answer, -- Arley Daza Ortega [EMAIL PROTECTED] Bogotá - Colombia
[pgadmin-support] Fedora Core 8.0 status?
Can anyone tell me when pgAdmin III v1.8.0 will be available for Fedora Core 8 ? TIA, Melvin Davidson Home 720-870-9595 Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Folk Alley - All Folk - 24 Hours a day www.folkalley.com - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
[pgadmin-support] Count not updated with VACUUM ANALYZE
PgAdmin III 1.8.2 I have statistics enabled on my server. However, when I do a VACUUM ANALYZE on my database, the count [ Rows (counted) ] is set to "not counted". Now I can right click on the individual tables and select "Count" to manually update it, but shouldn't the VACUUM have done that? Also, is there an documented (or undocumented) function I can run to manually update the counts. Thanks in advance, Melvin Davidson
[pgadmin-support] Count not updated with VACUUM ANALYZE
I have statistics enabled on my server. However, when I do a VACUUM ANALYZE on my database, the count [ Rows (counted) ] is set to "not counted". Now I can right click on the individual tables and select "Count" to manually update it, but shouldn't the VACUUM have done that? Also, is there an documented (or undocumented) function I can run to manually update the counts. Thanks in advance, Melvin Davidson
Re: [pgadmin-support] Database structure and relation viewer/editor
Try DbDesigner 4 by FabForce http://fabforce.net/dbdesigner4/ It's a bit kludgy, but it's free and can do reverse engineering. You will need the PostgreSQL ODBC driver to use it. By default, it selects all schemas and tables to reverse engineer, so make sure you uncheck the ones you don't want (pg_catalog & information_schema) and just leave one database and related schemas. good luck, Melvin Davidson -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, March 31, 2008 8:45 AM To: pgadmin-support@postgresql.org Subject: [pgadmin-support] Database structure and relation viewer/editor Dear PostgreSQL support, I couldn't find any free tool or way to graphically view and or edit my PostgreSQL database structure (tables and relations) like the tool available in MS Access. Does this exist ? If yes, How to proceed ? PS.: I am using PostgreSQL under Suze Linux 10.2 and use pgAdminIII to manage it (but pgAdminIII apparently doesn't offer any graphical view of the database structure). Thanks in adavnace for your help Best Regards Cédric -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: Re [pgadmin-support] pgadmin datatype
Hello Abhi, It seems to me that a datatype of real[] would be appropriate. Alternative syntax is real ARRAY[3] http://www.postgresql.org/docs/8.2/interactive/arrays.html#AEN5738 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of leoabhi Sent: Monday, April 07, 2008 3:33 AM To: pgadmin-support@postgresql.org Subject: Re [pgadmin-support] pgadmin datatype Hallo, I want to make a column which will store (x,y,z) cordinates Eg(2.12 , -3.00012 , 5.2132) Is there any inbuilt datatype for Pgadmin III?? Please reply with your suggestions thanks Abhi -- View this message in context: http://www.nabble.com/Re-pgadmin-datatype-tp16536685p16536685.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Is Changing database Name possible ?
Abhi, 1st., the word is Hello, not Hallo! Next, PgAdmin does allow you to change the name, but you cannot have a current connection to that same database. Steps to do this. 1. Right click the Databases branch and select refresh. 2. Click on database postgres and then open a Query window. 3. ALTER DATABASE " " RENAME TO ; Note that the Old Name MUST BE enclosed in quotes. From: [EMAIL PROTECTED] [EMAIL PROTECTED] On Behalf Of leoabhi [EMAIL PROTECTED] Sent: Tuesday, April 08, 2008 6:30 AM To: pgadmin-support@postgresql.org Subject: [pgadmin-support] Is Changing database Name possible ? Hallo, Thanks for your reply. It helped and worked. I tried to change the name of Database to small letters, but Pgadmin doesnt allow me to do so or i failed to figure it out ? Any suggestions how i can replace my existing database with a new name ? thanks Rgrds, Abhi Melvin Davidson-3 wrote: > > Hello Abhi, > > It seems to me that a datatype of real[] would be appropriate. > Alternative syntax is real ARRAY[3] > > http://www.postgresql.org/docs/8.2/interactive/arrays.html#AEN5738 > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of leoabhi > Sent: Monday, April 07, 2008 3:33 AM > To: pgadmin-support@postgresql.org > Subject: Re [pgadmin-support] pgadmin datatype > > > Hallo, > > I want to make a column which will store (x,y,z) cordinates > Eg(2.12 , -3.00012 , 5.2132) > > Is there any inbuilt datatype for Pgadmin III?? > > Please reply with your suggestions > thanks > > > Abhi > > > > -- > View this message in context: > http://www.nabble.com/Re-pgadmin-datatype-tp16536685p16536685.html > Sent from the PostgreSQL - pgadmin support mailing list archive at > Nabble.com. > > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support > > -- View this message in context: http://www.nabble.com/Re-pgadmin-datatype-tp16536685p16558111.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
[pgadmin-support] Bug report / feature enhancement
I am using pgAdmin 1.10.0, however neither the version nor the O/S relevant. Up until, and including the current version, pgAdmin expects the format for the postgresql log_filename to be 'postgresql-%Y-%m-%d_%H%M%S.log'. However, most companies I have worked for use the format 'postgresql-%d.log' or 'postgresql-%a.log', which causes pgAdmin to not be able to locate the file. How hard would it be to add an option, in the General tab, which specifies the format for the log_filename, thus making it more flexible? Melvin Davidson Folk Alley - All Folk - 24 Hours a day www.folkalley.com
[pgadmin-support] Defined Custom Colors not retained
Using PgAdmin III v 1.12.0 (Win32) When defining a Custom Color for a server connection, the definirtion is not retained. Steps to reproduce. 1. Right click on a connection, Properties... 2. Click on Colour 3. Click Define Custom Colors >> <--Also note inconsistency between Colours and Color 4. Set Red=255 Green=170 Blue=85 5. Click on "Add To Custom Colors" button 6. Click OK 7. Click OK 8. Click OK to messages about server settings 9. Close & then re-open PgAdmin 10, Repeat steps 1, 2 & 3. 11. Note the previous defined custom color has not been saved. -- Melvin Davidson PostgreSQL DBA ICSolutions.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
[pgadmin-support] Server Status Colors
PgAdmin v1.12 I noticed that while viewing the Server Status in PgAdmin, the colors change for the various processes. Where is it documented what the significance / meaning of each color is? Melvin Davidson
[pgadmin-support] Bug -PGAdmin 1.12.2
O/S - Windows XP Service Pack 3 Language - English Distribution - binary (.zip) Version you tested 1.12.2 Bug: Attempting to backup a CamelCase named database (eg: MyDataBase) fails with C:\Program Files\pgAdmin III\1.12\pg_dump.exe --host 172.26.15.104 --port 5432 --username "mdavidson" --format custom --blobs --verbose --file "C:\PostgreSQL\backups\x.backup" \"ICSPayments\" pg_dump: [archiver (db)] connection to database ""MyDataBase"" failed: FATAL: database ""MyDataBase"" does not exist pg_dump: *** aborted because of error Process returned exit code 1. Backing up a database that is all lowercase succeeds.
Re: [pgadmin-support] Bug -PGAdmin 1.12.2
>Works for me here. What are your exact steps? Steps to duplicate: 1. Right Click on a database 2. Click on Backup 3. In popup screen, specify filename. 4. Click the Objects Tab 5. Uncheck the database (1st box) 6. Specifically check two or more individual tables, but not all. 7. Click OK Poof! All tables are copied, regardles of whether they are checked or not. FYI, In further testing of the backup, selective object backup is ignored, (options tab of backup) and all objects are backed up regardless. Works for me here. What are your exact steps? --
[pgadmin-support] PgAdmin III 1.20 windows - not valid
My O/S is Windows XP Pro SP3 I just downloaded PgAdmin III v1.20.0 from http://www.postgresql.org/ftp/pgadmin3/release/v1.20.0/win32/ After installing, I get the following error when trying to run it: " (null) is not a valid Win32 application. " To reproduce: 1. download .zip 2. Open .zip and click on pgadmin3msi 3. Follow prompts to install 4. Click on link to PgAdmin III 1.20 Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Folk Alley - All Folk - 24 Hours a day www.folkalley.com
Re: [pgadmin-support] PgAdmin III 1.20 windows - not valid
Thanks. I know support for Windows XP has been officially dropped, and I do have v1.18. Still, it's a bummer that I can't use the latest/greatest version of PgAdmin. Hopefully, the Ubuntu version will be released soon. Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Paragon Corporation To: 'Melvin Davidson' ; pgadmin-support@postgresql.org Sent: Saturday, December 20, 2014 1:14 PM Subject: Re: [pgadmin-support] PgAdmin III 1.20 windows - not valid I think pgAdmin v1.20.0 was compiled with the same VS chain (2013 as I recall) as the PostgreSQL 9.4 binaries. These don't work on Windows XP. Probably should be noted somewhere on the site that Windows XP is not supported. So you have to use a lower version of pgAdmin III . Also you can't use PostgreSQL 9.4 on windows xp either. I ran into the same issue when a PostGIS user complained about the issue (wanting to run PostgreSQL 9.4 and PostGIS on windows xp ) and had to put a notice on the PostGIS windows page to that effect. Hope that helps,Regina
Re: [pgadmin-support] Create table with GUI
The Graphical _QUERY_ Builder in the SQL Editor will only allow you to create QUERIES. It cannot be used to create tables. You can also create objects in the tree view.If you right click on Databases, you can create another database.If you Click on the Plus (+) sign next to the Database in the tree view,you will see Catalogs, Extensions & Schemas.If you right click on Schemas, you can create more Schemas. Tables are created in Schemas. So right click on a schema and you will see the option to create a table. After you create a table, you can Click on the Plus (+) sign next to the Schema to see the created table. There is also a video tutorial that walks you through the whole process. How to Create a Postgres Database Using pgAdmin | EnterpriseDB | | | | | | | | | How to Create a Postgres Database Using pgAdmin | EnterpriseDBSpend 10 minutes with Gary as he walks through the basics of creating your first database using pgAdmin, the comprehensive database design and management console for Postgres databases. | | | | View on www.enterprisedb.com | Preview by Yahoo | | | | | Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: "moon...@posteo.org" To: pgadmin-support@postgresql.org Sent: Monday, December 22, 2014 5:48 AM Subject: [pgadmin-support] Create table with GUI The list language is english, correct? I am using PostGreSql9.3 on Kubuntu14.04 with pgAdmin III (release 1.18.1). I have a conected but empty databse in there. I want to create a table with the GUI (not SQL!). In the office docu of pgAdmin I miss the topic "Create a table". All descriptions and tutorials in the web describe it with SQL. I know SQL but don't want to use it for such a simple task. I don't need a GUI to use SQL. ;) The point is I don't understand the elements/items of the TreeView. I miss the documentation about it, too. There is my "database" and under it is "Schemata -> public -> tables". But Beside (on the same tree-level) my "database" is "Tablespaces". Where can I create my own tables? Maybe you can link the documentation about the description of the tree-elements? Thank you very much Christian -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Is the "x ms" info reliable?
Have you tried using the "Explain analyze" function (Shift-F7)? That's what it's for. Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: "hushthatb...@hushmail.com" To: "pgadmin-support@postgresql.org" Sent: Saturday, January 17, 2015 3:13 PM Subject: [pgadmin-support] Is the "x ms" info reliable? In the query window's bottom-right corner, after running a query, it says how long it took. It's ambiguous how exactly this is is calculated. It seems to not take into account the lag from the slow-ass SSH tunnel. Basically, I wanna know how fast the command *actually* is. Not how long it took to run and then get delivered to pgAdmin via the incredibly sluggish SSH tunnel. The actual, in-app query is run on the same machine, and should be much, much faster. Is it possible to get this "real time" rather than the "pointless time"? PS: I hate the command-line psql tool and I don't want anything to do with it.
Re: [pgadmin-support] Since I can't seem to unsubscribe to this mailing list, I might as well report a bug...
I can't really say whether it is a "known problem" or not, but I can tell you that keeping the SQL query window "open for the whole day" is definitely NOT A GOOD IDEA. Aside for the obvious case where someone else could possibly access your computer and do nasty things when you are not watching, there is also the possibility of power glitches and accidentally hitting the keystrokes . So I can only caution you to do the prudent thing and only open the SQL window when you have to do transactions/queries and close it when you are done. It really doesn't take that long to open or close. Melvin Davidson Cell 720-320-0155 Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: "hushthatb...@hushmail.com" To: "pgadmin-support@postgresql.org" Sent: Wednesday, February 11, 2015 4:03 PM Subject: [pgadmin-support] Since I can't seem to unsubscribe to this mailing list, I might as well report a bug... When working in the SQL query window in pgAdmin, keeping it open for the whole day, I sometimes notice that it will randomly tell me that I have a syntax error somewhere in it when I run it, without having changed anything. If I just click somewhere else inside the window, such as placing the marker in the end of the query, and execute it again, it will run. So without any actual changes, it runs/doesn't run. Is this known? Why does it happen? How can it be possible? And so on. (No, I cannot reliably reproduce this. I don't even know when it happens. I just know it does happen, and has happened for many versions of pgAdmin over the years.) -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Enabling debugger plugin on pgAdmin III
FWIW, I am confirming the same problem on Windows 7 Home Premium Service Pack 1PostgreSQL 9.2.10, compiled by Visual C++ build 1600, 32-bit Melvin Davidson Cell 720-320-0155 Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: M. Matt Dugan To: pgadmin-support@postgresql.org Sent: Tuesday, April 7, 2015 12:44 PM Subject: [pgadmin-support] Enabling debugger plugin on pgAdmin III Upon many attempts and hours of search on the help pages as well as the internet, I have not been successful to enable the debugger plugin on pgAdmin III on Windows 7. Here are the things I have done. 1) As suggested on C:\Program Files\PostgreSQL\9.3\doc\installation-notes.html; I edited the postgresql.conf file that was in the data directory as: shared_preload_libraries = '$libdir/plugin_debugger.dll' (I made sure to removed #) (I tried this both by editing the conf file manually and (in a separate trial) by using the GUI provided by pgAdmin. 2) I stopped and started the postgresql-x64-9.3 service (which successfully did). I restarted pgAdmin. 3) On the psql shell, I ran command 'show shared_preload_libraries' and I did see '$libdir/plugin_debugger.dll' there. 4) On the pgAdmin III, I ran the script 'CREATE EXTENSION pldbgapi;', which created the module under 'Extensions'. Which also added 22 new functions. However, I am still unable to see the debug option in the context menu (see the screenshot below) of the functions, and the 'debugging' menu under 'tools' is still inactive. My current configuration is pgAdmin III: 1.18.1, PostGRE SQL 9.3.6 windows x64. I have also tried PostGRE SQL 9.4.1 (both 32 bit and 64 bit windows versions) prior to this (which included pgAdmin III 1.20 I believe). Thanks in advance, Ps. I also tried to attach a screenshot but the email system denied it. Matt
Re: [pgadmin-support] Enabling debugger plugin on pgAdmin III
Got it working. It seems the debugger functions need to be generated in each database, not just postgres. Melvin Davidson Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: M. Matt Dugan To: Melvin Davidson Cc: "pgadmin-support@postgresql.org" ; Ashesh Vashi Sent: Wednesday, April 8, 2015 1:43 PM Subject: Re: [pgadmin-support] Enabling debugger plugin on pgAdmin III Melvin, I came to know that, the debugging feature works ONLY IF the function is in pl/pgsql language. Just pay attention to choose that when you create the function (if you are using the GUI to create the function), then you should see the debug menu (both when you right click and the top menu) when you select that function. I assumed you enabled the debugger plugin as instructed in the installation notes (as posted earlier here as well). Good luck!.. M. Matt Dugan,Developer, On Wed, Apr 8, 2015 at 12:25 PM, Melvin Davidson wrote: FWIW, I am confirming the same problem on Windows 7 Home Premium Service Pack 1PostgreSQL 9.2.10, compiled by Visual C++ build 1600, 32-bit Melvin Davidson Cell 720-320-0155 Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: M. Matt Dugan To: pgadmin-support@postgresql.org Sent: Tuesday, April 7, 2015 12:44 PM Subject: [pgadmin-support] Enabling debugger plugin on pgAdmin III Upon many attempts and hours of search on the help pages as well as the internet, I have not been successful to enable the debugger plugin on pgAdmin III on Windows 7. Here are the things I have done. 1) As suggested on C:\Program Files\PostgreSQL\9.3\doc\installation-notes.html; I edited the postgresql.conf file that was in the data directory as: shared_preload_libraries = '$libdir/plugin_debugger.dll' (I made sure to removed #) (I tried this both by editing the conf file manually and (in a separate trial) by using the GUI provided by pgAdmin. 2) I stopped and started the postgresql-x64-9.3 service (which successfully did). I restarted pgAdmin. 3) On the psql shell, I ran command 'show shared_preload_libraries' and I did see '$libdir/plugin_debugger.dll' there. 4) On the pgAdmin III, I ran the script 'CREATE EXTENSION pldbgapi;', which created the module under 'Extensions'. Which also added 22 new functions. However, I am still unable to see the debug option in the context menu (see the screenshot below) of the functions, and the 'debugging' menu under 'tools' is still inactive. My current configuration is pgAdmin III: 1.18.1, PostGRE SQL 9.3.6 windows x64. I have also tried PostGRE SQL 9.4.1 (both 32 bit and 64 bit windows versions) prior to this (which included pgAdmin III 1.20 I believe). Thanks in advance, Ps. I also tried to attach a screenshot but the email system denied it. Matt
Re: [pgadmin-support] Unable to Restor Table Named "User"
"Process returned exit code 0." Indicates No errors occurred during the restore, so I do not understand what exactly your problem is. Are there any errors in the PostgreSQL error log file with regards to your "user" table? What is the setting for log_min_messages & log_min_error_statement in postgresql.conf? Try restoring by specifying just the user table. IOW: pg_restore -t user -d yourdb your_dump_file Then see if any errors are returned. Melvin Davidson Cell 720-320-0155 Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: "Soule, Cathi (HQP)" To: "pgadmin-support@postgresql.org" Sent: Monday, June 15, 2015 1:34 PM Subject: [pgadmin-support] Unable to Restor Table Named "User" Hello, We are not able to restore a table using pgAdmin from object browser. We have been successful using backup / restore functions with 30 other tables. However, we are not able to restore one table named ‘user’. Here are details: Thank you! - pgAdmin version 1.20.0 - Windows 7, 64-bit Messages returned is as follows. Note that a successful restore had 2 additional msgs (pg_restore: processing data for table "skillc" pg_restore: setting owner and privileges for TABLE DATA skillc). Defaults were used on backup and restore. Does anyone know how to resolve? Thank you for any help! MESSAGES RETURNED FROM UNSUCCESSFUL RESTORE-- C:/Program Files/PostgreSQL/9.4/bin\pg_restore.exe --host localhost --port 5432 --username "postgres" --dbname "d27qs7oej1f23" --no-password --data-only --table \"user\" --schema xyz1 --verbose "E:\20150611 Mig32QA user4.backup" pg_restore: connecting to database for restore Process returned exit code 0. Cathi Soule cathi.so...@roberthalf.com
Re: [pgadmin-support] Unable to Restor Table Named "User"
Cathi,
If the restore command is reporting no errors "Process returned exit code 0.",
but the table exists and has no data, then it is quite probable thatA. The
backup was made when there was no data in the tableORB. The backup of the user
table was made with the
-s or -schema-only flag, which means do not back up data.
I suggest you make a copy of the user backup file and then look through the
copy to make sure that data exists there.
FYI, pg_dump does not an create error file, ALL errors are logged to the
PostgreSQL error file, which is specified by log_directory and log_filename in
postgresql.conf.
Melvin Davidson
Cell 720-320-0155
Folk Alley - All Folk - 24 Hours a day www.folkalley.com
From: "Soule, Cathi (HQP)"
To: Melvin Davidson ; "pgadmin-support@postgresql.org"
Sent: Monday, June 15, 2015 3:29 PM
Subject: RE: [pgadmin-support] Unable to Restor Table Named "User"
#yiv0723975810 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2
4;}#yiv0723975810 filtered {font-family:Courier;panose-1:2 7 4 9 2 2 5 2 4
4;}#yiv0723975810 filtered {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0
0;}#yiv0723975810 filtered {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0
0;}#yiv0723975810 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2
4;}#yiv0723975810 filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2
4;}#yiv0723975810 p.yiv0723975810MsoNormal, #yiv0723975810
li.yiv0723975810MsoNormal, #yiv0723975810 div.yiv0723975810MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv0723975810 a:link,
#yiv0723975810 span.yiv0723975810MsoHyperlink
{color:blue;text-decoration:underline;}#yiv0723975810 a:visited, #yiv0723975810
span.yiv0723975810MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv0723975810
p.yiv0723975810MsoAcetate, #yiv0723975810 li.yiv0723975810MsoAcetate,
#yiv0723975810 div.yiv0723975810MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv0723975810
p.yiv0723975810MsoNoSpacing, #yiv0723975810 li.yiv0723975810MsoNoSpacing,
#yiv0723975810 div.yiv0723975810MsoNoSpacing
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv0723975810
p.yiv0723975810MsoListParagraph, #yiv0723975810
li.yiv0723975810MsoListParagraph, #yiv0723975810
div.yiv0723975810MsoListParagraph
{margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv0723975810
p.yiv0723975810msoplaintext, #yiv0723975810 li.yiv0723975810msoplaintext,
#yiv0723975810 div.yiv0723975810msoplaintext
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0723975810
p.yiv0723975810msolistparagraph, #yiv0723975810
li.yiv0723975810msolistparagraph, #yiv0723975810
div.yiv0723975810msolistparagraph
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0723975810
p.yiv0723975810msonormal, #yiv0723975810 li.yiv0723975810msonormal,
#yiv0723975810 div.yiv0723975810msonormal
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0723975810
p.yiv0723975810msochpdefault, #yiv0723975810 li.yiv0723975810msochpdefault,
#yiv0723975810 div.yiv0723975810msochpdefault
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0723975810
span.yiv0723975810msohyperlink {}#yiv0723975810
span.yiv0723975810msohyperlinkfollowed {}#yiv0723975810
span.yiv0723975810emailstyle17 {}#yiv0723975810 span.yiv0723975810plaintextchar
{}#yiv0723975810 p.yiv0723975810msonormal1, #yiv0723975810
li.yiv0723975810msonormal1, #yiv0723975810 div.yiv0723975810msonormal1
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv0723975810
span.yiv0723975810msohyperlink1
{color:blue;text-decoration:underline;}#yiv0723975810
span.yiv0723975810msohyperlinkfollowed1
{color:purple;text-decoration:underline;}#yiv0723975810
p.yiv0723975810msoplaintext1, #yiv0723975810 li.yiv0723975810msoplaintext1,
#yiv0723975810 div.yiv0723975810msoplaintext1
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv0723975810
p.yiv0723975810msolistparagraph1, #yiv0723975810
li.yiv0723975810msolistparagraph1, #yiv0723975810
div.yiv0723975810msolistparagraph1
{margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv0723975810
span.yiv0723975810emailstyle171 {color:windowtext;}#yiv0723975810
span.yiv0723975810plaintextchar1 {}#yiv0723975810
p.yiv0723975810msochpdefault1, #yiv0723975810 li.yiv0723975810msochpdefault1,
#yiv0723975810 div.yiv0723975810msochpdefault1
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0723975810
span.yiv0723975810BalloonTextChar {}#yiv0723975810
span.yiv0723975810EmailStyle35 {color:#1F497D;}#yiv0723975810
.yiv0723975810MsoChpDefault {font-size:10.0pt;}#yiv0723975810 filtered
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv0723975810 div.yiv0723975810WordSection1
{}#yiv0723975810 filtered {}#yiv0723975810 filtered
{font-family:Wingdings;}#yiv0723975810 filtered {}#yiv0723975810 filtered
{font-family:W
Re: [pgadmin-support] save location for queries
Options Query Tool Favourites Favourites file path ? Melvin Davidson Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Joseph Montibello To: "pgadmin-support@postgresql.org" Sent: Wednesday, July 22, 2015 11:40 AM Subject: [pgadmin-support] save location for queries Hi, Is there a way to set a default path where my .sql query files should be saved and opened from? I keep all of them in a specific folder outside of the “Documents” folder and I’d like to be able to set it as a default. I tried looking in PGAdmin3 > Preferences. I looked through Info.plist within the package itself using Finder, but didn’t see anything that looked relevant. I also looked through the online documentation and did a few searches in the list archives but I couldn’t find this. I’m using pgAdminIII version 1.20.0, running on a Mac with OS X 10.10.4. Thanks for any suggestions you can provide. Take care, Joe Montibello -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Accessing SQL that has been executed behind the interface
>>How can I access the SQL that executes when I >>alter my tables... There are two ways, the first is the change to uncomment and change the value of log_statement inpostgresql.conf to ddlIE: log_statement = 'ddl' Then you must do a reload of the postgresql.conf.ddl statements will then be captured to the log. The other way is to make the changes to the table in properties.A. right click on the tableB. left click on Properties...C. Add column, constraints, etc as needed.D. Click on the SQL tab _BEFORE_ clicking the OK button, Melvin Davidson Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Wizz To: pgadmin-support@postgresql.org Sent: Tuesday, December 1, 2015 7:41 AM Subject: [pgadmin-support] Accessing SQL that has been executed behind the interface How can I access the SQL that executes when I alter my tables with the pgAdmin interface. For instance, if I add a column, without a doubt, there was a "ALTER TABLE tablename ADD COLUMN column name int;" executed in the background. How do I get to it? I need to make a bunch of changes to a database and then have those changes in the form of SQL so I can pass it on to a colleague, who will execute it on an identical database. Thank you! -- View this message in context: http://postgresql.nabble.com/Accessing-SQL-that-has-been-executed-behind-the-interface-tp5875650.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] pgAdmin v1.22.0 keeps freezing and crashing
I'm not an expert, but believe the problem is thatPgAdmin v1.22 does not play nice with any version of Windows other than Windows 10. Currently I am using with on Windows 10 with no problem. I know that is not what you want to hear, but I did want to provide you with at least my feedback. Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Regina Obe To: pgadmin-support@postgresql.org Sent: Saturday, January 23, 2016 3:49 PM Subject: [pgadmin-support] pgAdmin v1.22.0 keeps freezing and crashing I'm running Windows 7 64-bit and had recently upgraded to pgAdmin v1.22.0. It seems though that quite frequently when I run a long-running query, pgAdmin freezes. Also if for example I restart my PostgreSQL service while I am connected, pgAdmin crashes. I've since been forced to downgrade back to pgAdmin 1.20. My husband has the same issue on his computer, though could be how we have our setups configured in a similar way. I did talk to someone else who said when she was running the PostGIS shp2pgsql-gui plugin on v1.22.0 it would crash (windows 7 32-bit), so she reverted too back to v1.20 and problem went away. Thanks, Regina -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Load balancing and high availability with PostgreSQL
>From: Sunil N Shinde >To: "pgadmin-support@postgresql.org" >Sent: Tuesday, June 7, 2016 5:11 AM >Subject: [pgadmin-support] Load balancing and high availability with >PostgreSQL > >Hi, > >I need to do the setup of High availability load balancing with 02 nodes. >>Can you please help me in this regard by providing me the detailed steps to >do this setup? > > Database -- Postgresql 9.1 > OS -- >Linux 6 ? >Thanks & Regards, >Sunil N Shinde >I need to do the setup of High availability load balancing with 02 nodes. Three things. 1. This is not the mailing list for this type of question. PgAdmin is a utility for accessing PostgreSQL, it is not PostgreSQL per se. You should instead address the pgsql-gene...@postgresql.org list, but FIRST you must subscribe to that list at https://www.postgresql.org/list/ 2. These are TWO DIFFERENT items. For load balancing you will want to look at either PgBouncer http://lists.pgfoundry.org/pipermail/pgbouncer-general/2012-April/000980.html or PgPool http://www.pgpool.net/docs/latest/tutorial-en.html 3. For High availablity, you should look into Replication https://www.postgresql.org/docs/9.1/static/high-availability.html or alternatively Slony http://lists.slony.info/ or Bucardo Bucardo - Bucardo | | | | || | | | | | Bucardo - Bucardo | | | | Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Folk Alley - All Folk - 24 Hours a day www.folkalley.com
Re: [pgadmin-support] Poker Tracker 4
Bryan, pgadmin-support is not the list for this problem. You should subscribe to and address pgsql-gene...@postgresql.org. That being said, there are additional problems with your request. First, if you are having a problem, you try contacting Poker Tracker 4, since that is where an interface problem would originate. Next you should know that PostgreSQL 9.0 is an old version and support for that stopped in September 2015. You are better off installing the latest release which is 9.5.3. Finally, if you really want additional support, you need to be much more specific than "having trouble configuring it with Poker Tracker 4". What O/S are you installing on? What is the actual problem you are having? What are the specific errors you are encountering? Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Folk Alley - All Folk - 24 Hours a day www.folkalley.com CallSend SMSCall from mobileAdd to SkypeYou'll need Skype CreditFree via Skype From: Bryan Tuck To: pgadmin-support@postgresql.org Sent: Wednesday, May 18, 2016 2:44 PM Subject: [pgadmin-support] Poker Tracker 4 I have downloaded PostgreSQL 9.0, and am having trouble configuring it with Poker Tracker 4. I would appreciate any suggestions or help to make it work. Thank you.
Re: [pgadmin-support] pgAdmin 1.0-beta2 numeric(12,3) displayed as numeric(...,2) in View Data filtered
I'm pretty sure it would be more helpful if you provided:A. The structure of the table(s) involved.B. The actual query you used to retrieve the data.C. Did you run the query in PgAdmin Query Tool or psql ? Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: "Temp key: basic, via spamcop" To: pgadmin-support@postgresql.org Sent: Sunday, July 17, 2016 4:12 AM Subject: Re: [pgadmin-support] pgAdmin 1.0-beta2 numeric(12,3) displayed as numeric(...,2) in View Data filtered On 7/17/16 at 5:52 PM, Gavan Schneider wrote: And yes I did mean to say the application itself is called pgAdmin 4 >The subject pretty much says it all. Screen shot snippets enclosed for >those who work better visually. The amounts with value at the third >decimal digit (i.e., milliDollars), were displayed rounded, not >truncated, at 2 places. > >Context: >System running pgAdmin: Mac OS X El Capitan 10.11.5 SQL Server: >PostgreSQL 9.4.5 on x86_64-apple-darwin, compiled by >i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. >build 5658) (LLVM build 2336.11.00), 64-bit > >Regards >Gavan Schneider > >- PS. Is it worth considering versioning this as "4.01.0-beta2" with the implication that any future pgAdmin 5 would start with version "5.01.0-alpha1" etc. ? -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] pgadmin3 - Tables?
>...but I do not see the tables anywhere. Where might they have gone?You first >have to 1. Connect to the server/cluster2. Expand Databases3. Click on a database and expand it 4. Click on Schemas and expand it5. Click on the schema where your tables are.6. Click on Tables. Also, it would be helpful if you provided exact PgAdmin version and O/S, otherwise, we cannot tell you how to remove anything. FYI, PostgreSQL 9.6 is still Beta. You are better off using a supported release, ie: 9.5 Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Douglas Eckert To: pgadmin-support@postgresql.org Sent: Tuesday, August 9, 2016 10:29 AM Subject: [pgadmin-support] pgadmin3 - Tables? I have installed pgAdmin3 on my PC and run the msi installer file, but I do not see the tables anywhere. Where might they have gone? Also, previously I installed both PostgreSQL9.6 and pgAdmin4. Do I need to remove them? If so, how? Will PostgreSQL9.6 work with pgAdmin3? Also, my PC is a 64-bit system. Is that a problem? If so, how do I fix it? It is 10:27 AM Eastern time. I shall be here until about 11:00. Then, I am returning at around 2PM. Please contact me soon and let me know how to get back to you. Thank you sincerely, Doug Douglas EckertRed Lion PA douglaseckerti...@gmail.com (316) 461-2351
Re: [pgadmin-support] pgadmin3 - Tables?
>..what is the server/cluster?It is the instance of PostgreSQL that you have >installed.You can have multiple instances/copies of PostgreSQL on your PC, each on a separate port #. If you only have one, it is usually on port 5432. Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Douglas Eckert To: Melvin Davidson Sent: Tuesday, August 9, 2016 11:13 AM Subject: Re: [pgadmin-support] pgadmin3 - Tables? PS, what is the server/cluster? Doug Douglas Eckert, CMPE760 Sterling DriveRed Lion PA 17356douglaseckerti...@gmail.com (717) 501-4053 On Tue, Aug 9, 2016 at 11:13 AM, Douglas Eckert wrote: Melvin: Thanks. I have to leave my home for a few hours, but I shall get back to you. It looks like I shall have to remove PostgreSQL 9.6 and pgAdmin4. When I get back, I shall try to reconnect with you to figure out how to proceed. Thanks,Doug(316) 461-2351 Douglas Eckert, CMPE760 Sterling DriveRed Lion PA 17356douglaseckerti...@gmail.com (717) 501-4053 On Tue, Aug 9, 2016 at 11:05 AM, Melvin Davidson wrote: >...but I do not see the tables anywhere. Where might they have gone?You first >have to 1. Connect to the server/cluster2. Expand Databases3. Click on a database and expand it 4. Click on Schemas and expand it5. Click on the schema where your tables are.6. Click on Tables. Also, it would be helpful if you provided exact PgAdmin version and O/S, otherwise, we cannot tell you how to remove anything. FYI, PostgreSQL 9.6 is still Beta. You are better off using a supported release, ie: 9.5 Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Douglas Eckert To: pgadmin-support@postgresql.org Sent: Tuesday, August 9, 2016 10:29 AM Subject: [pgadmin-support] pgadmin3 - Tables? I have installed pgAdmin3 on my PC and run the msi installer file, but I do not see the tables anywhere. Where might they have gone? Also, previously I installed both PostgreSQL9.6 and pgAdmin4. Do I need to remove them? If so, how? Will PostgreSQL9.6 work with pgAdmin3? Also, my PC is a 64-bit system. Is that a problem? If so, how do I fix it? It is 10:27 AM Eastern time. I shall be here until about 11:00. Then, I am returning at around 2PM. Please contact me soon and let me know how to get back to you. Thank you sincerely, Doug Douglas EckertRed Lion PA douglaseckerti...@gmail.com (316) 461-2351
Re: [pgadmin-support] pgAdmin4 Maintenance gives Database does not exist
I am not pgadmin4 support, but this looks to me like the problem is your naming convention.Per PostgreSQL (and SQL) object names MUST start with a letter. https://www.postgresql.org/docs/9.6/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS So names a database with a number (even if quoted), is a no no. Try renaming the database to db815, and see if the problem still exists. Melvin Davidson Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Mark Watson To: "pgadmin-support@postgresql.org" Sent: Thursday, October 20, 2016 8:53 AM Subject: [pgadmin-support] pgAdmin4 Maintenance gives Database does not exist Hello all, This is in no way urgent, and concerns pgAdmin4 on windows 10, with postgres 9.6. When I right-click on the database, choose maintence, and run analyze, I am getting a ‘database does not exist’ error. For example, when I try to analyze database 815, I am getting the error :psql: FATAL: database ""815"" does not exist Note the datebase name has two double quotes. Could this be a configuration issue? Executine analyze in an sql window works fine. Thanks, Mark Watson
Re: [pgadmin-support] pgAdmin4 Maintenance gives Database does not exist
Mark,
Please DO NOT use CamelCase names (or UPPERCASE) in PostgreSQL. By default,
PostgreSQL will convertall names to lowercase (unless quoted). However, quoting
object names is never a good idea and CamelCase(or UPPERCASE) names are not
necessary. They are a hold over from application programming, but do not
translate well to databases.
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: Mark Watson
To: Melvin Davidson ; "pgadmin-support@postgresql.org"
Sent: Thursday, October 20, 2016 10:27 AM
Subject: RE: [pgadmin-support] pgAdmin4 Maintenance gives Database does not
exist
#yiv6783574282 #yiv6783574282 -- _filtered #yiv6783574282
{font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv6783574282
{font-family:Courier;panose-1:2 7 4 9 2 2 5 2 4 4;} _filtered #yiv6783574282
{font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv6783574282
{font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv6783574282
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv6783574282
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv6783574282
#yiv6783574282 p.yiv6783574282MsoNormal, #yiv6783574282
li.yiv6783574282MsoNormal, #yiv6783574282 div.yiv6783574282MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv6783574282 a:link,
#yiv6783574282 span.yiv6783574282MsoHyperlink
{color:blue;text-decoration:underline;}#yiv6783574282 a:visited, #yiv6783574282
span.yiv6783574282MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv6783574282
p.yiv6783574282MsoAcetate, #yiv6783574282 li.yiv6783574282MsoAcetate,
#yiv6783574282 div.yiv6783574282MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv6783574282
p.yiv6783574282MsoListParagraph, #yiv6783574282
li.yiv6783574282MsoListParagraph, #yiv6783574282
div.yiv6783574282MsoListParagraph
{margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv6783574282
p.yiv6783574282msoacetate, #yiv6783574282 li.yiv6783574282msoacetate,
#yiv6783574282 div.yiv6783574282msoacetate
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv6783574282
p.yiv6783574282msonormal, #yiv6783574282 li.yiv6783574282msonormal,
#yiv6783574282 div.yiv6783574282msonormal
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv6783574282
p.yiv6783574282msochpdefault, #yiv6783574282 li.yiv6783574282msochpdefault,
#yiv6783574282 div.yiv6783574282msochpdefault
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv6783574282
span.yiv6783574282msohyperlink {}#yiv6783574282
span.yiv6783574282msohyperlinkfollowed {}#yiv6783574282
span.yiv6783574282emailstyle17 {}#yiv6783574282
span.yiv6783574282textedebullescar {}#yiv6783574282 p.yiv6783574282msonormal1,
#yiv6783574282 li.yiv6783574282msonormal1, #yiv6783574282
div.yiv6783574282msonormal1
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv6783574282
span.yiv6783574282msohyperlink1
{color:blue;text-decoration:underline;}#yiv6783574282
span.yiv6783574282msohyperlinkfollowed1
{color:purple;text-decoration:underline;}#yiv6783574282
p.yiv6783574282msoacetate1, #yiv6783574282 li.yiv6783574282msoacetate1,
#yiv6783574282 div.yiv6783574282msoacetate1
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv6783574282
span.yiv6783574282emailstyle171 {color:windowtext;}#yiv6783574282
span.yiv6783574282textedebullescar1 {}#yiv6783574282
p.yiv6783574282msochpdefault1, #yiv6783574282 li.yiv6783574282msochpdefault1,
#yiv6783574282 div.yiv6783574282msochpdefault1
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv6783574282
span.yiv6783574282EmailStyle31 {color:#1F497D;}#yiv6783574282
span.yiv6783574282TextedebullesCar {}#yiv6783574282 .yiv6783574282MsoChpDefault
{font-size:10.0pt;} _filtered #yiv6783574282 {margin:1.0in 1.0in 1.0in
1.0in;}#yiv6783574282 div.yiv6783574282WordSection1 {}#yiv6783574282 _filtered
#yiv6783574282 {} _filtered #yiv6783574282 {} _filtered #yiv6783574282 {}
_filtered #yiv6783574282 {} _filtered #yiv6783574282 {font-family:Wingdings;}
_filtered #yiv6783574282 {font-family:Symbol;} _filtered #yiv6783574282 {}
_filtered #yiv6783574282 {font-family:Wingdings;} _filtered #yiv6783574282
{font-family:Symbol;} _filtered #yiv6783574282 {} _filtered #yiv6783574282
{font-family:Wingdings;}#yiv6783574282 ol {margin-bottom:0in;}#yiv6783574282 ul
{margin-bottom:0in;}#yiv6783574282 … But if the name of the database contains
uppercase characters, the same problem arises : psql: FATAL: database ""Dj""
does not exist - Mark De : Melvin Davidson
[mailto:melvin6...@yahoo.com]
Envoyé : Thursday, October 20, 2016 10:09 AM
À : Mark Watson; pgadmin-support@postgresql.org
Objet : Re: [pgadmin-support] pgAdmin4 Maintenance gives Databa
Re: [pgadmin-support] pgAdmin 4 v1.1 Released!
fwiw, I had the same problem as reported by Marie-Claude QUIDOZ.However, that
was only after initial installation. After closing and restarting the
program, all was working as expected. I view this as an oddity with Windows 10
O/S.
Thank you for continuing to improve the product.
Melvin Davidson
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: QUIDOZ Marie-Claude
To: pgAdmin Support
Sent: Thursday, October 27, 2016 8:36 AM
Subject: Re: [pgadmin-support] pgAdmin 4 v1.1 Released!
#yiv9086246894 #yiv9086246894 -- _filtered #yiv9086246894 {panose-1:2 4 5 3 5 4
6 3 2 4;} _filtered #yiv9086246894 {font-family:Calibri;panose-1:2 15 5 2 2 2 4
3 2 4;}#yiv9086246894 #yiv9086246894 p.yiv9086246894MsoNormal, #yiv9086246894
li.yiv9086246894MsoNormal, #yiv9086246894 div.yiv9086246894MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}#yiv9086246894 a:link,
#yiv9086246894 span.yiv9086246894MsoHyperlink
{color:#0563C1;text-decoration:underline;}#yiv9086246894 a:visited,
#yiv9086246894 span.yiv9086246894MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;}#yiv9086246894
p.yiv9086246894MsoPlainText, #yiv9086246894 li.yiv9086246894MsoPlainText,
#yiv9086246894 div.yiv9086246894MsoPlainText
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}#yiv9086246894
span.yiv9086246894TextebrutCar {}#yiv9086246894 .yiv9086246894MsoChpDefault {}
_filtered #yiv9086246894 {margin:70.85pt 70.85pt 70.85pt
70.85pt;}#yiv9086246894 div.yiv9086246894WordSection1 {}#yiv9086246894 Hello
I test for some time PGADMIN4. And I am alert you
When I make a mistake in a query (eg select count ("CD_NOM")) from taxrefv90;)
I have a bad message "Not connected to the server or the server connection has
been closed." A+ MCQ + Marie-Claude QUIDOZ CEFE / CNRS
1919, Route de Mende 34293 Montpellier Cedex 5 Tel : 04 67 61 32 39
marie-claude.qui...@cefe.cnrs.fr http://www.cefe.cnrs.fr/fr/pf/sie
-Message d'origine-
De : pgadmin-support-ow...@postgresql.org
[mailto:pgadmin-support-ow...@postgresql.org] De la part de Dave Page
Envoyé : jeudi 27 octobre 2016 13:30
À : pgadmin-hackers ; pgAdmin Support
Objet : [pgadmin-support] pgAdmin 4 v1.1 Released! The pgAdmin Development
Team are pleased to announce the release of pgAdmin 4 v1.1. This is the second
release of pgAdmin 4, and includes over 40 bug fixes and improvements. For
details, please see the issue tracker roadmap:
https://redmine.postgresql.org/versions/39 pgAdmin 4 is a complete rewrite
of pgAdmin, built using Python and Javascript/jQuery. A desktop runtime written
in C++ with Qt allows it to run standalone for individual users, or the web
application code may be deployed directly on a webserver for use by one or more
users through their web browser. The software has the look and feel of a
desktop application whatever the runtime environment is, and vastly improves on
pgAdmin III with updated user interface elements, multi-user/web deployment
options, dashboards and a more modern design. For more information, checkout
the screenshots and online documentation:
https://www.pgadmin.org/screenshots/
https://www.pgadmin.org/docs4/1.x/index.html pgAdmin 4 will be bundled with
the EDB PostgreSQL 9.6.1 installers, or can be downloaded in source, PIP wheel,
macOS or Windows packages from the pgAdmin website:
https://www.pgadmin.org/download/ Regards, Dave -- Dave Page pgAdmin
Project Lead -- Sent via pgadmin-support mailing list
(pgadmin-support@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] pgAdmin 4 v1.1 Released!
Marie-claude,
Have you tried restarting windows? It has always been a problem with Windows
O/Sthat new programs are not fully recognized until windows is restarted.
Probably has
something to do with Windows Registration.
Melvin Davidson
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: QUIDOZ Marie-Claude
To: Melvin Davidson ; pgAdmin Support
Sent: Thursday, October 27, 2016 9:53 AM
Subject: Re: [pgadmin-support] pgAdmin 4 v1.1 Released!
#yiv6984275413 #yiv6984275413 -- _filtered #yiv6984275413
{font-family:Courier;panose-1:2 7 4 9 2 2 5 2 4 4;} _filtered #yiv6984275413
{panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv6984275413
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv6984275413
{}#yiv6984275413 #yiv6984275413 p.yiv6984275413MsoNormal, #yiv6984275413
li.yiv6984275413MsoNormal, #yiv6984275413 div.yiv6984275413MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv6984275413 a:link,
#yiv6984275413 span.yiv6984275413MsoHyperlink
{color:blue;text-decoration:underline;}#yiv6984275413 a:visited, #yiv6984275413
span.yiv6984275413MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv6984275413
p.yiv6984275413msoplaintext, #yiv6984275413 li.yiv6984275413msoplaintext,
#yiv6984275413 div.yiv6984275413msoplaintext
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv6984275413
p.yiv6984275413msonormal, #yiv6984275413 li.yiv6984275413msonormal,
#yiv6984275413 div.yiv6984275413msonormal
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv6984275413
span.yiv6984275413msohyperlink {}#yiv6984275413
span.yiv6984275413msohyperlinkfollowed {}#yiv6984275413
p.yiv6984275413msonormal1, #yiv6984275413 li.yiv6984275413msonormal1,
#yiv6984275413 div.yiv6984275413msonormal1
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}#yiv6984275413
span.yiv6984275413msohyperlink1
{color:#0563C1;text-decoration:underline;}#yiv6984275413
span.yiv6984275413msohyperlinkfollowed1
{color:#954F72;text-decoration:underline;}#yiv6984275413
p.yiv6984275413msoplaintext1, #yiv6984275413 li.yiv6984275413msoplaintext1,
#yiv6984275413 div.yiv6984275413msoplaintext1
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}#yiv6984275413
span.yiv6984275413EmailStyle25
{color:#1F497D;font-weight:normal;font-style:normal;}#yiv6984275413
.yiv6984275413MsoChpDefault {font-size:10.0pt;} _filtered #yiv6984275413
{margin:70.85pt 70.85pt 70.85pt 70.85pt;}#yiv6984275413
div.yiv6984275413WordSection1 {}#yiv6984275413 Hi For my part I still have
the same problem with the new version. I am running windows 8 A+ MCQ
+ Marie-Claude QUIDOZ CEFE / CNRS 1919, Route de Mende 34293
Montpellier Cedex 5 Tel : 04 67 61 32 39 marie-claude.qui...@cefe.cnrs.fr
http://www.cefe.cnrs.fr/fr/pf/sie De : Melvin Davidson
[mailto:melvin6...@yahoo.com]
Envoyé : jeudi 27 octobre 2016 15:43
À : QUIDOZ Marie-Claude ; pgAdmin Support
Objet : Re: [pgadmin-support] pgAdmin 4 v1.1 Released! fwiw, I had the
same problem as reported by Marie-Claude QUIDOZ. However, that was only after
initial installation. After closing and restarting the
program, all was working as expected. I view this as an oddity with Windows 10
O/S.
Thank you for continuing to improve the product. Melvin Davidson
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com From: QUIDOZ Marie-Claude
To: pgAdmin Support
Sent: Thursday, October 27, 2016 8:36 AM
Subject: Re: [pgadmin-support] pgAdmin 4 v1.1 Released! Hello
I test for some time PGADMIN4. And I am alert you
When I make a mistake in a query (eg select count ("CD_NOM")) from taxrefv90;)
I have a bad message "Not connected to the server or the server connection has
been closed." A+ MCQ + Marie-Claude QUIDOZ CEFE / CNRS
1919, Route de Mende 34293 Montpellier Cedex 5 Tel : 04 67 61 32 39
marie-claude.qui...@cefe.cnrs.fr http://www.cefe.cnrs.fr/fr/pf/sie
-Message d'origine-
De : pgadmin-support-ow...@postgresql.org
[mailto:pgadmin-support-ow...@postgresql.org] De la part de Dave Page
Envoyé : jeudi 27 octobre 2016 13:30
À : pgadmin-hackers ; pgAdmin Support
Objet : [pgadmin-support] pgAdmin 4 v1.1 Released! The pgAdmin Development
Team are pleased to announce the release of pgAdmin 4 v1.1. This is the second
release of pgAdmin 4, and includes over 40 bug fixes and improvements. For
details, please see the issue tracker roadmap:
https://redmine.postgresql.org/versions/39 pgAdmin 4 is a complete rewrite of
pgAdmin, built using Python and Javascript/jQuery. A desktop runtime written in
C++
Re: [pgadmin-support] pgadmin server-status does not display
Walter, Thanks for additional details. I believe Ashesh Vashi has already given you the best advice of renaming the ~/.pgadmin3 file.Please do not reply directly to me, as I am just another user like you. All repliesshould go to pgadmin-support@postgresql.org. Melvin Davidson Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Walter Nordmann To: Melvin Davidson Sent: Wednesday, November 9, 2016 6:28 AM Subject: Re: [pgadmin-support] pgadmin server-status does not display Hi Melvin, sorry for missing details. What is the exact version of PgAdmin3? 1.22.1 , but older versions (1.18.? and higher) had the same problem. What is the O/S? ubuntu 14.04 server, 16.10 client - but 16.4 had the same problem What is the vesion of PostgreSQL you are connecting to? server 9.4.0, client 9.6.0 - but client 9.4(?) and 9.5 had the same problem What is the username specified in the connection parameters? postgres Is that user a superuser? of course. Regards walter
Re: [pgadmin-support] pgadmin server-status does not display
>deleting ~/ .pgadmin3 did not change anything. Did you restart pgadmin3 after deleting?Did you look at pgadmin3.log to see if there are any obvious related errors? Just as a wild thought, if you su as root and run pgadmin3 as root, does the problem still occur? Melvin Davidson Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Walter Nordmann To: pgadmin-support@postgresql.org Sent: Wednesday, November 9, 2016 11:12 AM Subject: Re: [pgadmin-support] pgadmin server-status does not display Hi melvin, Am 09.11.2016 um 15:11 schrieb Melvin Davidson: Walter, Thanks for additional details. I believe Ashesh Vashi has already given you the best advice of renaming the ~/.pgadmin3 file. deleting ~/ .pgadmin3 did not change anything. Please do not reply directly to me, as I am just another user like you. All replies should go to pgadmin-support@postgresql.org. sorry, my fault. hit the wrong reply button :( regards walter
Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4
The problem is, ROLLBACK requires a transaction. So to use it properly you need to start with a BEGIN statement. eg: BEGIN;your_statements;ROLLBACK; https://www.postgresql.org/docs/9.4/static/sql-begin.html https://www.postgresql.org/docs/9.4/static/sql-rollback.html fyi, in the future, it is always a good idea to include the PostgreSQL version. Melvin Davidson Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Malik Rumi To: pgAdmin Support Sent: Tuesday, November 29, 2016 1:17 PM Subject: [pgadmin-support] ROLLBACK syntax error in pgadmin4 I amusing PGAdmin4 with PG 9.4 on Ubuntu 16.04 64 bit. I wanted to do an update, but was unsureof the result, so I unselected autocommit and ran explain. It saidonly one row was affected, which I didn’t understand, because itshould have affected at least 2. Then I inferred that the ‘one row’being referred to was the plan, not the rows in my data.ThenI ran the update, again no autocommit, and it was not what Iexpected. So then I added ROLLBACK to the end of the query, ran itagain, and got this error:ERROR:syntax error at or near "ROLLBACK" LINE 1: ...de" SETchildof_id = NULL WHERE codelevelsortseq=1 ROLLBACK;Ithen did a new query, with just ROLLBACK; as I see it explained withan example in the docs:https://www.postgresql.org/docs/9.4/static/sql-rollback.htmlNevertheless,I got the same error:ERROR:syntax error at or near "ROLLBACK" LINE 1: ...F, VERBOSEON, COSTS ON, BUFFERS OFF, TIMING OFF) ROLLBACK; Note in this case ROLLBACK; is the only thing on Line 1. The error carat (^) is pointing at the R in both cases. Noother queries have been run in the interim. Tomy surprise, there are very few Google hits for this exact search: "syntaxerror at or near 'ROLLBACK'" About 30 results (0.34 seconds) Thefirst two hits are for a bug report from Nov. of 2006, which wasfixed then and there. I don’t think this is the same bug, if it isa bug. Idid find DISCARD in the docs:https://www.postgresql.org/docs/9.4/static/sql-discard.htmlhowever, I have not run it because I wanted some clarity here anddidn’t want to interfere with my ROLLBACK, if it would even havethat effect.So,my questions:1.How do I discard this update and get my data back?2.How do I check to make sure it really isn’t committed withoutupsetting my ROLLBACK options? (Yes, I do have a backup I can go to,but I would rather understand what is happening and fix it).4.If it isn’t committed, and this is a bug, can I just close PGAdmin4and/or PG and discard the changes that way?5.Is this a new, different bug?6. What was that 'one row effected' about?
Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4
Malik, First things first.1. This is not the correct forum for this problem. PgAdmin is a utility for managing PostgreSQL. You are better off re-submitting this problem to pgsql-general@postgresql.orgbut you stand a better chance if you also includeA. O/SB. Exact version of PostgreSQLC. SQL code to reproduce the problem. As for "ERROR: current transaction is aborted, commands ignored until end of transaction block"It means all commands from BEGIN; until the error occurs are rolled back. No further commandsafter the error occurs are executed. Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Malik Rumi To: Melvin Davidson Cc: pgAdmin Support Sent: Tuesday, November 29, 2016 2:50 PM Subject: Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4 Thank you. However... ERROR: current transaction is aborted, commands ignored until end of transaction block I'm not even sure what this means. Which transaction is it referring to? The rollback or the update? What is the error and how do I fix it? What is meant by "until end of transaction block"? Does that mean the entire transaction block, or that something might happen after the end of this block? I did some more googling, and found this from the postgresql list: If that's what you're getting, the problem was with an earlier command that returned an error you didn't notice, not with the command you just ran. https://www.postgresql.org/message-id/4cab085c.5030...@postnewspapers.com.au I suppose that makes sense and applies here, since I came here asking about two consecutive syntax errors in the first place. But I still don't know how to safely back out of this situation. Any further advice? Anyone? p.s. - I said I had PG 9.4. I assumed everyone would know that meant Postgresql 9.4 On Tue, Nov 29, 2016 at 10:24 AM, Melvin Davidson wrote: The problem is, ROLLBACK requires a transaction. So to use it properly you need to start with a BEGIN statement. eg: BEGIN;your_statements;ROLLBACK; https://www.postgresql.org/ docs/9.4/static/sql-begin.html https://www.postgresql.org/ docs/9.4/static/sql-rollback. html fyi, in the future, it is always a good idea to include the PostgreSQL version. Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/ videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Malik Rumi To: pgAdmin Support Sent: Tuesday, November 29, 2016 1:17 PM Subject: [pgadmin-support] ROLLBACK syntax error in pgadmin4 I amusing PGAdmin4 with PG 9.4 on Ubuntu 16.04 64 bit. I wanted to do an update, but was unsureof the result, so I unselected autocommit and ran explain. It saidonly one row was affected, which I didn’t understand, because itshould have affected at least 2. Then I inferred that the ‘one row’being referred to was the plan, not the rows in my data.ThenI ran the update, again no autocommit, and it was not what Iexpected. So then I added ROLLBACK to the end of the query, ran itagain, and got this error:ERROR:syntax error at or near "ROLLBACK" LINE 1: ...de" SETchildof_id = NULL WHERE codelevelsortseq=1 ROLLBACK;Ithen did a new query, with just ROLLBACK; as I see it explained withan example in the docs:https://www.postgresql.org/ docs/9.4/static/sql-rollback. htmlNevertheless,I got the same error:ERROR:syntax error at or near "ROLLBACK" LINE 1: ...F, VERBOSEON, COSTS ON, BUFFERS OFF, TIMING OFF) ROLLBACK; Note in this case ROLLBACK; is the only thing on Line 1. The error carat (^) is pointing at the R in both cases. Noother queries have been run in the interim. Tomy surprise, there are very few Google hits for this exact search: "syntaxerror at or near 'ROLLBACK'" About 30 results (0.34 seconds) Thefirst two hits are for a bug report from Nov. of 2006, which wasfixed then and there. I don’t think this is the same bug, if it isa bug. Idid find DISCARD in the docs:https://www.postgresql.org/ docs/9.4/static/sql-discard. htmlhowever, I have not run it because I wanted some clarity here anddidn’t want to interfere with my ROLLBACK, if it would even havethat effect.So,my questions:1.How do I discard this update and get my data back?2.How do I check to make sure it really isn’t committed withoutupsetting my ROLLBACK options? (Yes, I do have a backup I can go to,but I would rather understand what is happening and fix it).4.If it isn’t committed, and this is a bug, can I just close PGAdmin4and/or PG and discard the changes that way?5.Is this a new, different bug?6. What was that 'one row effected' about?
Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4
Malik, I was not blaming you for posting to PgAdmin, I was just trying to advise you and direct you to the proper forum. Please do not be so defensive. As to determining whether it is a PgAdmin error or a PostgreSQL error, that is pretty simple. If a "feature" of PgAdmin is not working properly, then it is a PgAdmin error. But if you get a SQL error after running a SQL query, then it has to be PostgreSQL. Yes, you did give the O/S and PostgreSQL "major" version, but the minor version of PostgreSQL can be critical in some cases, as they minor versions contain fixes for bugs that may or may not have something to do with problem you seek help for. Errors by themself may or may not be explained. That is why it is very important to include a scriptthat will duplicate the error. If you go to a doctor and tell him you have a pain, do you expect him to tell you the cause right away, or would you understand if he asks you what led up to the pain? Yes, I am a volunteer. In fact, I am a retired PostgreSQL DBA. Hopefully you will now understand thedifference between a transaction and a stand alone query. Good luck. Melvin Davidson Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Malik Rumi To: Melvin Davidson Cc: PgAdmin Support Sent: Tuesday, November 29, 2016 5:14 PM Subject: Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4 Ok, I am not trying to be difficult. I am trying to understand. If that sounds defensive, it's because of prior experience on Stack Overflow, where the "experts" tend to be snarky, IMHO. I did all of this in PGAdmin4, so that is why I posted here. How would I determine what is a PGAdmin4 issue and what is not? I did tell you my OS in the very first line of my very first post on this issue. I also told you my postgres version on that same line. When you say 'exact', do you mean 9.4.8, instead of just 9.4? True enough, I did not give you the entire SQL, but I did give you the error, which quoted what I assumed were the relevant portions of the SQL. I'm sorry if that wasn't enough. I gave you the background on what I had done to find a solution on my own. I also asked a lot of questions which I hoped would clarify my understanding of the problem, but they have not been addressed. All in all, I thought I was being pretty verbose and specific. Maybe too much so. When you put together the lack of response to my specific questions, and asking for OS and PG version info I already gave, well, it's kinda discouraging. But it's a free service, and I assume you are a volunteer with a life and issues of your own. At least you responded, and fairly soon. A lot of people don't even get that. I'm going to restart and hope for the best. I've learned that fsync is supposed to be on by default, so if the uncheck of autocommit did what it was supposed to do, I should be fine. If not, I have a backup. I just wanted to learn. On Tue, Nov 29, 2016 at 12:59 PM, Melvin Davidson wrote: Malik, First things first.1. This is not the correct forum for this problem. PgAdmin is a utility for managing PostgreSQL. You are better off re-submitting this problem to pgsql-general@postgresql.orgbut you stand a better chance if you also includeA. O/SB. Exact version of PostgreSQLC. SQL code to reproduce the problem. As for "ERROR: current transaction is aborted, commands ignored until end of transaction block"It means all commands from BEGIN; until the error occurs are rolled back. No further commandsafter the error occurs are executed. Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/ videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Malik Rumi To: Melvin Davidson Cc: pgAdmin Support Sent: Tuesday, November 29, 2016 2:50 PM Subject: Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4 Thank you. However... ERROR: current transaction is aborted, commands ignored until end of transaction block I'm not even sure what this means. Which transaction is it referring to? The rollback or the update? What is the error and how do I fix it? What is meant by "until end of transaction block"? Does that mean the entire transaction block, or that something might happen after the end of this block? I did some more googling, and found this from the postgresql list: If that's what you're getting, the problem was with an earlier command that returned an error you didn't notice, not with the command you just ran. https://www.postgresql.org/ message-id/4CAB085C.5030106@ postnewspapers.com.au I suppose that makes sense and applie
Re: [pgadmin-support] DB Creation From .dmp File
FYI, it would be helpful if you specified the exact version of Postgres and PgAdmin you are working with.Also the O/S. Is your file local or remote? If your file is remote, then you cannot use PgAdmin to restore your file.You must log on to your remote system and restore there. If your file is local, then can use PgAdmin to restore to either a local or remote database. Melvin Davidson Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Amedeo To: pgadmin-support@postgresql.org Sent: Friday, December 16, 2016 12:08 PM Subject: [pgadmin-support] DB Creation From .dmp File Hi, I have a .dmp File of 9 GigaBites that contains aerial views. I want to open the information tha contains this file with PgAdmin4. I have created a new database, then i have runned RESTORE command. PgAdmin show me the next message: <http://postgresql.nabble.com/file/n5935153/Cattura.jpg> I have created a new databese, then i have runned RESTORE command. Can someone help me? Thank You in Advance. -- View this message in context: http://postgresql.nabble.com/DB-Creation-From-dmp-File-tp5935153.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Restoring Db
Irina, I am not PgAdmin support. I am a retired DBA. I happen to agree with you that PgAdmin4 is not ready for prime time. It is slow and lacks many of the features in PgAdmin3, in addition a few of the features it does have do not work. For that reason I continue to use PgAdmin3. That being said, I have replied back to Marcin that I believe the reason his pg_restore is not working is because his dbname is CamelCase. I suggested he use the command line version of pg_restore and look in postgres log for any errors. Since then I have not heard back from him. Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Irina Mileva To: "pgadmin-support@postgresql.org" Sent: Monday, December 26, 2016 8:45 AM Subject: Re: [pgadmin-support] Restoring Db Data base restore is not working long time ago. PgAdmin 4 sounds more like a sabotage the project as well. I can support pgadmin 3 and 4 with a professional QA support. Hope someone will answer me this time. Sent with AquaMail for Android http://www.aqua-mail.com On 24 декември 2016 г. 6:30:23 Marcin Bienias wrote: > pgAdmin 3 v1.22.2 > MacOS Sierra 10.12.1 > > After instaling few time when i try to restore database i can’t do that. > I chose .tar file but i can’t use restore button. its grey and don’t work. > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] VACUUM FULL Error
Patrick, Three things.1. I am not PgAdmin support. 2. This message should actually be addressed to pgsql-gene...@postgresql.org 3. Support for version 8.1 ended November 2010 https://www.postgresql.org/support/versioning/ I suggest your best course of action is to upgrade to a recent supported version (9.5 or 9.6). In the meantime, it looks like you need to increase your shared_buffers parameter in yourpostgresql.conf and restart the postgres server. https://www.postgresql.org/message-id/4057e37d0fad0814281017dc6c211c00.squir...@sq.gransy.com Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: "Hayes, Patrick" To: "pgadmin-support@postgresql.org" Sent: Thursday, December 29, 2016 5:52 AM Subject: [pgadmin-support] VACUUM FULL Error Hi pgAdmin support, Recently truncated tables in Postgre SQL DB and now unable to free up disk space on server with the VACUUM FULL command. The DB is 1.91TBytes in size. Server is running Win 2008 R2 Standard Operating System. Postgre SQL is version 8.1 Error message reads as follows: ERROR: out of memory DETAIL: Failed on request of size 134217728. Adding memory to server does not seem to make any difference. Re-starting the server makes no difference. The VACUUM command always ends in the same record 134217728. Is there any way to selectively VACUUM tables – divide and conquer approach. Thank you in advance for any support you can provide PatrickHayes -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] [GENERAL] Queries are taking way longer in 9.6 than 9.5
Hash Cond: (os.order_status_history_id = > osh.order_status_history_id) > > > > -> Seq Scan on tblpuorderstatus os > (cost=0.00..96498.46 rows=11185486 width=8) > > -> Hash (cost=3010979.77..3010979.77 rows=529686 > width=4) > >-> Gather (cost=1000.00..3010979.77 > rows=529686 width=4) > > Workers Planned: 2 > > -> Parallel Seq Scan on > tblpuorderstatushistory osh (cost=0.00..2957011.17 rows=220702 width=4) > > > >Filter: ((cancelled_date IS NULL) > AND (cc_accept_date IS NOT NULL) AND (vip_order_type = 17)) > > > >-> Index Scan using tblcnpatientordermap_pkey on > tblcnpatientordermap po (cost=0.09..0.41 rows=1 width=8) > > > > Index Cond: (vip_order_id = os.vip_order_id) > > > > -> Nested Loop Semi Join (cost=0.17..1.02 rows=1 width=4) > >-> Index Scan using tblcndoctorpatientmap_pkey on > tblcndoctorpatientmap d (cost=0.09..0.39 rows=1 width=8) > > Index Cond: (vip_patient_id = po.vip_patient_id) > >-> Index Scan using tblcnaccounts_pkey on tblcnaccounts a > (cost=0.08..0.36 rows=1 width=4) > > Index Cond: (master_user_id = d.master_user_id) > > Filter: ((user_name)::text = 'dd'::text) > > (19 rows) > > > > > > Regards, > > ravi > 1. Have you run ANALYZE on the database after upgrading? 2. Have you insured that the proper changed were done to the postgresql.conf in 9.6? -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
Re: [pgadmin-support] [GENERAL] Queries are taking way longer in 9.6 than 9.5
AND exists(SELECT 1 > > > > FROM > > > > tblCnAccounts a > > > > WHERE a.master_user_id = d.master_user_id > > AND > > > > a.user_name = 'dd')) > > > > AND osh.vip_order_type IN (17)--assist > > > > --AND osh.tx_submit_date IS NOT NULL > > > > AND osh.cancelled_date IS NULL > > > > AND osh.cc_accept_date IS NOT NULL; > > > > > > > > > > > > ## 9.5 Execution plan > > > > > > > > > > QUERY PLAN > > > > -- > > -- > > - > > > > Aggregate (cost=1177.25..1177.26 rows=1 width=0) > > > >-> Nested Loop (cost=67.83..1177.25 rows=5 width=0) > > > > -> Nested Loop (cost=67.71..254.81 rows=1322 width=4) > > > >-> Nested Loop (cost=67.63..104.45 rows=1322 width=4) > > > > -> HashAggregate (cost=67.54..68.12 rows=192 > > width=4) > > > >Group Key: d.vip_patient_id > > > > > > > >-> Nested Loop (cost=0.17..67.44 rows=192 > > width=4) > > > > -> Index Scan using unq_user_name on > > tblcnaccounts a (cost=0.08..4.09 rows=1 width=4) > > > >Index Cond: ((user_name)::text > > = > > 'dd'::text) > > > > > > > > -> Index Only Scan using > > idx_tblcndoctorpatientmap on tblcndoctorpatientmap d > > (cost=0.09..62.78 > > rows=192 width=8) > > > >Index Cond: (master_user_id = > > a.master_user_id) > > > > -> Index Scan using idx_tblcnpatientordermap on > > tblcnpatientordermap po (cost=0.09..0.17 rows=7 width=8) > > > >Index Cond: (vip_patient_id = > > d.vip_patient_id) > > > >-> Index Scan using tblpuorderstatus_pkey on > > tblpuorderstatus os (cost=0.09..0.11 rows=1 width=8) > > > > Index Cond: (vip_order_id = po.vip_order_id) > > > > -> Index Scan using tblpuorderstatushistory_pkey on > > tblpuorderstatushistory osh (cost=0.11..0.69 rows=1 width=4) > > > >Index Cond: (order_status_history_id = > > os.order_status_history_id) > > > >Filter: ((cancelled_date IS NULL) AND (cc_accept_date > > IS NOT NULL) AND (vip_order_type = 17)) > > > > > > > > ## > > ### > > > > > > > > ## 9.6 Execution plan > > > > QUERY > > PLAN > > > > -- > > --- > > > > Aggregate (cost=3185034.17..3185034.17 rows=1 width=8) > > > >-> Nested Loop Semi Join (cost=3012833.92..3185010.91 rows=46511 > > width=0) > > > > > > > > -> Nested Loop (cost=3012833.75..3137291.51 rows=46511 > > width=4) > > > > > > > >-> Hash Join (cost=3012833.67..3117860.77 rows=46511 > > width=4) > > > > Hash Cond: (os.order_status_history_id = > > osh.order_status_history_id) > > > > > > > > -> Seq Scan on tblpuorderstatus os > > (cost=0.00..96498.46 rows=11185486 width=8) > > > > -> Hash (cost=3010979.77..3010979.77 > > rows=529686 > > width=4) > > > >-> Gather (cost=1000.00..3010979.77 > > rows=529686 width=4) > > > > Workers Planned: 2 > > > > -> Parallel Seq Scan on > > tblpuorderstatushistory osh (cost=0.00..2957011.17 rows=220702 > > width=4) > > > > > > > >Filter: ((cancelled_date IS > > NULL) AND (cc_accept_date IS NOT NULL) AND (vip_order_type = 17)) > > > > > > > >-> Index Scan using tblcnpatientordermap_pkey on > > tblcnpatientordermap po (cost=0.09..0.41 rows=1 width=8) > > > > > > > > Index Cond: (vip_order_id = os.vip_order_id) > > > > > > > > -> Nested Loop Semi Join (cost=0.17..1.02 rows=1 width=4) > > > >-> Index Scan using tblcndoctorpatientmap_pkey on > > tblcndoctorpatientmap d (cost=0.09..0.39 rows=1 width=8) > > > > Index Cond: (vip_patient_id = po.vip_patient_id) > > > >-> Index Scan using tblcnaccounts_pkey on > > tblcnaccounts a (cost=0.08..0.36 rows=1 width=4) > > > > Index Cond: (master_user_id = d.master_user_id) > > > > Filter: ((user_name)::text = 'dd'::text) > > > > (19 rows) > > > > > > > > > > > > Regards, > > > > ravi > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > > > -- > Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > >I am not sure whether they are doing the vacuum after the upgrade or not So just run an ANALYZE on the database! -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
Re: [pgadmin-support] Call for feedback on pgAdmin4 features
I have just one wish. Fix ALL the bugs that have been reported BEFORE even thinking about adding "features". Melvin Davidson 🎸 Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com
Re: [pgadmin-support] pgadmin 4 enhancement request
Lance, I am not a PgAdmin developer, but you can easily accomplish what you want with either of the following two queries: -- Returns all columns for a specified table SELECT c.relname as table, a.attname as column, t.typname as type -- t.typlen as length, -- a.attrelid FROM pg_class c JOIN pg_attribute a ON ( a.attrelid = c.oid ) JOIN pg_type t ON (t.oid = a.atttypid ) WHERE relname = '' AND attnum > 0 AND NOT attisdropped ORDER BY 2; --a.attnum; -- OR Use INFORMATION_SCHEMA.COLUMNS SELECT column_name, data_type, character_maximum_length as length, column_default as default FROM INFORMATION_SCHEMA.COLUMNS where table_name = '' ORDER BY 1; --ordinal_position; Melvin Davidson 🎸 Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: "Campbell, Lance" To: "pgadmin-support@postgresql.org" Sent: Wednesday, April 19, 2017 10:05 AM Subject: [pgadmin-support] pgadmin 4 enhancement request In pgadmin 4 in the left hand navigation you can select the “Columns” label under any table listed in order to get a list of all columns within a table. A fantast enhancements would be to add to the “File >> Preferences” the ability to do either option #1 or #2 listed below: 1) A question in File >> Preferences to sort the default display of Columns listed in the left hand navigation alphabetically versus the natural table order. OR 2) A question in the File >> Preferences that says something like “What order would you like the Columns to be listed by default in the left hand navigation:” . Then have three radio button options: a) Natural order b) Alphabetical order c) Grouped by primary key, then foreign keys, then other columns. Within foreign keys and other columns list them alphabetical. I know you have a lot going on. I am sure this enhancement seems trivial. But when you have a table with a lot of columns this is an amazing feature to have. Before the release of 4-1.4 I was using a different admin tool. I found this feature exceptionally nice and very useful. Thanks for considering this feature request. Lance
Re: [pgadmin-support] making me love pgAdmin III
Dave,
If you are looking for constructive criticism, then the following are options
that
were in PgAdmin III and at minimum should be added back to PgAdmin4.
1. The ability to choose a specific font for displays or query window
2. Choose colors for query options
3. Favorites & macros in query screen
4. Choose colors for server status
Personally, I still cannot comprehend why all options/features that were in
PgAdmin III
were not included in PgAdmin4. I have never heard of any other software program
whereoptions/features from a previous release were not included in the newest
release.
Compare the options window in PgAdmin4 to PgAdmin III and you will see there is
a greatdeal more missing.
As to your statement "the number of people I've had complimenting pgAdmin 4 is
probably
20x the number who have said they don't like it.", those compliments must be
coming to
another email address other than pgadmin-support, because I have not seen them.
I do appreciate what you and your team are doing, but as I have said before, I
believePgAdmin4 was a hurried release and more testing should have been done
before it went GA.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: Dave Page
To: Eric Hill
Cc: "pgadmin-support@postgresql.org"
Sent: Thursday, May 18, 2017 4:43 PM
Subject: Re: [pgadmin-support] making me love pgAdmin III
On 18 May 2017, at 21:09, Eric Hill wrote:
#yiv3737576863 #yiv3737576863 -- _filtered #yiv3737576863 {panose-1:2 4 5 3 5 4
6 3 2 4;} _filtered #yiv3737576863 {font-family:Calibri;panose-1:2 15 5 2 2 2 4
3 2 4;}#yiv3737576863 #yiv3737576863 p.yiv3737576863MsoNormal, #yiv3737576863
li.yiv3737576863MsoNormal, #yiv3737576863 div.yiv3737576863MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv3737576863 a:link,
#yiv3737576863 span.yiv3737576863MsoHyperlink
{color:#0563C1;text-decoration:underline;}#yiv3737576863 a:visited,
#yiv3737576863 span.yiv3737576863MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;}#yiv3737576863
span.yiv3737576863EmailStyle17 {color:windowtext;}#yiv3737576863
.yiv3737576863MsoChpDefault {} _filtered #yiv3737576863 {margin:1.0in 1.0in
1.0in 1.0in;}#yiv3737576863 div.yiv3737576863WordSection1 {}#yiv3737576863 Hey,
I don’t mean to hurt anyone’s feelings or anything, but is it not obvious to
everyone that pgAdmin 4 (I have version 1.4) is bloody horrendous? It is
absolutely as slow as Christmas. It’s use of screen real-estate is poor. I
was never a huge fan of pgAdmin III; I mean, it seemed to do its job okay, but
after using pgAdmin 4, suddenly I have newfound respect for pgAdmin III.
Not to me, because the number of people I've had complimenting pgAdmin 4 is
probably 20x the number who have said they don't like it. Which is a good sign
- normally people who don't like something are far more likely to say something.
Either way, I'm not going to lose sleep over it. pgAdmin 4 is far more stable
than pgAdmin 3 was, has attracted more new developers in a year than pgAdmin 3
had in 15, and continues to improve with every release. I'm very proud of the
way the team have built such a complex application in such a short space of
time that many people have told me they like.
You can't please everyone unfortunately, but then a) it's free (despite being
estimated at over $2M worth of work), and b) it's open source so those that are
inclined can help improve it further.
Constructive feedback is always welcome of course. In your case maybe you could
explain how you're using it such that you see slow response. For me, it
performs well, even on my low powered 1.2GHz MacBook. It's naturally slower
than pgAdmin 3 of course, as it's not a native application, but it still
outpaces my ability to drive it and I'm no slouch behind the keyboard.
Regards, Dave
Re: [pgadmin-support] SQL syntax highlightning don't work for single backslash '\'
>When I have somewhere in text value single backslash char, then everything >behind this char will not be highlighted correct. That is because the Backslash is an ESCAPE character, so you must ESCAPE it and use two backslashes if you want it to be interpretedas a literal. Also, do not forget to enclose your strings in quotes! IE: SELECT 'a' || E'\\' || 'b' UNION ALL SELECT 'c' || E'\\' || 'd'; https://www.postgresql.org/docs/9.4/static/functions-matching.html#POSIX-ESCAPE-SEQUENCES Melvin Davidson 🎸 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: "mammoth.po...@gmx.us" To: pgadmin-support@postgresql.org Sent: Monday, May 22, 2017 3:17 PM Subject: [pgadmin-support] SQL syntax highlightning don't work for single backslash '\' When I have somewhere in text value single backslash char, then everything behind this char will not be highlighted correct. Simple example 1: SELECT '\'; Simple example 2: -- Test 1SELECT a || '\' || bUNION ALL-- Test 2SELECT c || '\' || d; Screenshots of syntax highlighting: Single backslash: Dual backslash: pgAdmin 4 v1.5Desktop RuntimeWindows 10 x64 1511 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] SQL syntax highlightning don't work for single backslash '\'
>Unless you omit the E prefix on the string literal, which the OP did. Nope! That results in 'a//b' but the op wants 'a/b'; Hence the need to Escape. Melvin Davidson 🎸 Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: David G. Johnston To: Melvin Davidson Cc: "mammoth.po...@gmx.us" ; "pgadmin-support@postgresql.org" Sent: Monday, May 22, 2017 3:54 PM Subject: Re: [pgadmin-support] SQL syntax highlightning don't work for single backslash '\' On Monday, May 22, 2017, Melvin Davidson wrote: >When I have somewhere in text value single backslash char, then everything >behind this char will not be highlighted correct. That is because the Backslash is an ESCAPE character, so you must ESCAPE it and use two backslashes if you want it to be interpretedas a literal. Unless you omit the E prefix on the string literal, which the OP did. David J.
Re: [pgadmin-support] making me love pgAdmin III
Christopher,
I am not PgAdmin support, but in all fairness
>You cannot make a pg_dump from a single column. You always have to dump the
>whole table. this has never been the case. pg_dump has never had the option to
>dump just a single column.
https://www.postgresql.org/docs/9.6/static/app-pgdump.html
If you want to "dump" a single column, you must use the COPY TO command.
https://www.postgresql.org/docs/9.6/static/sql-copy.html
Melvin Davidson 🎸
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: Christoph Schreiber
To: "pgadmin-support@postgresql.org"
Sent: Tuesday, May 23, 2017 3:13 AM
Subject: Re: [pgadmin-support] making me love pgAdmin III
#yiv0967049619 #yiv0967049619 -- _filtered #yiv0967049619
{font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv0967049619
{panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv0967049619
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv0967049619
#yiv0967049619 p.yiv0967049619MsoNormal, #yiv0967049619
li.yiv0967049619MsoNormal, #yiv0967049619 div.yiv0967049619MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}#yiv0967049619 a:link,
#yiv0967049619 span.yiv0967049619MsoHyperlink
{color:#0563C1;text-decoration:underline;}#yiv0967049619 a:visited,
#yiv0967049619 span.yiv0967049619MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;}#yiv0967049619
p.yiv0967049619MsoListParagraph, #yiv0967049619
li.yiv0967049619MsoListParagraph, #yiv0967049619
div.yiv0967049619MsoListParagraph
{margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt;font-size:11.0pt;}#yiv0967049619
span.yiv0967049619E-MailFormatvorlage17 {color:windowtext;}#yiv0967049619
span.yiv0967049619E-MailFormatvorlage18 {color:#1F497D;}#yiv0967049619
.yiv0967049619MsoChpDefault {font-size:10.0pt;} _filtered #yiv0967049619
{margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv0967049619
div.yiv0967049619WordSection1 {}#yiv0967049619 _filtered #yiv0967049619 {}
_filtered #yiv0967049619 {} _filtered #yiv0967049619 {} _filtered
#yiv0967049619 {font-family:Wingdings;} _filtered #yiv0967049619
{font-family:Symbol;} _filtered #yiv0967049619 {} _filtered #yiv0967049619
{font-family:Wingdings;} _filtered #yiv0967049619 {font-family:Symbol;}
_filtered #yiv0967049619 {} _filtered #yiv0967049619
{font-family:Wingdings;}#yiv0967049619 ol {margin-bottom:0cm;}#yiv0967049619 ul
{margin-bottom:0cm;}#yiv0967049619 Hi Dave, well then I wanna give you a
constructive feedback. My 3 biggest issues with pga4 are - It is not
working on Win10. If you install it and then e.g. make a dump you don’t see the
little pop-up window with the status/error/success message. So I do never know
what is happening. And in my opinion a software has to support all modern
Windows versions. - You cannot make a pg_dump from a single column. You
always have to dump the whole table. - And the far biggest issue is,
that the commit/rollback buttons are missing. I accustom myself to never use
the autocommit function for safety reasons. But is there a way in pga4 to
commit a query “by hand” like in pga3? These issues make me use pgAdmin3
with the newest version of the pgsql programm so that it is working with a 9.6
database. And it works fine. No crashes. Even the loosing server connection
problems seems to be fixed. Regards, Christoph Von:
pgadmin-support-ow...@postgresql.org
[mailto:pgadmin-support-ow...@postgresql.org]Im Auftrag von Dave Page
Gesendet: Donnerstag, 18. Mai 2017 22:43
An: Eric Hill
Cc: pgadmin-support@postgresql.org
Betreff: Re: [pgadmin-support] making me love pgAdmin III
On 18 May 2017, at 21:09, Eric Hill wrote:
Hey, I don’t mean to hurt anyone’s feelings or anything, but is it not
obvious to everyone that pgAdmin 4 (I have version 1.4) is bloody horrendous?
It is absolutely as slow as Christmas. It’s use of screen real-estate is poor.
I was never a huge fan of pgAdmin III; I mean, it seemed to do its job okay,
but after using pgAdmin 4, suddenly I have newfound respect for pgAdmin III.
Not to me, because the number of people I've had complimenting pgAdmin 4 is
probably 20x the number who have said they don't like it. Which is a good sign
- normally people who don't like something are far more likely to say
something. Either way, I'm not going to lose sleep over it. pgAdmin 4 is far
more stable than pgAdmin 3 was, has attracted more new developers in a year
than pgAdmin 3 had in 15, and continues to improve with every release. I'm very
proud of the way the team have built such a complex application in such a short
space of time that many people have told me they like. You can't please
everyone unfortunately, but then
Re: [pgadmin-support] pgAdmin4 speed
A good suggestion, but there are a few things wrong with that. 1. Not everyone has python installed on Windows 10, at least not by default. So it requires python to be downloaded and installed just to run PgAdmin4. 2. Many of us do not want to use PgAdmin4 in a browser. We want it in standalone mode. 3. It's a workaround that says it's ok to ignore a major problem. Melvin Davidson 🎸 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com From: Richard Greenwood To: pgadmin-support@postgresql.org Sent: Wednesday, May 24, 2017 9:15 AM Subject: [pgadmin-support] pgAdmin4 speed There were several recent comments on this list about pgAdmin4 being slow which surprised me as I've found it to be faster than pgAdmin3. But then I saw pgAdmin4 on a Windows machine in standalone mode and realized what people are complaining about. I'm running the python server script and then using pgAdmin4 in a web browser. I suggest that folks who are bothered by the speed (lack of) in standalone mode give the server + browser setup a try. The server is launched with a single command: python /path/to/pgAdmin4.pythen navigate to: localhost:5050 Rich -- Richard W. Greenwood, PLS www.greenwoodmap.com
Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.
Pawel, I am NOT Pgadmin support, but I tried your query in PgAdmin 4 v1.5 andI saw the following error returned. ERROR: relation "non_existing_table" does not existLINE 1: select * from non_existing_table; ^** Error **ERROR: relation "non_existing_table" does not existSQL state: 42P01Character: 15 So I would suggest you also provide information as the the O/S you are using and how you installed PgAdmin 4. Also, what version of PostgreSQL you areusing. Melvin Davidson 🎸 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com On Sunday, June 11, 2017, 6:34:52 PM EDT, Pawel Hadam wrote: Hi All, Not sure if this is a version related or I am doing something wrong. Let's say I query a non-existing table. I am expecting to see an SQL error message saying that the table does not exist. And this is what I can see in pgAdmin III. Unfortunately, pgAdmin 4 does not show any reasonable messages. At the same time, select from an existing table correctly returns the data in all 3 cases below. The SQL query I run is: select * from non_existing_table; I can see those messages: pgAdmin III 1.22.2: -- BŁĄD: relacja "non_existing_table" nie istnieje LINE 1: select * from non_existing_table; ^ ** Error ** BŁĄD: relacja "non_existing_table" nie istnieje SQL state: 42P01 Character: 15 -- pgAdmin 4 1.3: -- Not connected to the server or the connection to the server has been closed. -- pgAdmin 4 1.5: -- Query returned successfully in 751 msec. -- I would appreciate to hear any comments or might be someone noticed the same? All examples are from Windows and PostgreSQL 9.6. Thanks and regards Pawel On 11 June 2017 at 12:11, wrote: > Dear pgAdmin developers, > > When I first heard that you were doing a total rewrite of pgAdmin III, I was > extremely excited, because I had long been frustrated with the various > annoyances and bugs in that program, which I was (and am still, actually) > using daily, primarily how it always felt like a chore to start up and get > ready unless the server was physically located near me. > > So when you eventually released the first public version of pgAdmin > generation 4, I very eagerly downloaded it and tried it out. Unfortunately, > to claim that I was "disappointed" isn't enough; I was frankly *appalled*. I > will list the reasons in a moment, but I'd first like to point out that > since then, I have repeatedly tried new versions of it, hoping to see > improvements, but unfortunately finding all the same issues still present > (as of v1.5, 2017-06-11, at the time of typing). > > Here are the critical issues: > > 1. Extreme sluggishness. Both the GUI itself, and the fetching of data from > the server, is so slow and flimsy as to drive me insane even efter using it > for less than a minute. I seriously get so angry that I kill the window in > disgust. I'm not trying to be insulting or overly dramatic; this is just a > fact. The software makes me angry due to how slow and unreliable it seems, > and how prone it is to freeze (although it recovers after a while). This is > on a *very* powerful and modern x86 workstation running a very "clean" > (relative) Windows 10. All other programs are responsive and fast, except > for pgAdmin 4. I really feel handicapped using it, in a way that's not at > all the case with the old pgAdmin III, although even that one has mysterious > fetch-delays that don't seem to correspond with the amount of data pulled > through the network (SSH tunnel)... > > 2. It doesn't remember the empty password. It just keeps on asking, again > and again, for the nonexistent password, even though I've checked the box to > "remember" it a million times. This is infuriating to say the least. > > 3. Even worse so than the old program, pgAdmin 4 also doesn't seem to > remember the "last state" at all, forcing me to slowly progress through the > tree hierarchy each time I start it, waiting seconds each time I click > anything. This makes me just let out a big sigh each time I have to manage > my databases in any way, including making simple queries in a graphical > environment. What should be instant becomes a huge chore. I cannot believe > that it doesn't remember the "state" of the collapsed objects until the next > time. > > In order to say something positive, I do appreciate the cross-platformness > and apparently the ability for it to run in a browser, hosted on a server. > (Although I personally don't trust it or any other software to do that > safely.) Sadly, this has the serio
Re: [pgadmin-support] "pgadmin4" - slow?
Regardless of the upcoming problem resolution regarding slow start times, or any of the multitude of Reddit reports, I think PgAdmin developers should consider this a lesson learned and test on ALL platforms (IE:Mac, Windows, Linux) before releasing a new version. Melvin Davidson 🎸 Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com On Wednesday, June 14, 2017, 9:17:49 AM EDT, Dave Page wrote: On Wed, Jun 14, 2017 at 1:55 PM, Bruno Friedmann wrote: > On mercredi, 14 juin 2017 10.13:44 h CEST Dave Page wrote: >> On Wed, Jun 14, 2017 at 9:07 AM, Mike Surcouf wrote: >> > Static resources will be good for caching :-) I would expect to see >> > performance gains when using remotely via a browser. Thankyou. I'm not >> > sure whether QtWeb will benefit as much as its local traffic so round >> > trips should be pretty instantaneous. Unless QtWeb is horribly >> > inefficient in which case I hope it helps. >> Right - and on Windows, I think that is actually the problem which is >> why users have reported that running the server separately and using a >> regular browser makes a big difference. >> >> FYI, when I was testing on Windows over the weekend, in my test VM, >> simply changing "localhost" as the connection target in the runtime to >> "127.0.0.1" took the startup time from ~34 seconds to ~24. I lost >> count of how many times I tested that, but it was pretty consistent. >> That hints to me that the network side is what is less performant - >> obviously the resolver, but I suspect also connection setup which is >> why I have high hopes for web packing. > > Is this doesn't linked to the fact that localhost on modern system is mapped > to ::1 (the ipv6 loopback) and 127.0.0.1 the old ipv4 one. > > By default ipv6 is called first, then ipv4 the problem is the python api is > listening only on ipv4 :-) I don't think so - previously both the server and client were using 'localhost', so should have defaulted to either 127.0.0.1 or ::1 depending on the system config. Now, both are using '127.0.0.1', which is what gained the 10 seconds I mentioned above. Of course, the downside of this is that it requires IPv4 on the users machine, but practically speaking I don't think that's likely to be an issue - is anyone really running IPv6 only? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?
As others have pointed out, there are other graphical administration tools for PostgreSQL. If you really cannot wait for PgAdmin 4 to be "fixed" to your satisfaction, just look here: wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools I too am also disappointed in the current version of the product, so I simply continue to use PgAdmin III until I see sufficient improvements. However, yourrecent rants does nothing to encourage Dave Page and his team. So kindly rephrase your disappointment into positive suggestions. Melvin Davidson 🎸 Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com On Thursday, June 15, 2017, 1:05:55 PM EDT, wrote: It doesn't seem possible to get through to you. Whatever you spent those one million dollars on, it sure as hell wasn't related to pgAdmin in any way. More like very heavy drugs, if you think this is even acceptable for pre-pre-pre-alpha software. It's literally *unusable*. You get it? UNUSABLE. Anyone who claims otherwise must have something wrong in their head. Are you just going to keep on this charade or actually fix the problem? Do I have to switch from PostgreSQL to something else just because the admin tool is broken beyond the point of being usable to anyone? This is insanity.
Re: [pgadmin-support] So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?
>Are computer professionals still using MS Windows? Yes, we use MS Windows with PgAdmin to connect to PostgreSQL on LINUX systems. Melvin Davidson 🎸 Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com On Thursday, June 15, 2017, 9:15:59 PM EDT, Richard Greenwood wrote: Like is this a charade? Am I hallucinating? Are computer professionals still using MS Windows? On Thu, Jun 15, 2017 at 12:07 PM, Patrick Headley wrote: It doesn't sound like anyone is ignoring the problem but some issues are harder to fix than others. If pgAdmin4 isn't working for you, use something else. No one is saying you have to use pgAdmin4. While you are accusing many people of having something wrong in their heads I have observed that you are the only one that is flipping out over the issue. As I stated in a prior message, I was dissatisfied with pgAdmin4 on Windows so I got pgAdmin3 for Windows and PostgreSQL 9.6 from another vendor that is maintaining pgAdmin3. No need to panic. Still getting my work done. When pgAdmin4 works well (and it's getting there and it's definitely not the worst performing software that I use on a daily basis), I'll make the switch. Another way of looking at the situation is that someone has to test the software. It cannot be up to David alone. There are many people doing this and not flipping out about the issues but simply presenting them to David so they can be fixed. It's a process. No software is perfect on every machine and platform before being released. There is no way for David to test every possible scenario and he has explained that already. It takes a community of cooperation to make it right. I hope you can find a solution that works for you while David works out the bugs in pgAdmin4. Patrick Headley Linx Consulting, Inc. phead...@linxco-inc.com (303) 916-5522 www.linxco-inc.com On 06/15/2017 11:20 AM, David G. Johnston wrote: On Thu, Jun 15, 2017 at 10:05 AM, wrote: It doesn't seem possible to get through to you. Whatever you spent those one million dollars on, it sure as hell wasn't related to pgAdmin in any way. More like very heavy drugs, if you think this is even acceptable for pre-pre-pre-alpha software. It's literally *unusable*. You get it? UNUSABLE. Anyone who claims otherwise must have something wrong in their head. Are you just going to keep on this charade or actually fix the problem? Do I have to switch from PostgreSQL to something else just because the admin tool is broken beyond the point of being usable to anyone? This is insanity. There isn't a monopoly on GUI admin software for PostgresSQL. While it has its quirks I find PostgreSQL Maestro to be quite functional for my needs - at least the ones I don't solve by writing scripts and executing them via psql. The server is going to function the same no matter which external administration/client tools you choose to use. I rarely used pgAdmin3, I found it to be "too graphical" if that makes sense, and haven't tried pgAdmin4. My scanning of this mailing list leads me to believe what you are saying is reasonably accurate even if your tone is not: there are a number of active discussions on this very topic on this mailing list right now. David J. -- Richard W. Greenwood, PLS www.greenwoodmap.com
