Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

2013-11-12 Thread Christian Ullrich
* From: Brian Crowell On Mon, Nov 11, 2013 at 11:56 PM, Christian Ullrich ch...@chrullrich.net wrote: On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell br...@fluggo.com wrote: * If I don't specify my username, Npgsql sends it in lowercase bcrowell Hmm. That is related one problem I've

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

2013-11-11 Thread Christian Ullrich
* From: Brian Crowell On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell br...@fluggo.com wrote: I think I'm getting closer though. I have psql on Windows successfully authenticating, so I can't be too far off. Got it. Great! The NpgsqlPasswordPacket class has a bug: a utility function it

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

2013-11-05 Thread Christian Ullrich
* Stephen Frost wrote: * Brian Crowell (br...@fluggo.com) wrote: However, the eventual goal was to connect to this same server from a .NET app running on Windows, and here I've run into a snag. The Npgsql library does not support GSSAPI—it only supports SSPI, which is

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

2013-11-05 Thread Christian Ullrich
* Stephen Frost wrote: * Christian Ullrich (ch...@chrullrich.net) wrote: I tried to fix it using the reverse of they one-line fix that worked in both JDBC and libpq. There, the problem was that they only supported GSSAPI and had no clue about SSPI (except libpq on Windows). The fix

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

2013-11-05 Thread Christian Ullrich
* Francisco Figueiredo Jr. wrote: On Tue, Nov 5, 2013 at 2:35 PM, Christian Ullrich ch...@chrullrich.net mailto:ch...@chrullrich.net wrote: * Stephen Frost wrote: * Brian Crowell (br...@fluggo.com mailto:br...@fluggo.com) wrote: However, the eventual goal

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

2013-11-05 Thread Christian Ullrich
* Christian Ullrich wrote: Nov 1 10:31:50 infra1 postgres[25277]: [7-1] FATAL: accepting GSS security context failed Nov 1 10:31:50 infra1 postgres[25277]: [7-2] DETAIL: An unsupported mechanism was requested: Unknown error Nov 1 10:39:31 infra1 postgres[25587]: [7-1] FATAL: accepting GSS

Re: [GENERAL] PostgreSQL connect with Visual C++

2013-03-06 Thread Christian Ullrich
* dhaval257 wrote: No It is not using .NET framework. I tried with libpq but ended up with error that Application can not run because SSLEAY32.dll is missing (something like this). So I left that thing. Have you used libpq? ssleay32.dll is part of the PostgreSQL distribution, and is installed

Re: [GENERAL] FATAL : could not read directory base: Invalid argument

2012-07-28 Thread Christian Ullrich
* Abraham, Danny wrote: FATAL : could not read directory base: Invalid argument 8.2.4 on Windows. Service will not start. Any idea The data directory path should be quoted, but yours only has the closing quote. The parameter should look like -D S:\ome\path\goes\here , so add

Re: [GENERAL] I cannot insert bengali character in UTF8

2012-07-20 Thread Christian Ullrich
* AI Rumman wrote: I am using database with UTF8 and LC_CTYPE set as default value in Postgresql 9.1. But I cannot insert bengali character in a column. Query Failed:INSERT into tracker (user_id, module_name, item_id, item_summary) values ('1','Leads','353','বাংলা টেস্��...')::ADODB

Re: [GENERAL] Postgresql Data directory Issue

2011-10-05 Thread Christian Ullrich
* Adarsh Sharma wrote: 2. I installed Postgresql-8.3 in new server and trying to use the data directory but it faces the below error :- Existing data directory is not empty and it cannot able to use it . First, be very, very careful. initdb already saved your data from destruction once, but

Re: [GENERAL] Would it be possible

2011-07-25 Thread Christian Ullrich
* Adarsh Sharma wrote: In the evening, by mistake I issued a *drop database globedatabase* command. Is it possible to get the data back till the state before drop database command. My pglog files is in the E:/data directory Binary log is also enabled. You do not mention that you have a

Re: [GENERAL] Would it be possible

2011-07-25 Thread Christian Ullrich
* Adarsh Sharma wrote: I have following files in my pg_xlog directory : 000100070091 [...] 000100070098 I think I issued the drop database command 1 month ago. From the manual, I understand that my segment files are recycled to newer ones : PostgreSQL always

Re: [GENERAL] Dump large DB and restore it after all.

2011-07-05 Thread Christian Ullrich
* Condor wrote: Problem was when I start: pg_dump dbname | split -b 1G - filenameI unable to restore it correct. When I start restore DB i got error from sql he did not like one line. I make investigation and the problem was in last line of first file value field was something like 'This is a '

Re: [GENERAL] Location Data

