[ADMIN] Problems with Postgresql under Windows XP pro
Hi Postges-Admins, I have installed Postgresql-7-3-1 on two windows systems, a W2K-pro and a W-XP pro system. The installations have been completely identical, ipc-daemon and postmaster are installed as services with the following commands: ipc-daemon: cygrunsrv --install ipc-daemon --desc "CygWin IPC Daemon" --path /usr/local/bin/ipc-daemon --termsig INT --shutdown postmaster: cygrunsrv --install postmaster --desc "PostgreSQL Database Server" --path /usr/local/pgsql/bin/postmaster --args "-D /usr/local/pgsql/data -i" --dep ipc-daemon --termsig INT --user postgres --shutdown --stdout /pgsql.log --stderr /pgsql.err Both services are successsfully running. The rest I did like described in the README and FAQ files (cygwin, user postgres, initdb ...). Every task was running without error. Now the problem: with windows XP-pro it is not possible to get a connection to the database, when the user is not Administrator. "psql -U postgres template1" is running seccessfully only as user "Administrator". Every other user gets a error message. With W2K-pro everything works fine. Is there anybody who has resolved this XP problem? Thanks a lot, Ralph ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] journaling
Stéphane Akrich wrote: > I work with the SGBDR OpenIngres2 which has also a WAL mecanism. > More over, I journalise my database in order to recover the data between the > save of the data and the crash. > Is it possible to do it with PostgreSQL ? > thanks We don't have journalize yet, which we call point-in-time recovery. We plan to have it for 7.4. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] sequence
On Wed, Jan 08, 2003 at 05:08:35PM -0800, Roberto Benitez wrote: > I have a field of serial type. for some reason, the > sequence skips numbers every now and then. does anyone > know why? Canceled/rollbacked transactions? BR, -- --- Artur Pietruk, [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[ADMIN] crypto?
Hi, On Suse 8.0, I'm trying to compile postgresql 7.3.1. configure gives the following error: checking for inflate in -lz... yes checking for CRYPTO_new_ex_data in -lcrypto... no configure: error: library 'crypto' is required for OpenSSL Yast2 doesn't show me any packages for crypto that can be installed. Is it part of another package (OpenSSL is installed) or can I get it from somewhere? Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- Life is an SQL old chum... ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
