Re: [ADMIN] Windows Services and Postgresql 9.1.3

Guys, Thank you for the info about this. (we are using windows, as we don't have high loads usage of the database and we use then the same server to run our server applications). Vincent. On Sat, Sep 22, 2012 at 4:46 AM, Craig Ringer wrote: > On 09/22/2012 06:25 AM, Walter Hurry wrote: > >> On

Re: [ADMIN] Windows Services and Postgresql 9.1.3

On 09/22/2012 06:25 AM, Walter Hurry wrote: On Fri, 21 Sep 2012 10:33:25 -0600, Scott Marlowe wrote: On Tue, Sep 11, 2012 at 2:48 PM, Vincent Dautremont wrote: Hi, I'm using Postgresql 9.1.3 x64 on Windows 2008, I'm doing reliability tests and effects and consequences of a server power failur

Re: [ADMIN] Windows Services and Postgresql 9.1.3

On Fri, 21 Sep 2012 10:33:25 -0600, Scott Marlowe wrote: > On Tue, Sep 11, 2012 at 2:48 PM, Vincent Dautremont > wrote: >> Hi, >> I'm using Postgresql 9.1.3 x64 on Windows 2008, >> I'm doing reliability tests and effects and consequences of a server >> power failure. > > If you're looking to tes

Re: [ADMIN] Windows Services and Postgresql 9.1.3

On Tue, Sep 11, 2012 at 2:48 PM, Vincent Dautremont wrote: > Hi, > I'm using Postgresql 9.1.3 x64 on Windows 2008, > I'm doing reliability tests and effects and consequences of a server power > failure. If you're looking to test for reliability and bugginess, I'd highly suggest testing against th

Re: [ADMIN] Windows Services and Postgresql 9.1.3

ptiembre de 2012 09:27 p.m. Para: 'Craig Ringer'; 'Vincent Dautremont' CC: 'pgsql-admin@postgresql.org' Asunto: RE: [ADMIN] Windows Services and Postgresql 9.1.3 Yes, is a Bug, sometimes in some circumstances pg_ctl go down but postgres server still running. You

Re: [ADMIN] Windows Services and Postgresql 9.1.3

l.org] En nombre de Craig Ringer Enviado el: lunes, 17 de septiembre de 2012 12:43 a.m. Para: Vincent Dautremont CC: pgsql-admin@postgresql.org Asunto: Re: [ADMIN] Windows Services and Postgresql 9.1.3 On 09/12/2012 04:48 AM, Vincent Dautremont wrote: > For example, after the server had reboot

Re: [ADMIN] Windows Services and Postgresql 9.1.3

On 09/12/2012 04:48 AM, Vincent Dautremont wrote: For example, after the server had rebooted, I would stop the service from services.msc Windows then reports it as stopped but I can still see that the database is running, and can use it. Check in the process monitor (or, better, with Process

[ADMIN] Windows Services and Postgresql 9.1.3

Hi, I'm using Postgresql 9.1.3 x64 on Windows 2008, I'm doing reliability tests and effects and consequences of a server power failure. What I see is that when Windows reboots from a power failure sometimes the Windows postgresql service is not in sync with the actual state of postgres. For examp

[ADMIN] Windows client only psql install

Hi All, This is my first post, so if I am doing something wrong, feel free to let me know. 1) I am looking to use psql from my remote Windows 7 desktop, connecting to a backend Postgres server at another location. I have worked extensively with Oracle and there is a client side SQLPlus to

[ADMIN] Windows 7

Hi there I have read the PG8.4 supports Windows 7 but it is not listed in your FAQ's (I'm just not sure when they were last updated). Can you please tell me if the two are compatible? Thanks, Marty Marty Dinniss Ph (04) 384 5618 Mob (021)775

[ADMIN] Windows 7 and SSPI

Hello, I'm using version 8.4 on Windows 7 RC (build 7100). When using SSPI I could never get it to work on loopback with IPv6 but it worked on IPv4 just fine. However, after I installed the latest Windows updates I cannot get SSPI to work on either loopback address. The error I get is the