2011-06-20 Thread Christian Ullrich
* Adarsh Sharma wrote: Today I am facing a simple problem that I fail to solve after 2 day try. I have a places table in database whose structure is as : CREATE TABLE places ( woe_id character varying(15) NOT NULL, iso character varying(6), name text, language character varying(6), place_type

Re: [GENERAL] Location Data

2011-06-20 Thread Christian Ullrich
* Adarsh Sharma wrote: Christian Ullrich wrote: Write a set of functions to get the higher-level structures (country for states, etc.) for any given record, and put a trigger on the table that populates the fields on insert and update. All the world data is populated in the places

Re: [GENERAL] Drop CHECK Constraint

2011-02-21 Thread Christian Ullrich
* Yan Cheng CHEOK wrote: I was wondering, is there any good way to drop a constraint? Currently, I am making assumption on the check constraint name. ALTER TABLE backup_table ADD CHECK (fk_lot_id = 99); If I want to drop the above CHECK constraint, I will do ALTER TABLE backup_table DROP

Re: [GENERAL] Multithreaded query onto 4 postgresql instances

2011-02-15 Thread Christian Ullrich
* Alessandro Candini wrote: Il 14/02/2011 21:00, Allan Kamau ha scritto: On Mon, Feb 14, 2011 at 10:38 AM, Alessandro Candinicand...@meeo.it wrote: No, this database is on a single machine, but a very powerful one. Processors with 16 cores each and ssd disks. I already use partitioning and

Re: [GENERAL] Using copy for WAL archiving on Windows

2011-01-22 Thread Christian Ullrich
* Harald Armin Massa wrote: Should PostgreSQL maybe provide its own file-copy utility for Windows that meets the requirements for safe WAL archiving? Microsoft does provide an enterprise-ready webscale copy program ... it is called robocopy and part of the Windows Server Resource Kit

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

2011-01-21 Thread Christian Ullrich
* tuanhoanganh wrote: I download postgresql from Enterprise DB On Thu, Jan 20, 2011 at 6:06 AM, Christian Ullrich ch...@chrullrich.net mailto:ch...@chrullrich.net wrote: We cannot assume that the one-click installer was used, but if it was, the service account it creates

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

2011-01-21 Thread Christian Ullrich
* tuanhoanganh wrote: Here is procmon i thinks error [some procmon events] No, that is all OK. The event at 2:39:55.7588651 is where Postgres starts cmd.exe to perform the copy. The really interesting data would be from cmd.exe itself, which implements the copy command. Please send the

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

2011-01-21 Thread Christian Ullrich
* tuanhoanganh wrote: I have changed archive_command to archive_command = 'copy %p D:\\3SDATABACKUP\\PITR\\WAL\\%f' and it work again. Argh. How could I not have seen that? But why old archive_command work from 01/01 to 05/01 archive_command = 'copy %p D:/3SDATABACKUP/PITR/WAL/%f' It

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

2011-01-19 Thread Christian Ullrich
* tuanhoanganh wrote: My PITR work well from 01/01/2011 to 06/01/2011. At 06/01/2011 postgresql log have issue 2011-01-06 08:27:54 ICT LOG: archive command failed with exit code 1 2011-01-06 08:27:54 ICT DETAIL: The failed archive command was: copy pg_xlog\00010004005E

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

2011-01-19 Thread Christian Ullrich
* tuanhoanganh wrote: I have checked your solution. - Target disk full : No - PostgreSQL user does not have write privilege for the target directory : No - Target file exists already (then you have a bigger problem) : Last file in D:/3SDATABACKUP/PITR/WAL is 00010004005D -

[GENERAL] Using copy for WAL archiving on Windows

2011-01-19 Thread Christian Ullrich
Hello all, the PostgreSQL manual, section 24.3.1, has an example archive_command for Windows. It is copy %p C:\\server\\archivedir\\%f . The next sentence disclaims this as an example, not a recommendation. I just had occasion to do some tests with that, and it appears to me that

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

2011-01-19 Thread Christian Ullrich
* Magnus Hagander wrote: On Wed, Jan 19, 2011 at 19:20, Christian Ullrichch...@chrullrich.net wrote: So when PostgreSQL runs copy 000...5E D:\..., it fails, and when you do the same thing as the PostgreSQL user, it works. Interesting. Try increasing the log level in postgresql.conf to see

Re: [GENERAL] Group By Question

2010-10-02 Thread Christian Ullrich
* Andrew E. Tegenkamp wrote: I have two tables and want to attach and return the most recent data from the second table. Table 1 has a counter ID and name. Table 2 has a counter ID, Reference (to Table 1 ID), Date, and Like. I want to do a query that gets each name and their most recent like.

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

2010-10-01 Thread Christian Ullrich
* Dave Page wrote: Thats very odd, but it explains why things are going wrong - essentially, the prerequisites are being unpacked to: C:\Users\Administrator\AppData\Local But the installer expects to find them in: C:\Users\Administrator\Lokale Einstellungen\ Which is a link to the first

Re: [GENERAL] libpq (C++) - Insert binary data

2010-09-30 Thread Christian Ullrich
* GOO Creations wrote: This is what I have until now to insert data char *query = insert into table1 (bytes) values ($1); QByteArray chip = assignment of bytes; const char *data = chip-data(); const char* params[]={data}; const int params_length[]={chip-length()}; const int

Re: [GENERAL] Failed regression tests with 7.0.3 on Windows NT 4.0

2000-12-04 Thread Christian Ullrich
* Tom Lane wrote on Monday, 2000-12-04: Christian Ullrich [EMAIL PROTECTED] writes: I've just gotten PostgreSQL 7.0.3 to build and actually run under WinNT 4.0, and the regression tests show two problems: one probably minor in horology (I suppose there's a wrong time zone somewhere

[GENERAL] Failed regression tests with 7.0.3 on Windows NT 4.0

2000-12-03 Thread Christian Ullrich
pleased with having to run PostgreSQL on NT, but these are the facts I can't change. So, keep up the good work! Yours, -- Christian UllrichRegistrierter Linux-User #125183 "Sie können nach R'ed'mond fliegen -- aber Sie werden sterben" *** expected/horology.out Tue