Re: [pgadmin-support] Issues with query window

2016-10-24 Thread Josh Berkus
On 10/23/2016 11:13 PM, Murtuza Zabuawala wrote: > > > -- > Regards, > Murtuza Zabuawala > EnterpriseDB: http://www.enterprisedb.com <http://www.enterprisedb.com/> > The Enterprise PostgreSQL Company > > On Mon, Oct 24, 2016 at 10:12 AM, Josh Berkus

[pgadmin-support] Issues with query window

2016-10-23 Thread Josh Berkus
49 -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Pgadmin 4 view and sort table

2016-10-23 Thread Josh Berkus
* by query, with order by the >> primary key. This is all greyed out and unable to be modified. How >> do you resort a table? At this point? Add "ORDER BY column" to the query. -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] pgAdmin4 Server does not create SQLite tables

2016-10-23 Thread Josh Berkus
On 10/11/2016 01:47 PM, Dave Page wrote: > > > On Tuesday, October 11, 2016, Josh Berkus <mailto:j...@agliodbs.com>> wrote: > Ah, so I can drop a path into config_local? > > > Yes, per the example I sent yesterday. config_local.py (and > config_di

Re: [pgadmin-support] pgAdmin4 Server does not create SQLite tables

2016-10-11 Thread Josh Berkus
On 10/10/2016 10:50 PM, Dave Page wrote: > > > On Monday, October 10, 2016, Josh Berkus <mailto:j...@agliodbs.com>> wrote: > One thing which would improve this is to have setup.py take an optional > --directory argument. > > > How so? It gets the p

Re: [pgadmin-support] pgAdmin4 Server does not create SQLite tables

2016-10-10 Thread Josh Berkus
d improve this is to have setup.py take an optional --directory argument. -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] pgAdmin4 Server does not create SQLite tables

2016-10-10 Thread Josh Berkus
On 10/10/2016 08:31 PM, Dave Page wrote: > > > On Sunday, October 9, 2016, Josh Berkus <mailto:j...@agliodbs.com>> wrote: > > On 10/09/2016 05:04 PM, Josh Berkus wrote: > > sqlite> select * from ConfigDB; > > Error: no such table: ConfigDB &g

Re: [pgadmin-support] pgAdmin4-web install issues WAS: PgAdmin4 is not usable when installed from RPMs on Fedora linux

2016-10-10 Thread Josh Berkus
On 10/10/2016 11:26 AM, Magnus Hagander wrote: > On Mon, Oct 10, 2016 at 6:57 PM, Josh Berkus And you'd need the SELinux perms even if it was in /var/lib/, because of > the nologin status of the Apache user. > > > Yes, but /var/lib is supposed to be for persist

Re: [pgadmin-support] pgAdmin4-web install issues WAS: PgAdmin4 is not usable when installed from RPMs on Fedora linux

2016-10-10 Thread Josh Berkus
On 10/10/2016 03:36 AM, Magnus Hagander wrote: > > > On Mon, Oct 10, 2016 at 2:26 AM, Josh Berkus <mailto:j...@agliodbs.com>> wrote: > > On 10/09/2016 04:36 PM, Josh Berkus wrote: > > I'll confirm here that the Web version doesn't work either f

Re: [pgadmin-support] pgAdmin4-web install issues WAS: PgAdmin4 is not usable when installed from RPMs on Fedora linux

2016-10-09 Thread Josh Berkus
On 10/09/2016 04:36 PM, Josh Berkus wrote: > I'll confirm here that the Web version doesn't work either from the > Fedora packages. In the case of the web version, this appears to be > because of confusion between Python2 and Python3 dependencies. Leaving out the SQLite bu

Re: [pgadmin-support] pgAdmin4 Server does not create SQLite tables

2016-10-09 Thread Josh Berkus
On 10/09/2016 05:04 PM, Josh Berkus wrote: > sqlite> select * from ConfigDB; > Error: no such table: ConfigDB More relevantly: sqlite> select * from version; Error: no such table: version -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgadmin-support

[pgadmin-support] pgAdmin4 Server does not create SQLite tables

