[pgadmin-support] save location for queries

2015-07-22 Thread Joseph Montibello
Hi,

Is there a way to set a default path where my .sql query files should be saved 
and opened from? I keep all of them in a specific folder outside of the 
“Documents” folder and I’d like to be able to set it as a default.

I tried looking in PGAdmin3 > Preferences. I looked through Info.plist within 
the package itself using Finder, but didn’t see anything that looked relevant. 
I also looked through the online documentation and did a few searches in the 
list archives but I couldn’t find this. I’m using pgAdminIII version 1.20.0, 
running on a Mac with OS X 10.10.4.

Thanks for any suggestions you can provide. Take care,
Joe Montibello

-- 
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-22 Thread Josh Berkus
On 07/21/2015 11:29 PM, Ashesh Vashi wrote:
> On Wed, Jul 22, 2015 at 11:56 AM, Sanket Mehta
> mailto:sanket.me...@enterprisedb.com>>
> wrote:
> 
> Hi Dave,
> 
> As per our discussion, I have tried to reproduce the issue, but it
> seems jobs are running 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 before, the logs show nothing of interest.  There are no
errors. just polling for new jobs.

Anyway, the failing system has now been shut down, so we'll need to
chalk this particular failure up to "wierd stuff".


-- 
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] save location for queries

2015-07-22 Thread Melvin Davidson
Options  Query Tool    Favourites  Favourites file path ?
 Melvin Davidson 
      Cell 720-320-0155 

I reserve the right to fantasize.  Whether or not you 
 wish to share my fantasy is entirely up to you. 

www.youtube.com/unusedhero
 
 Folk Alley - All Folk - 24 Hours a day 
www.folkalley.com


  From: Joseph Montibello 
 To: "pgadmin-support@postgresql.org"  
 Sent: Wednesday, July 22, 2015 11:40 AM
 Subject: [pgadmin-support] save location for queries
   
Hi,

Is there a way to set a default path where my .sql query files should be saved 
and opened from? I keep all of them in a specific folder outside of the 
“Documents” folder and I’d like to be able to set it as a default.

I tried looking in PGAdmin3 > Preferences. I looked through Info.plist within 
the package itself using Finder, but didn’t see anything that looked relevant. 
I also looked through the online documentation and did a few searches in the 
list archives but I couldn’t find this. I’m using pgAdminIII version 1.20.0, 
running on a Mac with OS X 10.10.4.

Thanks for any suggestions you can provide. Take care,
Joe Montibello

-- 
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-22 Thread Leonard Boyce
Just chiming in quickly,

We experienced exactly the same behavior with pg 9.4.
It was consistent across the 18 database servers that we upgraded from
9.3 to 9.4.

A job would complete successfully, and then just remain in 'running' state.

We tried purging and re-installing pg and pgadmin/agent cleanly and
still had the same results.

Eventually in frustration we just copied over the pgagent binary
(nothing else) from a server running 9.3 and amazingly stuff started
working.

All I can really contribute to this issue discussion is our "path to
the problem".

Initial OS: Ubuntu 12 LTS x64 running pg 9.1 from the pgdg repos
We were running 9.3 without any issues on those servers. All pgagent
jobs would complete and run as expected
We upgraded the OS to Ubuntu 14.04 LTS
We then upgraded pg to 9.4

Post-upgrade, pgagent (which was also upgraded in the process) started
exhibiting the behavior as described in the thread

Leonard


On Wed, Jul 22, 2015 at 12:33 PM, Josh Berkus  wrote:
> On 07/21/2015 11:29 PM, Ashesh Vashi wrote:
>> On Wed, Jul 22, 2015 at 11:56 AM, Sanket Mehta
>> mailto:sanket.me...@enterprisedb.com>>
>> wrote:
>>
>> Hi Dave,
>>
>> As per our discussion, I have tried to reproduce the issue, but it
>> seems jobs are running 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 before, the logs show nothing of interest.  There are no
> errors. just polling for new jobs.
>
> Anyway, the failing system has now been shut down, so we'll need to
> chalk this particular failure up to "wierd stuff".
>
>
> --
> 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