[ADMIN] Windows terminal session setup / initdb failure

Hello, we've been reported a problem with installing PostgreSQL v8.2.9 via ICA-Client - initdb failed with error code 128. Installation of v8.3 and strangely v8.1 was no problem. It seems to be an older problem: http://archives.postgresql.org/pgsql-hackers-win32/2004-08/msg00288.php Did you cha

Re: [ADMIN] Windows xp initdb POSTGRES_SUPERUSERNAME

"Jan-Peter Seifert" <[EMAIL PROTECTED]> writes: > I wonder what this variable in initdb is about: POSTGRES_SUPERUSERNAME > Apparently the default should be 'postgres'. However, the value changes with > the user that is logged in whenever I use 'initdb --show'. If I login as 'xy' > the value is 'x

[ADMIN] Windows xp initdb POSTGRES_SUPERUSERNAME

Hello, I wonder what this variable in initdb is about: POSTGRES_SUPERUSERNAME Apparently the default should be 'postgres'. However, the value changes with the user that is logged in whenever I use 'initdb --show'. If I login as 'xy' the value is 'xy'. Shouldn't this be a fixed value in the clust

[ADMIN] Windows OS Crash, got Data Folder, how do I get it running again...

I'm not a PostgreSQL expert, I only know Microsoft SQL. I have a customer with postgresql database... 1. Windows OS Crashed *do not know the state of postgresql when this occurred* 2. Pulled data folder from from postgresql 8.2 folder 3. OS was reinstalled & post 8.2 How do I reinsert the Da

Re: [ADMIN] Windows max concurrent connections

Hi, (reposting... I replied directly to sender instead than to the mailing list...) On Thu, Apr 3, 2008 at 6:47 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Thu, Apr 3, 2008 at 10:11 AM, Mario Ferloni <[EMAIL PROTECTED]> wrote: > > > > I am a bit concerned about the max concurrent connectio

Re: [ADMIN] Windows max concurrent connections

to:[EMAIL PROTECTED] On Behalf Of Scott Marlowe > Sent: Thursday, April 03, 2008 10:47 AM > To: Mario Ferloni > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Windows max concurrent connections > > On Thu, Apr 3, 2008 at 10:11 AM, Mario Ferloni > <[EMAIL PROTECTED]>

Re: [ADMIN] Windows max concurrent connections

On Thu, Apr 3, 2008 at 10:11 AM, Mario Ferloni <[EMAIL PROTECTED]> wrote: > > I am a bit concerned about the max concurrent connection problem > documented in the windows faq > (http://www.postgresql.org/docs/faqs.FAQ_windows.html#4.4), that is > due to user32.dll limitations. Now, my question

[ADMIN] Windows max concurrent connections

Hi all, this is my very first post to this list. I have searched the archives, but it seems that this argument hasn't been treated deeply before. Please be fair as this will be a long message :) . I am in charge of designing and implementing a medium-size deployment of PostgreSQL (with PostGIS), w

Re: [ADMIN] Windows 64 bit

On Mittwoch, 19. März 2008 Campbell, Lance wrote: > Would there be benefits in running PostgreSQL in a 32 bit mode on a > 64 bit version of XP?   My thought is that the OS could access more > of the memory for the caching of the files.  I come to this > understanding because on my production Linux

Re: [ADMIN] Windows 64 bit

.0382 http://webservices.uiuc.edu From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Campbell, Lance Sent: Wednesday, March 19, 2008 11:58 AM To: posgres support Subject: [ADMIN] Windows 64 bit I noticed that there is not a 64 bit windows versi

[ADMIN] Windows 64 bit

I noticed that there is not a 64 bit windows version of postgres binaries. When will the 64 bit version be available? Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu

[ADMIN] Windows Evenlog entry - How to Control?

Hi All, I am using the postgresql 8.2.4 (windows).When I don't have enough space left on my harddisk, postgresql is logging the message "could not write to log file: No space left on device" to Windows event viewer. This message is written to event viewer a lot of times in a minute. 1) Can

Re: [ADMIN] Windows 8.2.4 installation

It actually is: pg_ctl --help -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 6/11/07, Abraham, Danny <[EMAIL PROTECTED]> wrote: Hi, I am building a Windows installation by copying all the .exe and .dll files to a single \bin file. I am, then, testing by running "pg_ctl –help" and

[ADMIN] Windows 8.2.4 installation

Hi, I am building a Windows installation by copying all the .exe and .dll files to a single \bin file. I am, then, testing by running "pg_ctl -help" and nothing comes out. The Path is set properly. Thanks Danny Abraham BMC Software CTM&D BU 972-52-4286-513 [EMAIL PROTECTED]

Re: [ADMIN] windows silent installer .msi file

ECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Milen A. Radev Sent: Friday, January 12, 2007 6:34 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] windows silent installer .msi file Vasu Kamma (vakamma) написа: please provide me the link for downloadable .msi file , for silent installati