2016-10-09 Thread Josh Berkus
it. Or just not being executed. pgadmin4 1.0, installed on Fedora24, from yum.postgresql.org packages. Being used as the sole web application under httpd. -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.o

Re: [pgadmin-support] PgAdmin4 is not usable when installed from RPMs on Fedora linux

2016-10-09 Thread Josh Berkus
rface in the browser, which I don't > want to do. And none of the workarounds described above should be > necessary anyway: I would've expected that after installing the RPM I'd > have an application that works out of the box. > > best regards, > Peter Juhasz > > > -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] greenplum question

2015-08-05 Thread Josh Berkus
0083628-Pivotal-Greenplum-DB-Forum If you are on PostgreSQL, I suggest the pgsql-novice mailing list: http://www.postgresql.org/list/ -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your sub

Re: [pgadmin-support] pgagent hangs forever in "r" state

2015-07-22 Thread Josh Berkus
nning fine without any problem. > Hence the issue is not reproducible on my system. > > Josh, > > As we're unable to reproduce the issue at our end, can you please > generate the logs after setting the log level to debug2 (i.e. -l2) for > analyzing the issue? As I said

Re: [pgadmin-support] pgagent hangs forever in "r" state

2015-07-20 Thread Josh Berkus
oesn't the insert error appear in the pgAgent log? > > 2) Can you reproduce Josh's issue where the first step in a job runs, > but the second doesn't (without touching the sequences)? Particularly, *after* the sequence errors are fixed, do the jobs now run normally? --

Re: [pgadmin-support] pgagent hangs forever in "r" state

2015-07-10 Thread Josh Berkus
particular user has now abandoned pgagent and is switching to centrally managed cron, so my ability to get further troubleshooting information will be limited. According to apt-get, this is the latest pgagent package. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent

Re: [pgadmin-support] pgagent errors on application_name

2015-07-07 Thread Josh Berkus
On 07/06/2015 08:52 PM, Ashesh Vashi wrote: > Hi Josh, > > On Mon, Jul 6, 2015 at 11:55 PM, Josh Berkus <mailto:j...@agliodbs.com>> wrote: > > To wit: > > postgres@9c7b33848038:~$ pgagent -l pgagent.log -f dbname=postgres > user=postgres app

Re: [pgadmin-support] Vacuum full hanging

2015-07-06 Thread Josh Berkus
mation, in > that mode as well it hangs after printing few lines. Can you give us the output? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] pgagent hangs forever in "r" state

2015-07-06 Thread Josh Berkus
On 07/06/2015 10:26 AM, Josh Berkus wrote: > All, > > On the same server with the SQL errors (sequences are cleaned up now), > we're having pgagent start all jobs in the "r" state, log the first step > in each job in the "r" state, and then hang forever (

[pgadmin-support] pgagent errors on application_name

2015-07-06 Thread Josh Berkus
(Device or resource busy). I'm unclear on why this would be failing, though; AFAICT, connection.h doesn't do anything but wrap the basic libpq connection class. Ideas? BTW, when we fix this, I'd like to set a default application_name of "pgagent" if the user does not supp

Re: [pgadmin-support] pgagent DEB packages do not support postgres 9.4

2015-07-06 Thread Josh Berkus
On 07/05/2015 10:27 PM, Josh Berkus wrote: > On 07/05/2015 01:38 PM, Christoph Berg wrote: >> pgagent had not been rebuilt for quite a while which is why it didn't >> have 9.4 (and jessie) support yet. Fixed now: > > Thanks! Oh, also, tested and verified. New package

[pgadmin-support] pgagent hangs forever in "r" state

2015-07-06 Thread Josh Berkus
obs are in "r" state. In pg_stat_activity, pgagent is connected, but hasn't run anything except the query to get the next step. We're debugging away, but would appreciate advice on other ways to figure out what pgagent is doing. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.co

Re: [pgadmin-support] pgagent DEB packages do not support postgres 9.4

