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
n 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
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
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 d
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 para
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 wrote
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 wrote:
> On 16/03/2012
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 - h
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 wrote:
> Le mercredi 15 décembre 2010 à 19:12 +0100, Jan Keste
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, inser
ypes for this account". I 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
t;http://domain.com/>(DES cbc mode with
> RSA-MD5)
>
> That timestamp seems kinda funky, doesn't it? 12/31/69? That can't be
> right, can it?
>
>
> Thanks again.
>
> Greig
>
> - Original Message -
> From: "Stephen Frost"
>
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 = x.
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 wrote:
> Greig,
>
> * greigw...@comcast.net (greigw...@comcast.net) wrote:
> > I finally
Hi Steven,
Thanks for the info here. In particular,
On Sat, Jun 12, 2010 at 12:58 AM, Stephen Frost 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 what errors are be
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 HTTP/poe3b
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 Times
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 wrote:
> 2010/2/23 Bryan Montgomery :
> > Hello,
> >
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 twi
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 se
er, some 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 wrote:
> On Wed, Sep 23, 2009 at 11:11 AM, Bryan Montgomery
> wrote:
> > Hi,
> > I'm looking for a way to replica
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
