Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?

2009-09-15 Thread Ed Koch
This guy have any friends? - Original Message - From: Martin Gainty To: dmag...@gmail.com ; Ed Koch Cc: pgsql-general@postgresql.org Sent: Tue Sep 15 19:48:12 2009 Subject: RE: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? NYC/NYstate/Federal income taxes gobble up 1

[GENERAL] Solaris Postgres

2009-09-15 Thread John R Pierce
anyone on the PG team privvy to Sun Solaris patches for postgres? like patch 138826-04 is Postgres 8.3.7 for Solaris10 Sparc... 138827-04 is the same for Sol10 x86... I'm curious if anyone has a clue how long before Sun releases PG 8.4.x in Solaris 'patch' format ... -- Sent via p

Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?

2009-09-15 Thread Martin Gainty
how many PB&J did you make before arriving there? any restaurant in NYC but mickey D's does COST that much this is decidedly O/T so lets take this discussion offline Martin Gainty __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertrau

Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?

2009-09-15 Thread Michael Glaesemann
On Sep 15, 2009, at 20:48 , Martin Gainty wrote: NYC/NYstate/Federal income taxes gobble up 1/2 your check BEFORE you can pay any of your bills keep in mind that a studio *starts* at 2500/month this doesnt include parking which is ANOTHER 250-500/month ..taxis are a min of 20$ to go 1 bl

Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?

2009-09-15 Thread Martin Gainty
NYC/NYstate/Federal income taxes gobble up 1/2 your check BEFORE you can pay any of your bills keep in mind that a studio *starts* at 2500/month this doesnt include parking which is ANOTHER 250-500/month ..taxis are a min of 20$ to go 1 block..meals are a min of 50$/per you could actually be *

Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?

2009-09-15 Thread Chris
Probably best posted on the jobs list: http://archives.postgresql.org/pgsql-jobs/ -- Postgresql & php tutorials http://www.designmagick.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-gene

Re: [GENERAL] hardware information

2009-09-15 Thread dennis jenkins
On Tue, Sep 15, 2009 at 3:03 PM, Scott Marlowe wrote: > On Tue, Sep 15, 2009 at 1:49 PM, John R Pierce wrote: >> std pik wrote: >>> >>> Hello all.. >>> I'm using PostgreSQL 8.3.. >>> How can I get information about the hardware utilization: >>>       - CPU usage. >>>       - Disk space. >>>      

Re: [GENERAL] hardware information

2009-09-15 Thread Scott Marlowe
On Tue, Sep 15, 2009 at 2:10 PM, dennis jenkins wrote: > On Tue, Sep 15, 2009 at 3:03 PM, Scott Marlowe > wrote: >> On Tue, Sep 15, 2009 at 1:49 PM, John R Pierce wrote: >>> std pik wrote: Hello all.. I'm using PostgreSQL 8.3.. How can I get information about the hardware ut

[GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?

2009-09-15 Thread Ed Koch
Best Regards, Ed Koch Principal Addison Search 212-378-1634 1350 Broadway NY,NY suite 810, 10018 This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, dis

Re: [GENERAL] hardware information

2009-09-15 Thread Scott Marlowe
On Tue, Sep 15, 2009 at 1:49 PM, John R Pierce wrote: > std pik wrote: >> >> Hello all.. >> I'm using PostgreSQL 8.3.. >> How can I get information about the hardware utilization: >>       - CPU usage. >>       - Disk space. >>       - Memory allocation. >> > > > what operating system are you on?

Re: [GENERAL] hardware information

2009-09-15 Thread John R Pierce
std pik wrote: Hello all.. I'm using PostgreSQL 8.3.. How can I get information about the hardware utilization: - CPU usage. - Disk space. - Memory allocation. what operating system are you on? If its Linux or some flavor of Unix, I'd use a combination of ps(1), df(1

Re: [GENERAL] postgresql.key secure storage

2009-09-15 Thread David Fetter
On Mon, Sep 14, 2009 at 07:39:47PM +0200, Saleem EDAH-TALLY wrote: > OK guys, I would never have thought about modifying libpq to steal > confidential data, and I have never used debuggers in this respect > at all. > > So super gurus can yet do the bad thing. It doesn't take any kind of guru to

Re: [GENERAL] postgresql.key secure storage

2009-09-15 Thread Christopher Browne
nm...@netcourrier.com ("Saleem EDAH-TALLY") writes: > OK guys, I would never have thought about modifying libpq to steal > confidential > data, and I have never used debuggers in this respect at all. > > So super gurus can yet do the bad thing. Since this thread was published, anyone capable of

Re: [GENERAL] invalid byte sequence for encoding

2009-09-15 Thread Daniel Schuchardt
Yes, you'r correct with the \0 at the end. The problem is that the rtf-object returns wrong terminated string. i can fix the problem with a trim. but look here: X=# UPDATE art SET ak_auftxt= '*', ak_auftxt_rtf= '{\\rtf1\\ansi\\deff0{\\fonttbl{\\f0\\fnil\\fcharset0 Arial;}}\r\n\\viewkind4

Re: [GENERAL] invalid byte sequence for encoding

2009-09-15 Thread Scott Ribe
> So its not possible thats our parser. And > Second:string:Not really: thats the orignal string, and its a string: Look again. Where is the null character in the original string? Why does your encoded string end with "\0"? In what character set is null a legal character? Your encoder is incorr

Re: [GENERAL] altering domains, allowing null

2009-09-15 Thread Grzegorz Jaśkiewicz
nvm. I figured it out seconds after sending that email (despite spending 10 mins on it prior to). for the record: alter DOMAIN xxx DROP NOT NULL ; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-

[GENERAL] altering domains, allowing null

2009-09-15 Thread Grzegorz Jaśkiewicz
How can I alter domain, to allow it to be null ? I can set it to be NOT NULL, but there's now way to achieve the opposite effect. At least I can't find a way. Any ideas please ? (8.3+) -- GJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscripti

Re: [GENERAL] PostgreSQL + 64 bit + performance

2009-09-15 Thread Vick Khera
On Mon, Sep 14, 2009 at 7:13 PM, David Kerr wrote: > My oracle experience tells me that I want to go with 64 bit postgres > so that i can have faster disk and memory access. If not faster memory access, but you can get more memory in a 64-bit address space. My primary DB servers have 24GB of RAM

Re: [GENERAL] Non-check constraint def for a static list ?

2009-09-15 Thread David Fetter
On Tue, Sep 15, 2009 at 08:01:19AM -0700, Gauthier, Dave wrote: > Hi: > > How could I define a constraint on a colum who's value I want to > restrict to a static list of strings? For example, a column colled > "gender" which cannot be NULL and must be either 'M' or 'F'. I can > do it with a "che

Re: [GENERAL] Non-check constraint def for a static list ?

2009-09-15 Thread Grzegorz Jaśkiewicz
CHECK( foo IN ('bar1', 'bar2')); -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Non-check constraint def for a static list ?

2009-09-15 Thread Sam Mason
On Tue, Sep 15, 2009 at 08:01:19AM -0700, Gauthier, Dave wrote: > How could I define a constraint on a colum who's value I want to > restrict to a static list of strings? For example, a column colled > "gender" which cannot be NULL and must be either 'M' or 'F'. I can do > it with a "check" const

[GENERAL] Non-check constraint def for a static list ?

2009-09-15 Thread Gauthier, Dave
Hi: How could I define a constraint on a colum who's value I want to restrict to a static list of strings? For example, a column colled "gender" which cannot be NULL and must be either 'M' or 'F'. I can do it with a "check" constraint, but I can't defer those constraints (the reason I'm askin

[GENERAL] hardware information

2009-09-15 Thread std pik
Hello all.. I'm using PostgreSQL 8.3.. How can I get information about the hardware utilization: - CPU usage. - Disk space. - Memory allocation. thank you. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.p

Re: Re[GENERAL] garding initdb & pg_ctl

2009-09-15 Thread Inigo Barandiaran
On Tue, Sep 15, 2009 at 03:55, Vikram Patil wrote: > Thanks Magnus for help. > > Is there any way to start pg_ctl without creating postgres user? I am > trying to use same logged in user to run initdb and start service. As per > documentation it seems to be allowed after 8.3. We tried to use it

Re: [GENERAL] Can I Save images in postgres?

2009-09-15 Thread Jasen Betts
On 2009-09-09, John R Pierce wrote: > 纪晓曦 wrote: >> Can I save images in the postgres? How to define? Does the format >> matters? Can I save JPG/PNG?How? > > you can save images as BYTEA data, and the format is totally up to your > application, as postgres just treats it as a block of bytes.

Re: [GENERAL] Can I Save images in postgres?

2009-09-15 Thread Jasen Betts
On 2009-09-09, 纪晓曦 wrote: > --001636834258521c91047319fd34 > Content-Type: text/plain; charset=ISO-8859-1 > > Can I save images in the postgres? yes. > How to define? a bytea column it probably a good start > Does the format matters? not to postgres. base64 or hex encoding and storing in a t

Re: [GENERAL] Problems with pg_dump for PG8.4 for WinXP (MinGW build)

2009-09-15 Thread Magnus Hagander
2009/9/15 el dorado : > Hello! > I need PG 8.4 built from source code for WinXP. So I got archive > postgresql-8.4.1.tar.gz, unpacked it and built postgres by MinGW, as usual: > configure --witout-zlib > make > make install > > Everything seeds to be fine until we tried to test pg_dump. It failed

[GENERAL] Problems with pg_dump for PG8.4 for WinXP (MinGW build)

2009-09-15 Thread el dorado
Hello! I need PG 8.4 built from source code for WinXP. So I got archive postgresql-8.4.1.tar.gz, unpacked it and built postgres by MinGW, as usual: configure --witout-zlib make make install Everything seeds to be fine until we tried to test pg_dump. It failed (not always but often). Command: p

Re: [GENERAL] Regarding initdb & pg_ctl

2009-09-15 Thread Magnus Hagander
On Tue, Sep 15, 2009 at 03:55, Vikram Patil wrote: > Thanks Magnus for help. > > Is there any way to start pg_ctl without creating postgres user? I am trying > to use same logged in user to run initdb and start service. As per > documentation it seems to be allowed after 8.3. We tried to use it