2015-07-05 Thread Josh Berkus
On 07/05/2015 01:38 PM, Christoph Berg wrote: > pgagent had not been rebuilt for quite a while which is why it didn't > have 9.4 (and jessie) support yet. Fixed now: Thanks! -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgad

[pgadmin-support] Request: pgagent --version

2015-07-04 Thread Josh Berkus
All: Currently pgagent does not have a --version option so that a DBA can check what version of pgagent is installed. It would be good to have one. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make

Re: [pgadmin-support] pgagent DEB packages do not support postgres 9.4

2015-07-04 Thread Josh Berkus
On 07/03/2015 01:05 AM, Dave Page wrote: >> > ... maybe it's time we had pgagent-#.# packages instead? > I don't know who maintains these packages. It's certainly not the > pgAdmin/pgAgent team. That's why I cc'd Christoph. -- Josh Berkus PostgreSQL Expe

[pgadmin-support] Please add timestamps to pgagent log

2015-07-04 Thread Josh Berkus
Request: pgagent's output log current does not include timestamps. That makes it fairly hard to debug anything based on the log. Can we add a timestamp to the beginning of each log line? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing

[pgadmin-support] Bug: pgagent doesn't log SQL errors

2015-07-04 Thread Josh Berkus
in the Postgres log. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] where should I file pgagent bugs?

2015-07-02 Thread Josh Berkus
Folks, I've a bunch of bugs in pgagent to file. Should I post them all here? Or somewhere else? It doesn't look like anyone uses the github issue tracker. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@post

[pgadmin-support] pgagent DEB packages do not support postgres 9.4

2015-07-02 Thread Josh Berkus
sion/pgagent.control ./usr/share/postgresql/9.2/extension/pgagent.control ... maybe it's time we had pgagent-#.# packages instead? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes t

Re: [pgadmin-support] Urgent help!

2013-11-11 Thread Josh Berkus
Anton, > I try to install to Holdem Manager 2 and it install PostgreSQL,create a new > user and block my access to disk c ! Contact Holdem Manager for support. This mailing list is for the pgAdmin database administration tool. -- Josh Berkus PostgreSQL Experts Inc. http://pgexper

Re: [pgadmin-support] Server mess

2013-09-30 Thread Josh Berkus
s the list for pgAdmin3, the GUI client for PostgreSQL. I suggest asking on one of these lists instead: pgsql-general pgsql-admin pgsql-novice Good luck! -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To m

Re: [pgadmin-support] DATA TRANSFER SPEED

2012-12-22 Thread Josh Berkus
And how can I do this. How are you transferring data exactly? What kind of data? If you're looking for a fast way to copy tables, I'd recommend using COPY plus some scripting. pgAdmin is meant to be user-friendly, not high-throughput. -- Josh Berkus PostgreSQL Experts Inc. http://pg

[pgadmin-support] pgAdmin object tree still breaks on reconnect to DB

2012-02-22 Thread Josh Berkus
an only be browsed again if you shut down pgadmin and restart it. Otherwise, it remains invisible. Good luck with this one ... -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscrip

Re: [pgadmin-support] Re: Bug - Rows in Query Output pane fail to grow in height when font size preference size is larger

2011-10-26 Thread Josh Berkus
> It also happens on Linux. Now fixed. Thanks :) Is there somewhere I could download a snapshot for OSX? I have some demos later this month and would love to be able to enlarge the text a bit. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mail

Re: [pgadmin-support] Ad-hoc increasing size of data results grid?

2011-09-14 Thread Josh Berkus
e is still set for 10-point type, making the grid impossible to read. I guess I'm still doing my demos with psql ... -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription:

Re: [pgadmin-support] Ad-hoc increasing size of data results grid?

2011-09-06 Thread Josh Berkus
On 9/6/11 6:17 PM, Fernando Hevia wrote: > You can change the font size from: File->Options->Query Tool->Font menu. That only changes the font size in the query text window, not in the results grid. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pga

[pgadmin-support] Ad-hoc increasing size of data results grid?

2011-09-06 Thread Josh Berkus
Folks, I'm going to be doing a demo, on video, using pgadmin tommorrow night. Is there any way, even on an ad-hoc basis, I could increase the size of the text in the query results? The text is generally too tiny to be seen by the audience. This is on Mac. -- Josh Berkus PostgreSQL Expert