-- 
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] save location for queries

2015-07-22 Thread Joseph Montibello
Hi,

Thanks for the reply! I think I’m missing something, though. In looking at the 
“favourites file path” in the documentation, it looks like it’s a place to 
store bits and pieces of SQL queries that you might want to re-use when 
constructing other queries. When I’m working in the query builder and hit the 
folder icon to open a saved query, it always opens up my “Documents” folder, 
which is the behavior I’d like to change.

I did try changing “Options > Query Tool > Favourites > Favourites file path” 
to be the path to the directory where I’m putting all my .sql files (saved 
queries). But when I do that, it just says it couldn’t open the path.

Joe Montibello


On Jul 22, 2015, at 12:39 PM, Melvin Davidson 
mailto:melvin6...@yahoo.com>> wrote:

Options
  Query Tool
Favourites  Favourites file path ?

Melvin Davidson
Cell 720-320-0155

I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you. 
[http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif]

www.youtube.com/unusedhero

Folk Alley - All Folk - 24 Hours a day
www.folkalley.com



From: Joseph Montibello 
mailto:joseph.montibe...@dartmouth.edu>>
To: "pgadmin-support@postgresql.org" 
mailto:pgadmin-support@postgresql.org>>
Sent: Wednesday, July 22, 2015 11:40 AM
Subject: [pgadmin-support] save location for queries

Hi,

Is there a way to set a default path where my .sql query files should be saved 
and opened from? I keep all of them in a specific folder outside of the 
“Documents” folder and I’d like to be able to set it as a default.

I tried looking in PGAdmin3 > Preferences. I looked through Info.plist within 
the package itself using Finder, but didn’t see anything that looked relevant. 
I also looked through the online documentation and did a few searches in the 
list archives but I couldn’t find this. I’m using pgAdminIII version 1.20.0, 
running on a Mac with OS X 10.10.4.

Thanks for any suggestions you can provide. Take care,
Joe Montibello

--
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] save location for queries

2015-07-22 Thread Guillaume Lelarge
Hi,

2015-07-22 20:52 GMT+02:00 Joseph Montibello <
joseph.montibe...@dartmouth.edu>:

>  Hi,
>
>  Thanks for the reply! I think I’m missing something, though. In looking
> at the “favourites file path” in the documentation, it looks like it’s a
> place to store bits and pieces of SQL queries that you might want to re-use
> when constructing other queries. When I’m working in the query builder and
> hit the folder icon to open a saved query, it always opens up my
> “Documents” folder, which is the behavior I’d like to change.
>
>  I did try changing “Options > Query Tool > Favourites > Favourites file
> path” to be the path to the directory where I’m putting all my .sql files
> (saved queries). But when I do that, it just says it couldn’t open the path.
>
>
Because it's waiting for a file to put favourites queries in it. That's not
what you're looking for. And as far as I know, what you're looking for
doesn't exist in pgAdmin.


>   Joe Montibello
>
>
>  On Jul 22, 2015, at 12:39 PM, Melvin Davidson 
> wrote:
>
>   Options
>   Query Tool
> Favourites  Favourites file path ?
>
>  Melvin Davidson
> Cell 720-320-0155
>
> I reserve the right to fantasize.  Whether or not you
> wish to share my fantasy is entirely up to you.
>
> www.youtube.com/unusedhero
>
> Folk Alley - All Folk - 24 Hours a day
> www.folkalley.com
>
>
>   --
> *From:* Joseph Montibello 
> *To:* "pgadmin-support@postgresql.org" 
> *Sent:* Wednesday, July 22, 2015 11:40 AM
> *Subject:* [pgadmin-support] save location for queries
>
> Hi,
>
> Is there a way to set a default path where my .sql query files should be
> saved and opened from? I keep all of them in a specific folder outside of
> the “Documents” folder and I’d like to be able to set it as a default.
>
> I tried looking in PGAdmin3 > Preferences. I looked through Info.plist
> within the package itself using Finder, but didn’t see anything that looked
> relevant. I also looked through the online documentation and did a few
> searches in the list archives but I couldn’t find this. I’m using
> pgAdminIII version 1.20.0, running on a Mac with OS X 10.10.4.
>
> Thanks for any suggestions you can provide. Take care,
> Joe Montibello
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>
>
>
>


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com


