Re: [pgadmin-support] silently fails to connect to remote server
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Chris Velevitch > Sent: 05 April 2006 07:30 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] silently fails to connect to remote server > > I'm using the Windows version 1.4.2 on Win XP Sp1. > > When I try to connect to a remote server, the connection > silently fails. According to the manual, I should be getting > a pop-up dialog detailing the connection failure. Instead, > the status bar at the bottom of the window shows:- > > Connecting to database... Failed > > Also the log shows nothing. Please turn logging to debug level under File->Options, retry the connection and then check/send the logfile over. Regards, Dave ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] Maintenance DB
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Chris Velevitch > Sent: 05 April 2006 07:37 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Maintenance DB > > I'm using Windows version 1.4.2 on Win XP Sp1. > > I'm trying to add a new server for a remote server and I > don't understand what the 'Maintenance DB' attribute is. > Manual says nothing about it. Wow, not sure how that got missed. Will fix. The Maintenance DB is the database that pgAdmin first connects to. Unlike some DBMSs, all PostgreSQL connections must be made to a database, you cannot connect and then select a database. This database is normally 'postgres' in PostgreSQL 8.1+, prior to that, template1 was generally used. Regards, Dave. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-support] silently fails to connect to remote server
On 4/5/06, Dave Page wrote: > > Also the log shows nothing. > > Please turn logging to debug level under File->Options, retry the > connection and then check/send the logfile over. I did that, nothing was logged. Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au ---(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
[pgadmin-support] line number in error output
I'm using Windows version 1.4.2 on Win XP sp1. When I get an error in executing a sql code, I get ERROR: syntax error at or near "45183" at character 5848 There is no line number included. Such information would make very easy to locate the offending code. Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [pgadmin-support] line number in error output
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Chris Velevitch > Sent: 05 April 2006 08:17 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] line number in error output > > I'm using Windows version 1.4.2 on Win XP sp1. > > When I get an error in executing a sql code, I get > > ERROR: syntax error at or near "45183" at character 5848 > > There is no line number included. Such information would make > very easy to locate the offending code. The error messages comes from PostgreSQL so we cannot change it. pgAdmin looks at the character number though and bungs a marker in the left margin to highlight the offending line in your code. Regards, Dave. ---(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
[pgadmin-support] UI Request
Hi, I've a suggest: - is possible to make "index" default name (in the "new index" form, after selecting the field/s ) created by pgAdmin as that postgres default use? (tablename_fieldname_index) Thank you Great work, I'm waiting next release! ___ Yahoo! Messenger with Voice: chiama da PC a telefono a tariffe esclusive http://it.messenger.yahoo.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[pgadmin-support] Create db problem
Hi, I've some strange behaviours managing databases: - if I want create a new db from a postgres console (psql) I MUST have all pgAdmin clients closed (because 'maintenance db' lock postgres db) - using pgAdmin I cannot create a new db using the connected db as template Thank you ___ Yahoo! Mail: gratis 1GB per i messaggi e allegati da 10MB http://mail.yahoo.it ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [pgadmin-support] Create db problem
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Mauro Bertoli > Sent: 05 April 2006 09:40 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Create db problem > > Hi, I've some strange behaviours managing databases: > > - if I want create a new db from a postgres console > (psql) I MUST have all pgAdmin clients closed (because > 'maintenance db' lock postgres db) That's why PostgreSQL 8.1 has the 'postgres' database so apps like pgAdmin no longer use template1. > - using pgAdmin I cannot create a new db using the connected > db as template You can only create a DB using a connected DB as a template if you create the database /from/ that template dattabase, and that is the only connection to that database. Regards, Dave ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-support] ERROR: permission denied for schema public
I'm using Windows version 1.4.2 on Win Xp Sp1. I've just pg_dump a database and when I open the file and run it, I get:- ERROR: permission denied for schema public but I don't know what it's referring to. There is no marker indicating the offending line. What does this mean? Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[pgadmin-support] rename database
I'm using windows version 1.4.2 on Win XP sp1 and pg 7.4.11. I can't rename a database because I get an error saying it's in use, but I'm the only one using it. So how do I do it? Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-support] line number in error output
Hi! Dave Page wrote: I'm using Windows version 1.4.2 on Win XP sp1. When I get an error in executing a sql code, I get ERROR: syntax error at or near "45183" at character 5848 There is no line number included. Such information would make very easy to locate the offending code. The error messages comes from PostgreSQL so we cannot change it. pgAdmin looks at the character number though and bungs a marker in the left margin to highlight the offending line in your code. How does that work with localized server messages, how does pgAdmin handle them? I get a partly translated error message from the server: NAPAKA: napaka v sintaksi at or near "form" pri znaku 11 pgAdmin does not put any markers in the left margin here. Regards, Miha ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[pgadmin-support] pgAgent problems
I am having problems with pgAgent. I installed the seervice with the following command: C:\Program Files\PostgreSQL\8.1\bin>"C:\Program Files\PostgreSQL\8.1\bin\pgAgent" INSTALL pgAgent -u postgres -p postgres -t 60 hostaddr=127.0.0.1 dbname=postgres user=postgres In the services, the path to executable is set as follows: C:\Program Files\PostgreSQL\8.1\bin\pgAgent RUN pgAgent -t 60 hostaddr=127.0.0.1 dbname=postgres user=postgres The directory where pgAgent is located is not on the path. I scheduled a job - everything looks correct. The job shows up as scheduled for the next execution time. I checked the pgagent schema in the postgres database (which is the one specified in the connection), and I see the job, steps, etc. The information for the job is as follows: Name: ishield - calculate control limits ID: 2 Enabled: yes Host Agent: left blank Job Class: Data Summarisation Created: 4/5/2006 10:06:26 AM Changed: 4/5/2006 10:06:26 AM Next run: 4/5/2006 12:00:00 PM Last Run: blank Last result: unknown Running at: Not Currently Running Comment: This job should have run at 12. It is already past the scheduled time and the job has not run. Any suggestions will be deeply appreciated. The windows event log shows the service as having started successfully, but I see no additional logging. Thanks in advance, Benjamin
Re: [pgadmin-support] pgAgent problems
Title: Re: [pgadmin-support] pgAgent problems On 5/4/06 19:18, "Benjamin Krajmalnik" <[EMAIL PROTECTED]> wrote: I am having problems with pgAgent. I installed the seervice with the following command: C:\Program Files\PostgreSQL\8.1\bin>"C:\Program Files\PostgreSQL\8.1\bin\pgAgent" INSTALL pgAgent -u postgres -p postgres -t 60 hostaddr=127.0.0.1 dbname=postgres user=postgres In the services, the path to executable is set as follows: C:\Program Files\PostgreSQL\8.1\bin\pgAgent RUN pgAgent -t 60 hostaddr=127.0.0.1 dbname=postgres user=postgres The directory where pgAgent is located is not on the path. I scheduled a job - everything looks correct. The job shows up as scheduled for the next execution time. I checked the pgagent schema in the postgres database (which is the one specified in the connection), and I see the job, steps, etc. The information for the job is as follows: Name: ishield - calculate control limits ID: 2 Enabled: yes Host Agent: left blank Job Class: Data Summarisation Created: 4/5/2006 10:06:26 AM Changed: 4/5/2006 10:06:26 AM Next run: 4/5/2006 12:00:00 PM Last Run: blank Last result: unknown Running at: Not Currently Running Comment: This job should have run at 12. It is already past the scheduled time and the job has not run. Any suggestions will be deeply appreciated. The windows event log shows the service as having started successfully, but I see no additional logging. If you reinstall the service with –l 2 as an extra option, then schedule a new job there should be a load of extra debug data in the event log to tell us what’s going wrong. One thing that does spring to mind is that you didn’t mention how the agent authenticates to the database – have you setup a pgpass.conf file in your postgres user’s %APPDATA% directory, or granted trusted access in pg_hba.conf? Regards, Dave.
[pgadmin-support] Current database
I'm using windows version 1.4.2 on Win XP Sp1. Right-clicking a non current database makes it current. Why? I'm trying to rename the database but I can't because you can't rename the current database. How do you make a database non-current? Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au ---(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