[pgadmin-support] Feature request: autosave for Query Tool

2011-08-26 Thread Josh Berkus
unexpectedly is a fact of life. Ones related to saved files would be saved to their files, and unnamed windows would be saved to /tmp/. I'd picture a single preferences setting, which would set the autosave interval in minutes. -- Josh Berkus PostgreSQL Experts Inc. http://pgexpert

Re: [pgadmin-support] pgadmin and broken connections

2011-07-18 Thread Josh Berkus
h to the hackers list: > http://archives.postgresql.org/pgadmin-hackers/2011-07/msg00267.php OK, I don't have the kit to compile this on OSX, so I'll test it once you have a downloadable package. FWIW, I'd be OK with waiting until 1.15 to fix this. You need to get 1.14 out s

Re: [pgadmin-support] pgadmin and broken connections

2011-07-12 Thread Josh Berkus
Note that pgadmin stays up until I make the mistake of clicking on the object browser. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] pgadmin and broken connections

2011-07-11 Thread Josh Berkus
On 7/11/11 12:09 PM, Josh Berkus wrote: > Dave, Guillaume, > > I've tested 1.14b2 on OSX 10.5 and reconnecting now works perfectly. It > even worked after I put the laptop to sleep and changed networks and > then reconnected the VPN. Booo. I spoke too soon. While re

Re: [pgadmin-support] pgadmin and broken connections

2011-07-11 Thread Josh Berkus
Dave, Guillaume, I've tested 1.14b2 on OSX 10.5 and reconnecting now works perfectly. It even worked after I put the laptop to sleep and changed networks and then reconnected the VPN. Yy! -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support ma

Re: [pgadmin-support] 1.14b1 doesn't do OSX alerts

2011-07-05 Thread Josh Berkus
> Spent a couple of hours(!) trying to figure this out, and no joy so > far. It appears that wxTopLevelWindow::IsActive() doesn't work when > wxAuiNotebooks are in use, but I haven't figured out why yet. Odd, it worked perfectly in 1.12. Well, it worked OK. -- Josh Berkus

[pgadmin-support] 1.14b1 doesn't do OSX alerts

2011-06-30 Thread Josh Berkus
Dave, Minor issue with 1.14b1 (compared to the crashing): when a query completes, 1.14b1 no longer alerts me by having the pgadmin icon bounce in the Dock. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To

Re: [pgadmin-support] pgadmin and broken connections

2011-06-30 Thread Josh Berkus
On 6/30/11 9:49 AM, Josh Berkus wrote: > >> Also there seems to be some confusion over the versions of pgAdmin >> affected. 1.14 has improvements over 1.12 - which are you using Josh? > > 1.12. Let me try upgrading, and I'll report back. Well, I can't tell

Re: [pgadmin-support] pgadmin and broken connections

2011-06-30 Thread Josh Berkus
> Also there seems to be some confusion over the versions of pgAdmin > affected. 1.14 has improvements over 1.12 - which are you using Josh? 1.12. Let me try upgrading, and I'll report back. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support m

Re: [pgadmin-support] pgadmin and broken connections

2011-06-29 Thread Josh Berkus
On 6/29/11 1:10 PM, Josh Berkus wrote: > all. If my connection was over a VPN, and the VPN, and I log back in, "... and the VPN kicks me off ... " -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql

[pgadmin-support] pgadmin and broken connections

2011-06-29 Thread Josh Berkus
t database except by shutting down pgadmin completely and restarting it. Is this an issue which is common to all platforms? Or an OSX-specific issue? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make

[pgadmin-support] Issues with large message / history buffers

2011-01-16 Thread Josh Berkus
of output. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.post

Re: [pgadmin-support] Minor UI issues for Server Properties dialog box

2011-01-15 Thread Josh Berkus
> Dave already fixed it. It will be available in 1.14. Great. Glad to hear it! -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgadmin-support mail

[pgadmin-support] Minor UI issues for Server Properties dialog box