Re: [ADMIN] windows silent installer .msi file

PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] windows silent installer .msi file Vasu Kamma (vakamma) написа: > please provide me the link for downloadable .msi file , for silent > installation on windows machines. http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2F

Re: [ADMIN] windows silent installer .msi file

Vasu Kamma (vakamma) написа: > please provide me the link for downloadable .msi file , for silent > installation on windows machines. http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2Fv8.2.1%2Fwin32%2Fpostgresql-8.2.1-1.zip Then read this - http://pginstaller.projects.postgresql.

[ADMIN] windows silent installer .msi file

please provide me the link for downloadable .msi file , for silent installation on windows machines. Thanks vasu

Re: [ADMIN] Windows Dependency Issue

Hello Pete, There is certainly a Windows command you can run that will alter the command used to start a service - it's "sc" (which can also be used to start/stop a service programmatically.) The command syntax to modify the EXE path is: sc config binpath= "" (eg.) sc config "PostgreSQL Dat

[ADMIN] Windows Dependency Issue

Hello, We have a windows-based server that uses postgres (8.1) as the db. We use a 'silent install' to install postgres as a windows service. Our server is then installed as a service with a dependency on postgres. As seen in other posts, to ensure that postgres starts up before the server sta

[ADMIN] Windows Installation Problem

Hi, I'm trying to install Postgresql on windows xp. For the first time there was a problem and installation couldn't be finished. I tried again, and user "postgres" had already been there !!! Is there anyway to delete everything including all the users related with postgresql? (to do everything fr

Re: [ADMIN] windows install not as a service

On Fri, Jan 06, 2006 at 10:23:46PM -0500, Skriloff, Nicholas wrote: > I installed 8.1 in windows XP SP2 in C:\Program Files\PostgreSQL\8.1\ > --the default-, but not as a service, and would like to find some > helpful bat files for things like starting and stopping the server. Is > there a place

[ADMIN] windows install not as a service

I installed 8.1 in windows XP SP2 in   C:\Program Files\PostgreSQL\8.1\ --the default—, but not as a service, and would like to find some helpful bat files for things like starting and stopping the server.  Is there a place I can get some helpful windows bat files?   Sincerely, Nick Skri

Re: [ADMIN] Windows Installer Bug (Probably)

Sabbiolina I did what you suggested but it did not work. I wish it was that simple to correct. Any other ideas people? http://www.freemail.gr - äùñåÜí õðçñåóßá çëåêôñïíéêïý ôá÷õäñïìåßïõ. http://www.freemail.gr - free email serv

Re: [ADMIN] Windows Installer Bug (Probably)

You must add ...\PostgreSQL\8.1\bin\ to PATH manually and restart ;) On 12/16/05, Ilias Goudaropoulos <[EMAIL PROTECTED]> wrote: I am writing to you all just to inform you of a bug(probably), that Icame across while trying to install PostgreSQL 8.1.0-2 and 8.1.1-1 onWinXP with SP2, using the Postg

[ADMIN] Windows Installer Bug (Probably)

