Re: [GENERAL] PostgreSQL with Kerberos and Active Directory

Hi Magnus, I tried changing the SPN to uppercase POSTGRES, but still the same error occurs. Any other ideas? (this didn't work both locally and remotely). Idan. On 8/31/07, Magnus Hagander [EMAIL PROTECTED] wrote: Ok. I'd try locally from the machine first, so you know the krb

Re: [GENERAL] psql \copy command runs as a transcation?

On Mon, 2007-08-27 at 18:41 -0400, Tom Lane wrote: Ow Mun Heng [EMAIL PROTECTED] writes: Does the psql's \copy command run as a transaction? Certainly. I think it does, but somehow when I cancel (in a script) a running import, seems (I can't seem to duplicate it on the cli though)

Re: [GENERAL] Removing pollution from log files

Apart from that: there was a bug in the ODBC driver prior 08.02.0402 which resulted in this error message whenever binary data of type SQL_LONGVARBINARY was send. Where is 0402 driver ? Last downloadable version in 0400 which has this issue. Andrus. ---(end of

[GENERAL] Error Message: invalid command-line arguments for server process

I am getting an error trying to connect to PostgreSQL db using Visual Basic.NET 2005. The error message is FATAL: invalid command-line arguments for server process. HINT: Try postgres --help for more information. Here is a the snippet of code to create connection. Looking for suggestions on

[GENERAL] Open Source Application Server (PostgreSQL Perspective)

Hey Guys, can you suggest any Open Source Application Server for SOA deployments. Also, wondering, if our needs are somewhat lightweight, is there some lightweight open source Application Server you could Suggest. -- View this message in context:

[GENERAL] Timezone - UTC

Folks, We are observing an issue where postgres does not like UTC0 as a timezone setting on some Unix systems. UTC+0 is something that postgres parses favorably. Is it a known issue that postgres does not like GMT0, UTC0 (which in turn translates to GMT+0 or UTC+0)? Does any version of postgres

[GENERAL] PostgreSQL with Kerberos and Active Directory

Hi everyone, I'm trying to configure PostgreSQL version 8.2.4 with Kerberos and Active Directory. The AD is run on a windows 2003 server, and the postgre on gentoo. The gentoo computer name is postgre and it's added to the windows 2003 server AD domain. I did the following: - I compiled

[GENERAL] Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)

Hello, I am have installed postgresql-7.3.4 on Linux server running Red Hat Enterprise Linux Server release 5 (Tikanga). Postmaster runs fine with the default settings, but when I try to increase number of connections to 200 I get IpcSemaphoreCreate: semget(key=5432120, num=17, 03600) failed:

Re: [GENERAL] WAL to RAW devices ?

Alex Vinogradovs wrote: Hi guys, I've got a bunch of PosgreSQL servers connected to external storage, where a single server needs to be serving as WO database dealing with INSERTs only, and bunch of other guys need to obtain a copy of that data for RO serving, without taking resources on

[GENERAL] return 1 formatted result instead of multiple results

I want to query a column in a table that returns multiple records, append the values of that column in a comma separated string, and return that string. example: select * from people; returns 3 results: Mike John Dennis and I want one result to be Mike,John,Dennis. How can I format my

Re: [GENERAL] ERROR: table row type and query-specified row type do not match

Hi Tom, we are running PostgreSQL 8.2.4. Tom Lane wrote: Patryk Kordylewski [EMAIL PROTECTED] writes: can someone help/explain me why i get this error when i try to make an update on that view? It seems that something is wrong with the subselect. http://fooby.imosnet.de/error.txt AFAICT,

[GENERAL] Reporting services for PostgreSQL

I'm looking for a report generator which renders reports in server and sends rendering result to client. any idea ? Andrus. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [GENERAL] return 1 formatted result instead of multiple results

On 8/31/07, Acm [EMAIL PROTECTED] wrote: and I want one result to be Mike,John,Dennis. SELECT ARRAY_TO_STRING(ARRAY(SELECT * FROM PEOPLE),',') AS FOO ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)

Hi, On Fri, 2007-08-31 at 18:11 -0700, Darek Czarkowski wrote: when I try to increase number of connections to 200 I get IpcSemaphoreCreate: semget(key=5432120, num=17, 03600) failed: No space left on device Error Now, I dont think the default system settings are too low, default settings

Re: [GENERAL] Timezone - UTC

Manchenahalli, Raghunandan (STSD) [EMAIL PROTECTED] writes: We are observing an issue where postgres does not like UTC0 as a timezone setting on some Unix systems. If you're seeing system-dependent behavior at all, you must be using PG 7.x. 8.0 and later should accept this consistently.

Re: [GENERAL] Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)

Darek Czarkowski [EMAIL PROTECTED] writes: I am have installed postgresql-7.3.4 on Linux server running Red Hat Enterp= rise Linux Server release 5 (Tikanga). Why in heavens name would you be wanting to run 7.3.4? Even if you have a good reason for wanting 7.3.x, you should be installing

Re: [GENERAL] ERROR: table row type and query-specified row type do not match

Patryk Kordylewski wrote: Hi Tom, we are running PostgreSQL 8.2.4. Maybe this has something to do with dropped columns? Patryk: please run select * from pg_attribute where attrelid = 'foo'::regclass and attisdropped; Replacing 'foo' with the names of all the tables and views involved in the

Re: [GENERAL] Reporting services for PostgreSQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/01/07 06:12, Andrus wrote: I'm looking for a report generator which renders reports in server and sends rendering result to client. Render as in run the report program on the host? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish,

Re: [GENERAL] Open Source Application Server (PostgreSQL Perspective)

On 9/1/07, john_sm [EMAIL PROTECTED] wrote: Hey Guys, can you suggest any Open Source Application Server for SOA deployments. Also, wondering, if our needs are somewhat lightweight, is there some lightweight open source Application Server you could Suggest. What language are your