2011-01-15 Thread Josh Berkus
n prevents you from changing those fields unless you are disconnected from the server in the first place. 2) Changes to server properties are not saved until the user shuts down pgAdmin. This means that in the event of a crash all server property changes are lost. --

Re: [pgadmin-support] [ADMIN] syntax error for no apparent reason

2010-12-03 Thread Josh Berkus
dows > installation on my laptop and move files around. Yeah, this is caused by pgadmin adding a unicode marker at the first position of the file. If you uncheck "Read and Write Unicode UTF-8 Files" in the preferences, this issue should go away. --

Re: [pgadmin-support] Making SQL-pane $$ aware?

2010-10-22 Thread Josh Berkus
> What on earth did you do to it? Just installed the 9.0 compatible version from packages. Pretty sure I downloaded this while 9.0 was in RC. -- -- Josh Berkus PostgreSQL Experts

Re: [pgadmin-support] Making SQL-pane $$ aware?

2010-10-22 Thread Josh Berkus
> I thought Guillaume had fixed it. Is it still borked? It is in my OSX version. Not sure what version I have installed, because "About" is broken. -- -- Josh Berkus PostgreSQ

Re: [pgadmin-support] Making SQL-pane $$ aware?

2010-10-22 Thread Josh Berkus
gt; I have zero time for it unfortunately. OK. I don't think it's as valuable as other stuff people could be working on. Like fixing the database selector, for example. ;-) -- -- Josh Berkus

[pgadmin-support] Making SQL-pane $$ aware?

2010-10-22 Thread Josh Berkus
Guys, How tricky would it be to make the SQL pane aware of $$ escaping for text highlighting? Hmm. Now that I think of it, it would be good to turn this on and off. The current lack of awareness actually makes it easier to compose SPs. -- -- Josh Berkus

Re: [pgadmin-support] Increasing size of results grid

2010-10-19 Thread Josh Berkus
> Josh - which font setting did you expect to work here? I'd prefer the SQL query window font setting, unless we had a specific "grid" font setting. I don't want to increase the size of all my object labels in order to displa

Re: [pgadmin-support] Increasing size of results grid

2010-10-12 Thread Josh Berkus
> Thats what I thought, but I tested it on Mac and found it didn't work. > wxMac bug? Doesn't work on my Mac either. Did not check it on Linux. -- -- Josh Berkus Postgr

[pgadmin-support] Increasing size of results grid

2010-10-11 Thread Josh Berkus
size, I suppose)? -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your sub

Re: [pgadmin-support] Copying a database

2010-08-12 Thread Josh Berkus
se with a new name. > 3. Restore the backup to the new, empty database? That's pretty much it, yes. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent v

Re: [pgadmin-support] Server status