Re: [pgadmin-support] save location for queries

2015-07-22 Thread Joseph Montibello
Thanks for clearing that up.

Joe Montibello



On Jul 22, 2015, at 3:36 PM, Guillaume Lelarge 
mailto:guilla...@lelarge.info>> wrote:

Hi,

2015-07-22 20:52 GMT+02:00 Joseph Montibello 
mailto:joseph.montibe...@dartmouth.edu>>:
Hi,

Thanks for the reply! I think I’m missing something, though. In looking at the 
“favourites file path” in the documentation, it looks like it’s a place to 
store bits and pieces of SQL queries that you might want to re-use when 
constructing other queries. When I’m working in the query builder and hit the 
folder icon to open a saved query, it always opens up my “Documents” folder, 
which is the behavior I’d like to change.

I did try changing “Options > Query Tool > Favourites > Favourites file path” 
to be the path to the directory where I’m putting all my .sql files (saved 
queries). But when I do that, it just says it couldn’t open the path.


Because it's waiting for a file to put favourites queries in it. That's not 
what you're looking for. And as far as I know, what you're looking for doesn't 
exist in pgAdmin.

Joe Montibello


On Jul 22, 2015, at 12:39 PM, Melvin Davidson 
mailto:melvin6...@yahoo.com>> wrote:

Options
  Query Tool
Favourites  Favourites file path ?

Melvin Davidson
Cell 720-320-0155

I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you. 
[http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif]

www.youtube.com/unusedhero

Folk Alley - All Folk - 24 Hours a day
www.folkalley.com



From: Joseph Montibello 
mailto:joseph.montibe...@dartmouth.edu>>
To: "pgadmin-support@postgresql.org" 
mailto:pgadmin-support@postgresql.org>>
Sent: Wednesday, July 22, 2015 11:40 AM
Subject: [pgadmin-support] save location for queries

Hi,

Is there a way to set a default path where my .sql query files should be saved 
and opened from? I keep all of them in a specific folder outside of the 
“Documents” folder and I’d like to be able to set it as a default.

I tried looking in PGAdmin3 > Preferences. I looked through Info.plist within 
the package itself using Finder, but didn’t see anything that looked relevant. 
I also looked through the online documentation and did a few searches in the 
list archives but I couldn’t find this. I’m using pgAdminIII version 1.20.0, 
running on a Mac with OS X 10.10.4.

Thanks for any suggestions you can provide. Take care,
Joe Montibello

--
Sent via pgadmin-support mailing list 
(pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support






--
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com



[pgadmin-support] Re: [pgadmin-support] PGadmin 1.20.0 / Apple MBP 13 (early 2015) SwissGerman Keyboard [!¨][^`] keys bug

2015-07-22 Thread Josemando Sobral
Hey Erwan,

I'm facing a similar problem that, where I can't use the single quote ( ' )
character on my Brazilian Portuguese keyboard.

Cheers


On Mon, Jul 20, 2015 at 10:08 AM, Erwan Begoc  wrote:

> Hi All,
> I could not find this bug listed anywhere.
>
> With PGadmin 1.20 from binary .dmg file, on a early 2015 13 inch Retina
> MacBookPro with Swiss german keyboard, I am getting a strange bug where in
> the SQL editor pane, i am not able to use two keys for characters ^ ` and
> characters ! ¨ , no output is given as if the press was not registered.
>
> These keys are located left from the Backspace for the first one and just
> underneath it, left of the Enter key for the second one.
>
> This is only the case in the SQL Editor pane, the Scratch Pad pane allows
> me to type these two keys. I can copy paste the exclamation park when
> needed from the scratch pad to the SQL editor.
>
> Best Regards
>
>  Erwan Bégoc
>