Re: [pgadmin-support] Font size in query windows

2007-02-21 Thread Andy Shellam (Mailing Lists)
Hi Dan, Dan Harris wrote: Hello, I'm running the latest OS X binary and hoping to replace my existing expensive query tool with it. However, I am having some problems with the SQL Query window. The input window default font is too small, almost unreadable ( running 1900x1280 resolution ).

Re: [pgadmin-support] Chg Pwd Help

2007-02-17 Thread Andy Shellam (Mailing Lists)
Can you connect to the database to start with? If you can, then you're OK - if not, you need a password (or access to the server's pg_hba.conf file.) To get the password dialogue shown in that website, connect to the Postgres server, and on the File menu, click "Change Password." Or, extend "

[pgadmin-support] Admin pack's "logfile" doesn't work

2007-02-17 Thread Andy Shellam (Mailing Lists)
Hi, I have PgAdmin 1.6.2 talking to a PostgreSQL 8.2.3 server with the distributed admin pack installed (from source's contrib/adminpack), and have ran the adminpack.sql script against the postgres database. If, in PgAdmin, I click Tools > Server Status and select the "logfile" tab, I get th

[pgadmin-support] Update Guru for Admin Pack

2007-02-17 Thread Andy Shellam (Mailing Lists)
Hi, Just a quick request to update the "This server lacks instrumentation features" Guru message for PostgreSQL 8.2. I've just downloaded the source for PgAdmin, looked at the readme in "xtra/admin81", and found the instructions in there that PostgreSQL 8.2 now includes the admin pack as stand

Re: [pgadmin-support] pgadmin3 and fc6

2007-02-16 Thread Andy Shellam (Mailing Lists)
Try --nodeps instead of --force. Hopefully that should tell it to ignore any package dependencies. tyson wrote: I tried using the --force and it still throws the same conflict. For some reason it can't locate that libpq.so.5 link Not sure what else I can do! Andy Shellam (Mailing

Re: [pgadmin-support] pgadmin3 and fc6

2007-02-16 Thread Andy Shellam (Mailing Lists)
twenger26 wrote: Andy Shellam (Mailing Lists) wrote: twenger26 wrote: I saw a previous post where someone had the same problem as I, but their solution didn't work for me. I am trying to install pgadmin3 of FC6 and I keep getting the error: "libpq.so.5 is needed by pgadmi

Re: [pgadmin-support] pgAdmin III 1.6.2 sends plaintext password

2007-02-15 Thread Andy Shellam (Mailing Lists)
patrimith wrote: Andy Shellam (Mailing Lists) wrote: What is the value of "password_encryption" in your PostgreSQL server's postgresql.conf file? [EMAIL PROTECTED] ~]# cat /endeavour/dbstore/postgresql.conf|grep 'password_encryption' password_encrypt

Re: [pgadmin-support] pgAdmin III 1.6.2 sends plaintext password

2007-02-15 Thread Andy Shellam (Mailing Lists)
patrimith wrote: Greetings List! I'm trying get remote management of postrgesql on Ubuntu 5.10 set up. I am hoping to set up authentication in pg_hba.conf as host all all 192.168.0.0/0 md5 but I wasn't successful. When I relaxed it to: host all all 192.168.0.0/0 password everything worked f

Re: [pgadmin-support] pgadmin3 and fc6

2007-02-15 Thread Andy Shellam (Mailing Lists)
twenger26 wrote: I saw a previous post where someone had the same problem as I, but their solution didn't work for me. I am trying to install pgadmin3 of FC6 and I keep getting the error: "libpq.so.5 is needed by pgadmin3-1.6.1-2.i386". I have two versions of postgresql on my system, but I am

Re: [pgadmin-support] PgAdmin : table backup problem

2007-02-15 Thread Andy Shellam (Mailing Lists)
I seem to recall this having cropped up a few weeks ago. Dave will be able to confirm but I think this may have been fixed for 1.6.3? Regards, Andy. Cassiano, Marco wrote: Hello everybody, I have a problem when I try to backup a table from inside PgAdmin. If I select a table and choose t

Re: [pgadmin-support] Password Policy

2007-02-10 Thread Andy Shellam (Mailing Lists)
Clodoaldo wrote: 2007/2/10, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]>: Hi list, Is there any password polity that postgresql implement ? It is possible to put a set all no administrators passwords to = '123456' from times and times ? Has anyone implement a dinamic password autenticati

