hanks.
On Sat, Apr 11, 2015 at 2:50 AM, Guillaume Lelarge
wrote:
> Hi,
>
> 2015-04-10 1:13 GMT+02:00 Tim Uckun :
>
>> I want to to do the following.
>>
>> begin;
>> explain analyze blah
>> rollback;
>>
>> If I do this I don't get the resul
Thanks.
I'll take a look at the source.
On Thu, Jun 26, 2014 at 7:43 PM, Dave Page wrote:
> On Thu, Jun 26, 2014 at 2:54 AM, Tim Uckun wrote:
> > Hi All.
> >
> > What is the technique pgadmin uses to generate those scripts? I would
> like
> > to b
Hi All.
What is the technique pgadmin uses to generate those scripts? I would like
to be able to generate them from my own application using a pg connection.
Thanks.
Hi all.
I tried to use pgadmin with redshift and it doesn't seem to work very well.
It connects to the database but can't seem display anything useful. It
throws up some error messages after it connects and can't really show
anythinng in the DB.
I tried using an older version but that didn't wo
> They work for me, both switching between tabs, or if I put them all
> side by side. Can you give more info about what you're doing exactly?
>
>
I am not doing anything special. Connect to the database, navigate to the
schema, navigate to tables, click on a table.
The right pane shows the structu
Hey guys. It's me again.
On the table listings when you click on a table you get the structure of
the table on the right hand section of the window (after a pause of
course). The other tabs on that section like statistics, dependents etc
don't do anything when I click on them.
Just FYI.
I am running 1.16.1 OSX 10.8.3
I am using the default config which has the logging set at errors only.
I had a discussion with a couple of other people at the office today and
they too reported similar problems (and others).
Are you guys using a local postgres or a remote one? I am usually using
PgAdmin extremely slow to display data on a Mac (I haven't tried it on
other platforms). I have a Macbook Air 2GHz i7 with eight gigs of ram and
of course the SSD drive and yet PgAdmin is painful to use.
I am almost certain this is due to some problem with rendering results and
not fetching the re
Wed, May 2, 2012 at 2:50 AM, Guillaume Lelarge
wrote:
> On Tue, 2012-05-01 at 10:59 +1200, Tim Uckun wrote:
>> I mentioned this before but.
>>
>> If PGadmin loses connection even momentarily it causes a crash. First
>> you get a syscall error and then it crashes (deta
I mentioned this before but.
If PGadmin loses connection even momentarily it causes a crash. First
you get a syscall error and then it crashes (details below) and has to
be restarted.
Process: pgAdmin3 [5658]
Path:/Applications/pgAdmin3.app/Contents/MacOS/pgAdmin3
Identifier:
> With the informations you told us, I can only conclude that the problem
> is not pgAdmin or the pg_service file, but Mac OS X.
You may be right. I was not having this problem with Linux.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscrip
> pg_service is only used when connecting. It has nothing to do with
> losing connections. Or did I misunderstood something in you mail?
>
When I was having problems with connections dropping out I was advised
to use a pg_service because it sets up keepalives and such like this
keepalives=1
keep
I recently switched from ubuntu to a mac and pgadmin does not seem to
be obeying my pg_service params. Specifically I am suffering from
horrible disconnection problems. I had the disconnection problems with
ubuntu as well until I upgraded to 1.14 and started using .pg_service
file.
Does pgadmin lo
I installed a couple of -dev packages and got a little further. Now I
get this error.
./db/keywords.c:33:27: fatal error: parser/kwlist.h: No such file or directory
compilation terminated.
make[3]: *** [keywords.o] Error 1
make[3]: Leaving directory
`/usr/local/home/tim/Downloads/pgadmin3-1.14.0/
> All this probably means it doesn't find the wxWidgets headers. How did
> you do the configure step? can you tell us a bit more on your way to get
> the whole thing?
I ran configure and it complained about missing wxwidgets. I did an
apt-get install on wxwidgets 2.8 and the configure went throug
I am getting the following error when running make. Configure went smoothly.
./pgAdmin3.cpp: In function ‘wxAppConsole* wxCreateApp()’:
./pgAdmin3.cpp:117:1: error: cannot allocate an object of abstract
type ‘pgAdmin3’
../pgadmin/include/pgAdmin3.h:147:7: note: because the following
virtual fun
I am using Ubuntu 11.10 and the pgadmin in the repos is 1.12. There is
a PPA at https://launchpad.net/~rhonda/+archive/pgadmin3 but it hasn't
been updated for months so it's still the beta and there is no channel
for 11.10.
Does anybody know where I can get a deb of 1.14?
Cheers.
--
Sent via pg
The drop down boxes in pgadmin don't have autocomplete and don't jump
to the items that start with the character you type. Most of them
have a very long list of items in seemingly random order (function
return types for example) so an autocomplete would make this a lot
easier to use.
Also while I
>Use a pg_service.conf file, and pgAdmin 1.14. This way, only pgAdmin
>will use the connection configuration.
Are there debs or a ppa for the pgadmin 1.14? I saw that you had debs
for older Ubuntu version but not the recent ones.
--
Sent via pgadmin-support mailing list (pgadmin-support@postg
On Tue, Aug 9, 2011 at 7:51 PM, Dave Page wrote:
> Use the keep-alive options on the server.
That effects all the clients. Tora has a feature where you can tell
it to ping the server every once in a while so I think this would be a
good feature for pgadmin too.
--
Sent via pgadmin-support mail
There was a discussion recently about pgadmin timing out and hanging
up. I suffer from this a lot because I work with remote databases and
it really is painful.
I would like to make a request that there be an option for pgadmin to
send a query to the database every 10 seconds or something to keep
Hey guys.
I have had the misfortune to try and work with pgadmin 1.12 on a
remote database for the last couple of days and experience has been
miserable to say the least. It frequently lost connection to the
database, even pulling up ten or twenty records caused it to throw
fits and lock up so I
> However, the pgAdmin crash/loss of reliability has nothing to do with
> Ms-Windows. This happens to me on a Mac.
I want to report that it also happens on linux.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgres
>
> The default TCP connection timeout is around 3 1/2 minutes. This is left
> over from the leased line and slow connection days when the protocol was
> defined and has never been updated to match the reality of high speed
> networks. This may be the timer it is waiting for. Some of the
> MS-Windo
> It may just be me, but this sounds like a bug. Have you looked at the
> tracker to see if it has already been reported? Since it appears you can
> reproduce it reliably, perhaps you should post it there so the
> developers can take a closer look at it. If you go that route, I suggest
> using Wire
>
> I have seen similar problems on routers and switches that were
> overloaded or misconfigured. Adding memory, or just increasing the
> number of buffers available might fix the problem.
My router is simply an ADSL modem, I have no control over the
multitude of routers that are in the way betwee
>
> You can play with the tcp parameters in postgresql.conf to make sure
> your tcp line is alive.
That's an idea. Thanks.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
>
> And no switch between them? Usually, this kind of issues happens because
> of a faulty firewall or switch.
I am sure there are lots of switches between me and the database. I
live in New Zealand and the server is usually in the US usually a
linode or rackspace node but sometimes it's also an E
I am using pgAdmin 1.12.1 oct 21 2010 rev-REL-1_12_1 from Martin
Pitt's PPA on ubuntu maverick.
Often when I connect to remote database the program seems to lose
connection to the database and when this happens it just locks up
tight with a blank screen. It stays locked up for a pretty long time
a
29 matches
Mail list logo