We have a test 9.2.0 db running on openSuse 12.2. When I select now() I get
the correct timezone and date back (-5 hours).
When I do date at the os prompt, I get the right timezone back.
I changed postgres.conf to have timezone = 'EST' and restarted postgres.
However the log file is still 5 hours
Hello experts! (and other like me).
**
We have a system, that due to recent events is getting a lot heavier use.
The application makes extensive use of functions. These functions would
typically run sub-second but now can take several seconds.
I'm wondering what general ways there are to monitor
configuration and version; it makes things
much easier.
Reply follows inline.
On 11/06/2012 09:04 PM, Bryan Montgomery wrote:
I'm wondering what general ways there are to monitor and improve
performance? We look at pgadmin's server status but that only sees the
function being run. Additionally
Hello,
So we've been reviewing our processes and working on improving them. One
area we've been lacking is a procedure to version control our database
functions, table changes, static data etc.
I'm curious how others do it. Ideally, we want it to be part of our release
/ build process so that we
Hello,
It seems that the program is thinking I'm passing a table but instead I'm
passing a query. Now, I could put a hack in place, create a view and pass
that to pgsql2shp but I thought I'd ask whether anyone else has seen this
behavior and has a way to force / trick the program to treat the
Interesting idea. However, I think this is ssl between the client and
database. Given the client would be the server hosting the web service I
don't think this would work for the web service client.
On Fri, Mar 16, 2012 at 2:54 PM, Raymond O'Donnell r...@iol.ie wrote:
On 16/03/2012 18:39, Bryan
on the web service xml using public
/ private keys, or using ssl to pass the md5 hash of the clients password.
The more elegant way seems to be using the encrypted web service, but the
more universal method for clients would probably be ssl.
On Tue, Mar 20, 2012 at 3:16 PM, Bryan Montgomery mo
Hello,
We are looking at implementing a web service that basically makes calls to
the database.
I have been thinking about ways to secure the web service based on the
database.
I initially thought about just connecting to the database as the user with
parameters passed through the web service -
Thanks for the comments. Just to clarify, I gave these two values as
examples. The readings could be between a handful for one vehicle type up to
40 or more for another type of vehicle.
On Thu, Dec 16, 2010 at 12:26 PM, Vincent Veyron vv.li...@wanadoo.frwrote:
Le mercredi 15 décembre 2010 à
Hello,
I have a process that is logging data from vehicles. I'm looking for
thoughts on the pros and cons of different approaches to storing this data -
and retrieving it. Different vehicles report different types of data. The
current process stores the data in a multi-dimensional array.
eg,
had that changed on the AD side and
that fixed the whole problem.
Bryan, if you're still trying to get this to work I'd be happy to help if I
can.
Thanks all for the help.
Greig
- Original Message -
From: Greig Wise greigw...@comcast.net
To: Bryan Montgomery mo...@english.net
Yeah, the interesting thing is we're supposed to move to AES, but on the
current AD it isn't available :) Will be a bit ironic if it is all down to
using DES!
On Wed, Jun 16, 2010 at 11:05 AM, Stephen Frost sfr...@snowman.net wrote:
Greig,
* greigw...@comcast.net (greigw...@comcast.net)
Hello,
A quick question (I think).
If I have Table_A with id integer, val text - and no data.
Table_B inherits from Table_A and has a bunch of data.
Table_C inherits from Table_A and has some data.
Table_X has id integer, someValue integer
If I do select * from Table_A a, Table_X x where a.id =
kinda funky, doesn't it? 12/31/69? That can't be
right, can it?
Thanks again.
Greig
- Original Message -
From: Stephen Frost sfr...@snowman.net
To: Bryan Montgomery mo...@english.net
Cc: greigw...@comcast.net, pgsql-general@postgresql.org
Sent: Saturday, June 12, 2010 8:35:13 AM
I've been trying this as well off and on. In my case I'm not convinced the
AD configuration is correct (And someone else manages that).
Can you use kinit with the key tab options to get a good response from the
server? I think I should be able to do this ..
$ kinit -V -k -t poe3b.keytab
Hi Steven,
Thanks for the info here. In particular,
On Sat, Jun 12, 2010 at 12:58 AM, Stephen Frost sfr...@snowman.net wrote:
You may also need to make sure that your default realm is set correctly
and that your reverse DNS is working. Also, can you look in the PG
server-side logs and see
Hello,
I'm trying to get kerberos working with postgres 8.4 on openSUSE
authenticating against AD. I have the server configured and can do a kinit
against my account on the server. I have a keytab file produced by the
administrators.
$ klist -kt poe3b.keytab
Keytab name: FILE:bob.keytab
KVNO
Could you have two of these non-production databases? Prepare one in the
background, including an analyze and then make it the 'live' non-production
database then use the offline / alternative database for the next load
prepare that and then switch it on when ready.
In this scenario you'd need
Thanks for the suggestion. I wasn't able to get the whole pg to compile -
but I was able to take one of the contrib packages and use that as a
template for my needs.
Bryan.
On Wed, Feb 24, 2010 at 2:00 AM, Magnus Hagander mag...@hagander.netwrote:
2010/2/23 Bryan Montgomery mo...@english.net
Hello,
I have a very simple function that I've created. I can compile it in linux
without any problems. However, I've tried creating a dll for windows and am
not having much luck.
I first tried MSVC 2008 but after seeing some comments have tried compiling
it in MSVC 2005 as well.
In both I get
of the
large tables literally take hours across the network, for maybe a few dozen
changes.
On Wed, Sep 23, 2009 at 4:58 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Wed, Sep 23, 2009 at 11:11 AM, Bryan Montgomery mo...@english.net
wrote:
Hi,
I'm looking for a way to replicate am master
Hi,
I'm looking for a way to replicate am master database to multiple (100+)
databases that are taken in to the field. Currently for each laptop we dump
and load the tables. However,there is only a small percentage of data that
changes on a frequent basis.
I've been looking around and come across
22 matches
Mail list logo