I would like more to why your computer shows 19010 as the year, as
that's a completely invalid date. I don't think Windows currently
handles years after 2099.
I don't know what the developers think, but I think this is a problem
outside of the developer's control.
Andy.
Ezequias Rodrigues
Hi,
In the Preferences options, there's an option on the Query tab that says
"Maximum rows to retrieve." This is currently set to 100, but I can't
see how/where it takes effect.
I have a table that's growing an average of 250 rows a day (currently at
1098 rows.) If I select the table, and
Dave Page wrote:
Ideally what I'd like is to set the default rows to retrieve to 1000, so
it downloads the first 1000 rows when I open the table, and then I can
choose to retrieve others if I need to.
I'd love to! But I'm afraid I don't know C/C++ programming, and have
never done anyth
Hi Mark,
Are the options there, just disabled? Or not there at all?
You say you're missing the "table backup/restore" - you mean when you
right-click on a table? Are the options there at the database level?
IIRC I had it where the backup/restore were disabled in Fedora Core 5,
and it was be
*OP's original e-mail forwarded to list*
Original Message
Subject:Re: [pgadmin-support] No backup/restore for Linux?
Date: Thu, 29 Mar 2007 17:20:14 -0500
From: Mark Williamson <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
References:
<[EMAIL PROTECTED]>
<[EMAIL PR
Also from the machine you tried the ping from, do telnet
5432 - see if that connects.
Something's definitely not quite correct on the server-side.
Check any firewalls (particularly the Windows Firewall if running an XP
SP2 or 2003 client machine.)
Andy
Raymond O'Donnell wrote:
On 18/04/200
)
Andy.
George Heller wrote:
Hi,
I tried a telnet, and it doesnt work. So atleast now I know there is
something wrong with the server side, but I dont quite know what to do
next. Any suggestions?
Is there some particular setup that needs to be done? I have disabled
the Windows Firewall
|
mail -s "Alert: Almost out of disk space $usep%" [EMAIL PROTECTED]
fi
done
Please help if you can.
Thanks ~ Trula
*/Andy Shellam <[EMAIL PROTECTED]>/* wrote:
I think you need to provide more information on what you're trying to
do, and the version of Pos
rward to getting around
this problem!
Thanks!
George
*/Andy Shellam <[EMAIL PROTECTED]>/* wrote:
Hi George,
From the server's console, do "telnet 5432."
Make sure to use the server's remote IP, not localhost. If
that fails,
Hi George,
OK the fact you cannot telnet from your XP machine to the server's
PostgreSQL port now suggests it's a problem getting to the server port.
Checking for the existence of a firewall is an ambiguous question I'm
afraid! There's not only the case of if there's a software firewall,
but
ied logging into PgAdmin using localhost, but it gave me the
same error as before, only this time it said ip address 127.0.0.1
Thanks.
George.
*/Andy Shellam <[EMAIL PROTECTED]>/* wrote:
Hi George,
OK the fact you cannot telnet from your XP machine to the server's
Po
gone, I
make the changes again, and try to log in using 'localhost' this
time, it says Connection refused.
I also tried logging into PgAdmin using localhost, but it gave me
the same error as before, only this time it said ip address 127.0.0.1
Thanks.
Joris Dobbelsteen wrote:
-Original Message-
From: Andy Shellam [mailto:[EMAIL PROTECTED]
Sent: woensdag 25 april 2007 21:25
To: Joris Dobbelsteen
Cc: George Heller; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Server not listening
I concur, but just so you know I
Hi Dave,
A quick suggestion for PgAdmin's "Restore database" dialog.
When you restore a database, you select your file and options, then
click "OK" and the restore does it's thing and finishes, showing you the
output from pg_restore.
However the button stays as "OK". So you instinctively cli
Yep I agree, with pg_restore, warnings also generate a non-zero return
code, but the restore does complete successfully, so this is mis-leading.
An example is "language already exists" - pg_restore just throws a
warning to let you know this, but the restore is successful.
Perhaps what might wo
That's great Dave, I'm sure it'll please many folks!!
Thanks
Andy.
Dave Page wrote:
Andy Shellam wrote:
Yep I agree, with pg_restore, warnings also generate a non-zero return
code, but the restore does complete successfully, so this is mis-leading.
An example is "lang
Hi team,
I've noticed a small bug in 1.8.1 on Windows XP (SP2).
If I create a new table, and add a new serial column to it before OK'ing the
"create table" dialog, the "sequence" drop-down remains disabled for the
column.
If I create a table, and OK the dialog without any columns in, then go bac
uses where you'd
want to!
Unless you can make the sequence combo of any use (e.g. to change the
default sequence used when creating the column) I'd say get rid of it!
Thanks,
Andy
On 1/14/08, Dave Page <[EMAIL PROTECTED]> wrote:
>
> On 14/01/2008, Guillaume Lelarge <[EMA
Hi Dave and team,
Another slight bug (I think):
I have a table which has a column called "first_invalid" which should be a
timestamp if the record is invalid, or NULL if it's valid.
In PgAdmin I have the "Show NULL values as " option enabled, but it
still displays a blank cell for this column.
T
Hi guys,
A bit more info.
If I write a query manually (i.e. SELECT * FROM table) then the column shows
up as "" which is what I expect.
However, if I write click the table and hit the "View Data" menu option, the
column is blank.
Andy.
On 1/14/08, Andy Shellam <[EMAIL PR
Hi Dave
Ah right OK, I didn't realise the "Query" tab was just for SQL editor, I
thought it was for the data entry grids as well.
Thanks for clearing that up.
> instead I had to do:
> >
> > "SELECT COALESCE(first_invalid, '1900-01-01') AS first_invalid FROM
> table"
> >
> > to prove the column
cified, to start the server. Is it
necessary
> to use the -i option so that my server can listen, or is the documentation
just
> too old? If yes, what is the syntax for the same?
>
> Thanks.
> George.
>
> Joris Dobbelsteen <[EMAIL PROTECTED]> wrote:
> >--
I presume you mean when you're creating a new connection?
If PostgreSQL is running on a Windows machine, this is the name of the service
it's running under. Should be left blank for Unix machines.
Account name? Do you mean username? This is a user that's been added to the
PostgreSQL server (or
Ah OK thanks for clearing that up.
Whenever I do a restore, it always warns that the plpgsql language is already
present, hence returns with code 1.
Thanks
Andy.
Dave Page <[EMAIL PROTECTED]> wrote:
> Andy Shellam wrote:
> > Hi Dave,
> >
> > A quick suggestion for
roduce:
- Open a table with data in
- Delete all rows
- Close the table
- Re-open - get blank screen with no columns or "new row" placeholder
This is on Windows XP, pgAdmin version 1.6.1, PostgreSQL 8.1.5 server.
Thanks,
--
Andy Shellam
NetServe Support Team
the Mail Network
"an
(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"
---(e
here you cannot key new rows into a
table that has a zero row-count, I've heard that's fixed in 1.6.2, but
it isn't out yet?
Thanks
--
Andy Shellam
NetServe Support Team
the Mail Network
"an alternative in a standardised world"
---(end of b
2.8.0. It did not
happen in 1.4.x with wxGTK 2.6.
As I think it is hard to visualize I took a screenshot (127 KB):
http://fahstats.com/img/pgadmin_bug.png
I'm using FC5 i386, wxGTK 2.8.0 and the Gnome desktop.
Regards,
--
Andy Shellam
NetServe Support Team
the Mail Network
"an a
-i -D /var/lib/pg
When you install the DB, the logs are enabled by default?
Would you pls tell me still what setting need to be done?
Thanks,
Vinayak V. Raikar
Extn : 143
!DSPAM:37,4590b56931941914011633!
--
Andy Shellam
NetServe Support Team
the Mail Network
"an altern
lumns/new row placeholder.)
--
Andy Shellam
NetServe Support Team
the Mail Network
"an alternative in a standardised world"
---(end of broadcast)---
TIP 6: explain analyze is your friend
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"
-
sql.org
!DSPAM:37,45addcd5137102060715345!
--
Andy Shellam
NetServe Support Team
the Mail Network
"an alternative in a standardised world"
p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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
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
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
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
to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
!DSPAM:37,45b531b2118214216076088!
--
Andy Shellam
NetServe Support Team
the Mail Network
"an alternative in a standardised world"
p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834
not enabled when you click
New group/login role - you have to add a new role by right-clicking the
server connection, New Object... New Group/Login Role.
Any chance of having this sorted for the next release?
Thanks,
--
Andy Shellam
NetServe Support Team
the Mail Network
"an alternativ
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
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
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.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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
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
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
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
communication is not followed by any binding agreement between the
parties.
---------
!DSPAM:37,45d42ea418518608311276!
--
Andy Shellam
NetServe Support Team
the Mail Network
"an alternative in a standardised world"
p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834
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
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
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
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
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
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
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
word.html
HOWEVER, it does not tell you how to get to the password.html page
within pgadmin. I've tried the web, clicking around in pgadmin, and
pgadmin help and silly me can't figure it out.
Can you help?
**r/**
**Randy Everette**
!DSPAM:37,45d7843c18514886615150!
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 ).
55 matches
Mail list logo