I am writing to you all just to inform you of a bug(probably), that I came across while trying to install PostgreSQL 8.1.0-2 and 8.1.1-1 on WinXP with SP2, using the PostgreSQL installer. I had done a windows clean install and then installed straight away PostgreSQL 8.0.4. It was the only sof

Re: [ADMIN] Windows pgpass Problems..

On Tue, 2005-09-06 at 10:24, Eric Emerton wrote: > I have been stuggling all day with the pgpass ability on 8.0 Postgres - on > Windows 2000. I have been to the > documentation: > After reading many threads on similar problems,

Re: [ADMIN] Windows pgpass Problems..

On Tue, Sep 06, 2005 at 11:24:45AM -0400, Eric Emerton wrote: > I have been stuggling all day with the pgpass ability on 8.0 Postgres > - on Windows 2000. I have been to the > documentation: > After reading many threads on similar

Re: [ADMIN] Windows pgpass Problems..

esql.org Subject: RE: [ADMIN] Windows pgpass Problems.. Lane I may have found the problem (or at least a way around it) - through another thread search. The file: C:\Program Files\PostgreSQL\\data\pg_hba.conf ..has general connection info for hitting postgres. Mine looked like: # TYPE DATABASE

Re: [ADMIN] Windows pgpass Problems..

in another pg_hba.conf file later in the batch file that closes up the security hole I may be opening by saying 'trust'. -Original Message- From: Eric Emerton [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 06, 2005 1:34 PM To: Lane Van Ingen; pgsql-admin@postgresql.org Subject:

Re: [ADMIN] Windows pgpass Problems..

; pgsql-admin@postgresql.org Subject: RE: [ADMIN] Windows pgpass Problems.. Eric, I will be interested to see someone's response to your message, because I am having the same problem (in Windows 2003, version 8.0). I want to use it in a batch file that invokes psql to load a database, etc.

Re: [ADMIN] Windows pgpass Problems..

rompt: echo %appdata% -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Eric Emerton Sent: Tuesday, September 06, 2005 11:25 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Windows pgpass Problems.. I have been stuggling all day with the pgpass ability o

Re: [ADMIN] Windows pgpass Problems..

trator' - none of them seem to take the fact that pgpass.conf is sitting there. Eric -Original Message- From: Lane Van Ingen [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 06, 2005 1:13 PM To: Eric Emerton; pgsql-admin@postgresql.org Subject: RE: [ADMIN] Windows pgpass Proble

Re: [ADMIN] Windows pgpass Problems..

> I have been stuggling all day with the pgpass ability on 8.0 Postgres - on > Windows 2000. I have been to the > documentation: > After reading many threads on similar problems, I just cannot seem to get a > batch file to re

[ADMIN] Windows pgpass Problems..

I have been stuggling all day with the pgpass ability on 8.0 Postgres - on Windows 2000. I have been to the documentation: After reading many threads on similar problems, I just cannot seem to get a batch file to recognize that

[ADMIN] Windows XP installation problem

Hello! I'm trying to install postgresql on WindowsXP box using postgresql-8.0.msi. The installation goes fine until running the service. I get a message saying that postgre-8.0 failed to run as a service. I checked system log and came across an error saying that: PostgreSQL Database Server 8.0

Re: [ADMIN] Windows XP Service startup

> I have been using an application which uses PostgreSql on > Solaris for a few years and now I am trying to our > application running on Windows XP. I want the postmaster > started as a "service" which is a choice during installation. > However, when the service is started, I want to use a >

[ADMIN] Windows XP Service startup

I have been using an application which uses PostgreSql on Solaris for a few years and now I am trying to our application running on Windows XP. I want the postmaster started as a "service" which is a choice during installation. However, when the service is started, I want to use a different data

Re: [ADMIN] Windows Account Setup Issue - Mapped Network Drive

>When trying to run postgres in Windows with a non-admin >account, we are >running into issues with network drives. > >Currently we run the DB server as a separate user because that's >what postgres wants (it doesn't like to be admin). > >But on Windows, the mapped drives letters (to network driv

[ADMIN] Windows Account Setup Issue - Mapped Network Drive

When trying to run postgres in Windows with a non-admin account, we are running into issues with network drives. Currently we run the DB server as a separate user because that's what postgres wants (it doesn't like to be admin). But on Windows, the mapped drives letters (to network drives) are un

