[pgadmin-support] Hi I have a problem in PGAdmin 8.0
Hi I am doing a research about rule engine and saw your RuleCore and postgreSQL and thought i can get some knowledge and if this fulfill my requirement i thought of buying it also.. I have installed the Rulecore and the postgreSQL.I have created a simple rule,event,situation and events in the rule designer.When I tried to use the generator iam getting "Error connecting to server :Connection refused".I tried changing the local_addresses='*' in the conf file but still not working.Can u tell me the password field to connect to the postgreSQL. by default. Thanks Sriram
[pgadmin-support] Connecting to a remote database
When I connect to a remote database I get this message: "An error has occured: Error connecting to the server: FATAL: Missing or erroneous ph_hba.conf file, see postmaster log for details." Naturally I have something wrong, this is NOT a bug report for that, rather it is a plea (RFE) for a more informative message. This message falls down in a number of ways: 1) Is it missing or is it erroneous? Why doesn't pgadmin know the difference? 2) Is the file on the local system or remote system? 3) Where is the ph_hba.conf file? 4) What is erroneous about it? 5) Where is the postmaster log file, on which machine, and what details am I looking for? 6) Why doesn't this box allow me to view the log file? 7) Last and least: occurred has two 'r's ;-) -Nigel Horne ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-support] Connecting to a remote database
Nigel Horne schrieb: When I connect to a remote database I get this message: "An error has occured: Error connecting to the server: FATAL: Missing or erroneous ph_hba.conf file, see postmaster log for details." Naturally I have something wrong, this is NOT a bug report for that, rather it is a plea (RFE) for a more informative message. This message falls down in a number of ways: 1) Is it missing or is it erroneous? Why doesn't pgadmin know the difference? Ah well, the message comes from the server, so guess what pgadmin can really know about it :-) 2) Is the file on the local system or remote system? postmaster is the server. So look there (or ask your DBA) 3) Where is the ph_hba.conf file? Again, ask your sysadmin of the server. If you set up yourself, you would have read the documenation, right? ;)) *hint* 4) What is erroneous about it? It told you to read the logfile on the server to find out :) 5) Where is the postmaster log file, on which machine, and what details am I looking for? See above :-) 6) Why doesn't this box allow me to view the log file? Because you cant connect? And there is no fileaccess to joe average anyway ;) 7) Last and least: occurred has two 'r's ;-) Try to mess up your /etc/passwd on a unix box and then connect via ssh. Compare the messages you get and what to do :-) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-support] Mac OSX 10.4.2 problem...
I am running Mac OSX 10.4.2 and PgAdmin 1.2.2 Attempts to add a record to a simple database result in crashing the application. Frequently the crash occurs while trying to enter data in the "bottom" row of the grid. I don't have this problem on my windows box. Is this a well known problem? Do you need more info? Jerry ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[pgadmin-support] some way to continue forward even when an error occurs
eg. set continue_on_error = true or maybe an option in the gui to continue execution. This is a problem when you run ddl that attempts to drop some non-existant items. I think it should report that the item being deleted does not exist but then should continue on to the next statement instead of aborting the run. Oracle, Sybase, and MSSQL do this by default. thanks! brad ---(end of broadcast)--- TIP 6: explain analyze is your friend
[pgadmin-support]
Request for support for pgAdmin ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-support] Error Message: ERROR: catalog is missing 4 attribute(s) for relid 649444
-- System Information -- Platform: Windows 2000 Version: 5.0 Build: 2195 Service Pack 4 -- Application Information -- Name: pgAdmin II Version: 1.6.0 Descripton: Name: pgSchema Version: 1.6.0 Descripton: PostgreSQL Schema Objects v1.6.0 -- Database Information -- Version: 7.4.0 Descripton: PostgreSQL 7.4 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.3.1 (cygming special) -- Driver Information -- Name: PostgreSQL Version: 7.3.100 Descripton: PostgreSQL 7.4 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.3.1 (cygming special) -- Error Information -- Description: ERROR: catalog is missing 4 attribute(s) for relid 649444 Number: -2147467259 Routine: pgAdmin II:frmMain.tvTable Insert your comment: ---(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