2010-08-10 Thread Josh Berkus
er. Have a superuser create a SECURITY DEFINER function on the master. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgadmin-support mailing list (pgad

[pgadmin-support] [Fwd: [TESTERS] pgAdmin 1.12.0 Beta 3 - Error viewing Server-Status]

2010-07-13 Thread Josh Berkus
– UTF8 pgAdmin => “Werkzeuge“ => „Server-Status“ throws: “Ein Fehler ist aufgetreten: FEHLER: ungültige Byte-Sequenz für Kodierung >>UTF8<<:0xf668656e Stefan Wolf -- -- Josh Berkus Post

Re: [pgadmin-support] Request: get rid of annoyance with new SQL window

2010-03-19 Thread Josh Berkus
I deleted that file several times. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make c

Re: [pgadmin-support] Request: get rid of annoyance with new SQL window

2010-03-19 Thread Josh Berkus
> That behaviour hasn't changed in years. It sounds like you turned on > the 'Copy SQL from main for to query tool' option. I didn't do it manually; somehow it got set to that when I upgraded. Thanks for the option, turned off now. --

[pgadmin-support] Request: get rid of annoyance with new SQL window

2010-03-19 Thread Josh Berkus
as changed. Do you want to save the changes?" This is annoying and unnecessary; when I click the SQL button, I should get a *blank* query window, as I used to in 1.10.0. I should only get the object definition if I select "Scripts" from the context menu. --

Re: [pgadmin-support] pgAdmin Graphical Query Tool Crashes on Mac

2010-03-19 Thread Josh Berkus
y xWindows, but who knows. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make chang

Re: [pgadmin-support] Bug: title bar goes away

2010-03-15 Thread Josh Berkus
ck my wxWindows version on Mac? -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.p

[pgadmin-support] Bug: recent files reset

2010-03-15 Thread Josh Berkus
for query #5 will not show this change until *after* you attempt to access a file from that list, which is why it gives you the wrong file. -- -- Josh Berkus PostgreSQL Experts Inc.

Re: [pgadmin-support] Installing debugger?

2010-03-12 Thread Josh Berkus
st say that it won't build without hackery at this point. --Josh -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Installing debugger?

2010-03-11 Thread Josh Berkus
orth just saying in the docs that the debugger currently isn't supported except on EDB and One-Click installs. Having gone to some trouble to get it installed, however, I find that the "debugging" option on the pgadmin menu is still greyed out and inaccessible. What is pgAdmin loo

Re: [pgadmin-support] How to use SSH tunnels with pgAdmin?

2010-03-11 Thread Josh Berkus
Any network flakiness would affect it equally. Unless the connections are being dropped for some other reason? --Josh Berkus -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] regarding postgreSQL installation issue

2010-03-11 Thread Josh Berkus
Yuvaraj, > I am facing one problem while installing postgreSQL – Stack Builder > 2.0.0 (please see the below screenshot). > > Even I had checked the firewall settings, there was no blocking. Have you verified that you can reach that URL from your computer? --Josh Berkus -- Sent

[pgadmin-support] Installing debugger?

2010-03-10 Thread Josh Berkus
. does the debugger even still work? And if it does, how do I install it on an RHEL system with 8.4.2 RPM installed? --Josh -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Bug: title bar goes away

2010-03-03 Thread Josh Berkus
On 3/3/10 11:28 AM, Dave Page wrote: > Sorry - i meant does the problem go away if u remove just that line > (or any other) rather than the whole file? Yes, it does. --Josh Berkus -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscr

Re: [pgadmin-support] Bug: title bar goes away

2010-03-03 Thread Josh Berkus
Dave, Oh, one more thing which might bear on this: this particular machine is frequently connected and disconnected to a 2nd monitor while pgAdmin is running. However, there is not a direct cause-and-effect sequence there; last time I lost the title bar, pgadmin was not running. --Josh Berkus

Re: [pgadmin-support] Bug: title bar goes away

2010-03-03 Thread Josh Berkus
> Never seen that myself, despite a Mac being my primary machine. Can > you narrow down what setting(s) are causing it? I would imagine it's > something in the frmMain section of the file. I'd start with the > Perspective string. I don't know this data well enough to diagnose it, so here it is:

[pgadmin-support] Bug: title bar goes away

2010-03-02 Thread Josh Berkus
cure this seems to be to wipe out my pgadmin profile, and start over. As you can imagine, this is annoying. Not sure if this is wxwindows or pgadmin, but the fact that I can fix it by deleting the configuration profile suggests the latter. Platform is OSX 10.5. Version 1.10.1 --Josh Ber

Re: [pgadmin-support] Feature request : Reindentation of code

2010-03-02 Thread Josh Berkus
lic list. You'll never get anything done. ;-) (serious suggestion: use the indenting rules outlined in Celko's book) --Josh Berkus -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Feature request : Reindentation of code

2010-03-02 Thread Josh Berkus
y tools have this feature, and not pgadmin >> III. > > That might make a nice GSoC project... +1. You wanna volunteer as a GSoC mentor? --Josh Berkus -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] How to use SSH tunnels with pgAdmin?

2010-02-28 Thread Josh Berkus
> The connections aren't being dropped when I work with my other PG tool, PG > Lightning Admin, which does use SSH tunnels. In that case: http://oldsite.precedence.co.uk/nc/putty.html --Josh Berkus -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To m