Re: [ADMIN] Windows NT 4.0 installation.

> Hello. > > I am not in front of my NT 4.0 machine right now so I won't > be able to give any specifics messages or anything at this > point. In any case, it seems PostgreSQL can't be installed > (via the Windows install package) on Windows NT 4.0 machines, > giving an error about missing fun

[ADMIN] Windows NT 4.0 installation.

Hello. I am not in front of my NT 4.0 machine right now so I won't be able to give any specifics messages or anything at this point. In any case, it seems PostgreSQL can't be installed (via the Windows install package) on Windows NT 4.0 machines, giving an error about missing functions or somet

Re: [DOCS] [ADMIN] windows docs?

I have moved the MinGW/Win32 project page into FAQ_MINGW in CVS. I updated it to be more of an FAQ than a project page, and moved the TODO items the proper places in our official project. --- Robert Treat wrote: > On Tuesda

Re: [DOCS] [ADMIN] windows docs?

I have renamed FAQ_MSWIN to FAQ_CYGWIN. --- Robert Treat wrote: > On Tuesday 21 September 2004 04:35, Magnus Hagander wrote: > > > > When starting the Windows psql client I get a warning that the > > > > "console codepage (4

Re: [ADMIN] windows docs?

On Tuesday 21 September 2004 07:59, Magnus Hagander wrote: > > > I guess another alternative is jut remove faq_mswin from the main > > > sources and then leave it up to cygwin/native projects to maintain > > > thier own faqs, with perhaps a single question in the main > > > > postgresql > > > > > p

Re: [ADMIN] windows docs?

> > I guess another alternative is jut remove faq_mswin from the main > > sources and then leave it up to cygwin/native projects to maintain > > thier own faqs, with perhaps a single question in the main > postgresql > > pointing to both of the other faqs... anyone have a preference? > > The p

Re: [ADMIN] windows docs?

> -Original Message- > From: Robert Treat [mailto:[EMAIL PROTECTED] > Sent: 21 September 2004 12:27 > To: Magnus Hagander > Cc: Bender, Cheryl; [EMAIL PROTECTED]; Dave Page; > [EMAIL PROTECTED] > Subject: Re: [ADMIN] windows docs? > ? > I'm th

Re: [ADMIN] windows docs?

On Tuesday 21 September 2004 04:35, Magnus Hagander wrote: > > > When starting the Windows psql client I get a warning that the > > > "console codepage (437) differs from the windows codepage > > > > (1252)" and > > > > > to see installation on Windows for details. I am having > > > > trouble find

Re: [ADMIN] windows docs?

> > When starting the Windows psql client I get a warning that the > > "console codepage (437) differs from the windows codepage > (1252)" and > > to see installation on Windows for details. I am having > trouble finding this > > documentation. I've also been looking for the "Windows > FAQ"

Re: [ADMIN] windows docs?

On Thursday 16 September 2004 15:13, Bender, Cheryl wrote: > When starting the Windows psql client I get a warning that the "console > codepage (437) differs from the windows codepage (1252)" and to see > installation on Windows for details. I am having trouble finding this > documentation. I've

[ADMIN] windows docs?

Title: Message When starting the Windows psql client I get a warning that the "console codepage (437) differs from the windows codepage (1252)" and to see installation on Windows for details.  I am having trouble finding this documentation.   I've also been looking for the "Windows FAQ" whi

Re: [ADMIN] windows-1250 encoding

Martin Zdila wrote: > How can one set character encoding in the database to windows-1250? Evidently you cannot. > I just need to order selected rows by some column witch windows-1250 > encoded text. If you have windows-1250 data on the client side, then declare your client encoding, create your

[ADMIN] windows-1250 encoding

Hello How can one set character encoding in the database to windows-1250? I am using postgresql 7.2.1-2woody4 (on debian). create database somedb with encoding = 'windows-1250'; ERROR: CREATE DATABASE: invalid backend encoding I just need to order selected rows by some column witch windows-1250

[ADMIN] Windows availability/reliability?

I know that there are problems with the postmaster under windows, but does anybody know/can they tell me if the libpq interface is reliable under windows 2k? ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] Windows Installer with Configuration Instructions

On Wed, 4 Feb 2004, Harley Milne wrote: > I urgently need to a working windows installer that can successfully install > and configure a version of postgresql. > > It's been a frustrating experience trying to locate and use anything I have > found out there. > > I've tried installing a couple in

[ADMIN] Windows Installer with Configuration Instructions

I urgently need to a working windows installer that can successfully install and configure a version of postgresql. It's been a frustrating experience trying to locate and use anything I have found out there.  I've tried installing a couple installers that I've located, but the server never

[ADMIN] Windows xp+PgSQL731wina1.exe

Hey everybody.. I installed Pgsql 7.31(PgSQL731wina1.exe) on windows ( I already use Apache+php4* on my XP) and.. I wanna use the phpPgAdmin tool on my system but I cant use it Everytime I try to connect to database ı get the error (Login disallowed) Can U tell me how to create and manage users o

Re: [ADMIN] Windows Version

There is now a pre-built binary that comes cygwin, available at www.cygwin.com. There is also pgsql-cygwin mailing list. - Stuart > -Original Message- > From: Arne Weiner [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, August 30, 2001 6:28 PM > To: [EMAIL PROTECTED] > Subject: Re: Windo

Re: [ADMIN] Windows Version

It is much easier to go to http://www.cygwin.com choose Download Cygwin Now and install everything. This way you have a complete Unix compatibility environment for Windows and a working installation of Postgres. Cheers, Colin Arne Weiner wrote: > PostgreSQL is a multiplatform DMBS. You can do

Re: [ADMIN] Windows Version

Yogesh Shahir wrote: > > Hello Sir, > >Is postgreSQL is available for windows ? If yes, from where I can downlo= > ad it ? PostgreSQL is a multiplatform DMBS. You can download the tarball from ftp.postgresql.org and compile postgres for MS Windows. There are some extra requirements for com

[ADMIN] Windows Version

  Hello Sir,      Is postgreSQL is available for windows ? If yes, from where I can download it ?   Thanking you Regards,   Yogesh Shahir Project Manager CREDOTEK www.credotek.com  

Re: [ADMIN] Windows NT / Delphi

Hi, With the Postgres NT version, we have experienced the table-names are not shown in explorer, and naturally it donot appears in 'tablename' property of table component. Cheers. Kar. --- Stefan Huber <[EMAIL PROTECTED]> wrote: > Hi! > > I have two questions: > 1) What about the performance of

[ADMIN] Windows NT / Delphi

Hi! I have two questions: 1) What about the performance of PostgreSQL under WinNT (or Win2k, XP if somebody already has that). There is a project coming up, and the programmers want to stick to MS Windows. So are there any quirks with the Windows version? I checked the FAQ but the two known is

[ADMIN] windows nt

Hello there, pgsql-admin! trying to install PostgreSQL on WinNT. downloaded binary files from ftp and complete cygwin package from cygnus.com installed both of them. cygwin.bat: @echo off SET MAKE_MODE=unix SET PGLIB=/usr/local/pgsql/lib SET PGDATA=/usr/local/pgsql/data SET USER=postgres SET PA

[ADMIN] windows NT installation (fwd)

Hi, I can't install PostgreSQL on Windows NT. I badly need help. Please!!! Once I start "nmake /f win32.mak" from the /src I get the following: Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. cd interfaces\l

[ADMIN] Windows

Is it possible to use ODBC with client access to access my pgsql database in MS Windows?    Also, when I create a user with createuser, what is the default password?  MS Access asks for a password but i dont know what it is, after I use createuser.   -jim-