Re: [pgadmin-support] Graphical explain plan sometimes shows "using" for the index name

2007-02-05 Thread Andy Shellam (Mailing Lists)
Is this still present in the latest version of PgAdmin? v1.6.2 is the current stable version. Regards, Andy. O'Shea, Brendan wrote: This is a bug in the graphical explain plan in the pgAdmin III Query tool. In the graphical explain plan if your query is ordering with the help of an index a

Re: [pgadmin-support] My SQL pane has gone

2007-02-05 Thread Andy Shellam (Mailing Lists)
Dave Page wrote: Andy Shellam (Mailing Lists) wrote: Ezequias Rodrigues da Rocha wrote: No way. I was trying this many times but notting of it appears. It depends where it was when you closed it, when you use the menu option it puts it back where it was when it was closed. Have

Re: [pgadmin-support] My SQL pane has gone

2007-02-05 Thread Andy Shellam (Mailing Lists)
Ezequias Rodrigues da Rocha wrote: No way. I was trying this many times but notting of it appears. It depends where it was when you closed it, when you use the menu option it puts it back where it was when it was closed. Have you got two monitors - could it be beyond the borders of your monit

Re: [pgadmin-support] My SQL pane has gone

2007-02-05 Thread Andy Shellam (Mailing Lists)
View menu -> Sql Pane?? Ezequias Rodrigues da Rocha wrote: Hi list, My sql pane dessapears when I did a drag and drop in some way. Now it does not appears anymore. Any suggestion would be great. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Re: [pgadmin-support] Issues with roles

2007-01-26 Thread Andy Shellam (Mailing Lists)
Dave Page wrote: Andy Shellam (Mailing Lists) wrote: Andy Shellam (Mailing Lists) wrote: A couple of niggly little issues with the roles in PgAdmin 1.6.2 on an 8.2.1 server. When you click Login/Group Roles in the object explorer, you cannot right-click and do "new role" like yo

Re: [pgadmin-support] Issues with roles

2007-01-25 Thread Andy Shellam (Mailing Lists)
Andy Shellam (Mailing Lists) wrote: A couple of niggly little issues with the roles in PgAdmin 1.6.2 on an 8.2.1 server. When you click Login/Group Roles in the object explorer, you cannot right-click and do "new role" like you can with Databases and Tablespaces. Also the "New

[pgadmin-support] Issues with roles

2007-01-25 Thread Andy Shellam (Mailing Lists)
A couple of niggly little issues with the roles in PgAdmin 1.6.2 on an 8.2.1 server. When you click Login/Group Roles in the object explorer, you cannot right-click and do "new role" like you can with Databases and Tablespaces. Also the "New object of this type" button is not enabled when you c

Re: [pgadmin-support] Positioning the panes

2007-01-22 Thread Andy Shellam (Mailing Lists)
Hehe yep that's quite funny. You reminded me that's how I had mine setup in the 1.4 days (I thought something looked different!), so I had a go at re-doing, if you haven't worked it out: - Drag the SQL pane out so it's "floating" - Drag the object explorer pane out so it's "floating", and you

Re: [pgadmin-support] Cannot connect to one specific postgres database

2007-01-22 Thread Andy Shellam (Mailing Lists)
port per database, which is by no means ideal. Regards Andy. -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 c

Re: [pgadmin-support] Cannot connect to one specific postgres database

2007-01-22 Thread Andy Shellam (Mailing Lists)
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 goin

Re: [pgadmin-support] Cannot connect to one specific postgres database

2007-01-22 Thread Andy Shellam (Mailing Lists)
Can you connect to it OK using psql on the server's console? If you can, try dumping the database using pg_dump, then restore it as a different database and try connecting via PgAdmin to the new copy. Matt Busby wrote: Hello, I am having trouble connecting to one specific database on my ser

Re: [pgadmin-support] installing pgAdmin3 1.6.2 on FC6

2007-01-22 Thread Andy Shellam (Mailing Lists)
Willy-Bas Loos wrote: Ok thanks, guess i missed that one :x So after i upgraded wxWidgets, it says i need to upgrade to libpq.so.5. But i can't upgrade, because all kinds of software (i.e. postgresql-contrib) still depends on libpq.so.4 , because i'm running PostgreSQL 8.1.6 It's not necesarr

Re: [pgadmin-support] COPY my_table FROM STDIN

2007-01-17 Thread Andy Shellam (Mailing Lists)
If you have the data already in a text file, you can upload the text file to the server, then run "COPY FROM " from within PgAdmin, but if you have psql access, then use that as it's much less hassle. Dave Page wrote: Laurent ROCHE wrote: Hi, I am trying to run a COPY my_table FROM

Re: [pgadmin-support] v.1.6.2: issue with truncated column comments.

2007-01-09 Thread Andy Shellam (Mailing Lists)
I prefer '...' to be honest. Personally I prefer a mix of the two suggestions " ..." (space then three dots) lol but that's just me :) -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" ---(end of broadcast)

Re: [pgadmin-support] View all rows not updated properly if program

2006-12-29 Thread Andy Shellam (Mailing Lists)
Guy Rouillier wrote: I'm using PgAdmin 1.6.1 against PG 8.2.0, both running on Windows XP. I have a test Java program that inserts and deletes rows into a single table; I vary the operation of the program by commenting out various parts. Before running the program, I open a view window on thi

Re: [pgadmin-support] [ADMIN] DB problem

2006-12-26 Thread Andy Shellam (Mailing Lists)
Vinayak, Please don't post twice to two different lists (four of the same posts to both pgsql-admin and pgadmin-support.) This clearly isn't a problem with PG Admin - so don't clutter that list up, and don't multiple-post - it won't change anything posting twice, and if anything you'll only en

Re: [pgadmin-support] 1.6.1 and 1.7.0 rendering bug

2006-12-23 Thread Andy Shellam (Mailing Lists)
FYI, This works fine on 1.6.1 on Windows XP - no problem. Regards, Andy. Clodoaldo wrote: When a function is selected in the object browser the function's create script is shown in the properties tab meshed with the properties values. This happens in both 1.6.1 and 1.7.0 with wxGTK 2.8.0. It

Re: Re : [pgadmin-support] No text for error messages only numbers

2006-12-19 Thread Andy Shellam (Mailing Lists)
I still can't reproduce it. My databases are also in UTF-8. Some are in LATIN1. I tried with en and fr pgAdmin. I have no problem. But I'm using 1.6.2. Perhaps Dave already fixed it ? Regards. I was wondering - where are you using 1.6.2 from? There's a serious bug in 1.6.1 where you cannot

Re: Re : Re : Re : [pgadmin-support] No text for error messages only

2006-12-14 Thread Andy Shellam (Mailing Lists)
(I have read the the particulary annoying bug of empty tables not being editable is fixed in 1.6.2) Excellent, I'll be looking forward to that! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" ---(end of broadcast)-

[pgadmin-support] Empty tables show no field headings

2006-12-12 Thread Andy Shellam (Mailing Lists)
Hi, I've just joined this list. In v1.6.1, when I go to view the data for a table with no (zero) rows, I don't see the columns of the table and no place to key a new record. The table does have a primary key, and when it's got rows in, I can edit and add new ones. Steps to reproduce: - Open