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 ).
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 "
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
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
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
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
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
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
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
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
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
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
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
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
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.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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
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
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
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
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
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
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
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
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
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)
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
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
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
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
(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)-
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
31 matches
Mail list logo