[pgadmin-support] How to have 2 connections, same server, different user?

2010-02-26 Thread Josh Berkus
as a different user (say, db_admin:5488) to the same database. I think this is probably simply a deficiency in the connection selector in the SQL window, which only displays IP:Port instead of the list of named connections available in the main console. Can anyone suggest a workaround? --Josh B

[pgadmin-support] Feature Request: save all windows

2010-02-24 Thread Josh Berkus
Here's an easier one: I'd like a menu item to save all open query windows. Currently if I have 10 or 11 windows open, I have to go through, saving them one at a time. --Josh Berkus -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your su

[pgadmin-support] Feature Request: change size of text in query result grid

2010-02-24 Thread Josh Berkus
. Probably too painful to contemplate with wxWindows, but I thought I'd put it out there in case it wasn't. --Josh Berkus -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Garbage character inserted at the beginning of every SQL file on OSX

2010-02-18 Thread Josh Berkus
On 2/17/10 2:52 PM, Josh Berkus wrote: >> It's not garbage, it's a Unicode BOM. >> >> If your other software cannot read Unicode files properly, you can >> turn off Unicode file writing under File -> Options. > > psql is apparently unhappy with the

Re: [pgadmin-support] Garbage character inserted at the beginning of every SQL file on OSX

2010-02-18 Thread Josh Berkus
On 2/18/10 1:20 PM, Dave Page wrote: > On Thu, Feb 18, 2010 at 9:06 PM, Josh Berkus wrote: >> On 2/17/10 2:52 PM, Josh Berkus wrote: >>>> It's not garbage, it's a Unicode BOM. >>>> >>>> If your other software cannot read Unicode files pro

Re: [pgadmin-support] Garbage character inserted at the beginning of every SQL file on OSX

2010-02-17 Thread Josh Berkus
it does, that should go in the FAQ. --Josh Berkus -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Garbage character inserted at the beginning of every SQL file on OSX

2010-02-17 Thread Josh Berkus
ystem. --Josh Berkus -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Postgres on Linux - was 'Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views'

2008-03-11 Thread Josh
Which Linux distro's support Postgres releases the best? Which are best suited in a server vs. development suite of tools? Andrew, I've always had excellent luck with CentOS, which is a clone of RedHat Enterprise Linux. The RPM's for RHEL that you find on the Postgres website drop right in

[pgadmin-support] NewB question wrt Create Database

2008-02-03 Thread Josh
Howdy All, I have a question about the behavior of PGAdmin (or perhaps this is PG) in creating databases. If I create a DB while logged in as postgres, and indicate the database owner is another login role, then PG creates the database with that login role being the owner but everything wit

Re: [pgadmin-support] Can't compile from source on CentOS 5

2007-07-01 Thread Josh
Ed, Elsewhere on this list people have recommended the FC6 versions of wxWidgets and PGAdmin. That should work; but personally, I compiled wxWidgets 2.6.4 just fine (as the 2.6.3 RPM's available for FC6 aren't the latest - 2.6.4 has some bugfixes) and I was able to compile and run PGAdmin 1

Re: [pgadmin-support] Binaries of PGAdmin3 for RHEL5

2007-06-12 Thread Josh
Use Fedora 6 RPMs that are at our FTP site. They are working on RHEL 5. No need to build a seperate one. Devrim, A few things I noticed while perusing these packages. Let me know if I'm looking in the wrong place (pgadmin.org download page): 1. The latest binary is 1.6.2; how important ar

[pgadmin-support] Binaries of PGAdmin3 for RHEL5

2007-06-12 Thread Josh
Hello, If anyone would like to beta test a binary of PGAdmin 1.6.3, for RHEL5-32, please drop me a line. I'm in the process of setting up an online repository for the RPM's but I can put them up in a day or so for people to download. Thanks, -J ---(end of broadcast

Re: [pgadmin-support] connection dropping continued

2004-02-17 Thread Josh Endries
seems more network-related, but a keep-alive option, possibly with user-definable SQL statement or something, would be nice to have (would help troubleshoot problems at least). Josh ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings