Re: [GENERAL] Best high availability solution ?

2006-06-03 Thread Bruce Momjian
Joshua D. Drake wrote: > Bruce Momjian wrote: > > Stuart Bishop wrote: > > -- Start of PGP signed section. > >> Arnaud Lesauvage wrote: > >>> Hi list ! > >>> > >>> I have a small enterprise network (~15 workstations, 1 server), all > >>> running windows OSes. Most of our work is done on a PostgreSQ

Re: [GENERAL] Best high availability solution ?

2006-06-03 Thread Joshua D. Drake
Bruce Momjian wrote: Stuart Bishop wrote: -- Start of PGP signed section. Arnaud Lesauvage wrote: Hi list ! I have a small enterprise network (~15 workstations, 1 server), all running windows OSes. Most of our work is done on a PostgreSQL DB (on the windows server). I am the only IT here, and

Re: [GENERAL] Can't get pgsql 8.1.4 to password protect roles.

2006-06-03 Thread Tom Lane
"Will Buik" <[EMAIL PROTECTED]> writes: > I'm trying to password protect both the superuser role and another role that > I created later with less privileges but I can't seem to get it to work. I > have tried using the command *ALTER USER user WITH PASSWORD 'password';* and > it responds with *ALT

[GENERAL] Can't get pgsql 8.1.4 to password protect roles.

2006-06-03 Thread Will Buik
I'm trying to password protect both the superuser role and another role that I created later with less privileges but I can't seem to get it to work.  I have tried using the command ALTER USER user WITH PASSWORD 'password'; and it responds with ALTER ROLE but it seems to have no effect at all.  Ev

Re: [GENERAL] Best high availability solution ?

2006-06-03 Thread Bruce Momjian
Stuart Bishop wrote: -- Start of PGP signed section. > Arnaud Lesauvage wrote: > > Hi list ! > > > > I have a small enterprise network (~15 workstations, 1 server), all > > running windows OSes. Most of our work is done on a PostgreSQL DB (on > > the windows server). > > I am the only IT here, and

Re: [GENERAL] Using postgresql as desktop DB

2006-06-03 Thread Harald Armin Massa
Nicholas, in a transition period I did use PostgreSQL Win 32 8.0 and above on high quality server hardware. Which did not help, because of subtil problems with Windows, VMware and some HP Server tools. Result: we had around 3 blue screens of death every week. Sometimes even more. On a database s

[GENERAL] Performance difference between char and int2 columns

2006-06-03 Thread Yavuz Kavus
hi everybody.   i have two table as :   CREATE TABLE "public"."tb_section_phones" (  "section_id" INTEGER NOT NULL,   "ptype_id" INTEGER NOT NULL,   "country_code" SMALLINT DEFAULT 90,   "domain_code" SMALLINT,   "number" CHAR(7) NOT NULL,   "extension" VARCHAR(6),   CONSTRAINT "tb_section_phones_

Re: [GENERAL] psql: krb5_sendauth: Bad application version was sent (via sendauth) - Windows 2000, MIT Kerberos, PG v 8.1.1

2006-06-03 Thread Magnus Hagander
> I'm trying to setup Kerberos authentication with PG on Windows 2000. > > I have installed the MIT Kerberos Windows dlls into the PG > bin directory > - replacing the krb5_32.dll and comerr32.dll from the PG install. > I did this because the PG install did not have the > krbcc32.dll, which is n

Re: [GENERAL] Querying for strings that match after prefix

2006-06-03 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2006-06-02 05:18:08 -0700: > I think I need to explain a bit further. > > I tried simply using > > update people > replace(address, 'mailto:',''); > > but unfortunately that produced a duplicate key error as some of the > addresses prefixed with 'mailto:' are already presen

Re: [GENERAL] Using postgresql as desktop DB

2006-06-03 Thread Martijn van Oosterhout
On Fri, Jun 02, 2006 at 03:50:47PM +0400, Nicholay Ryzhov wrote: > We are using postgresql in desktop database role. We cannot demand from > our users high-quality and stable hardware. So, we have frequent > problems with database in cases of unexpected power interruption or > software errors. All

Re: [GENERAL] Querying for strings that match after prefix

2006-06-03 Thread badlydrawnbhoy
Hi there, I think I need to explain a bit further. I tried simply using update people replace(address, 'mailto:',''); but unfortunately that produced a duplicate key error as some of the addresses prefixed with 'mailto:' are already present (unprefixed) in the table. So what I need to do is fi

[GENERAL] Using postgresql as desktop DB

2006-06-03 Thread Nicholay Ryzhov
We are using postgresql in desktop database role. We cannot demand from our users high-quality and stable hardware. So, we have frequent problems with database in cases of unexpected power interruption or software errors. All this problems has one kind - postgresql says "invalid page header block r

Re: [GENERAL] Best open source tool for database design / ERDs?

2006-06-03 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: > Anyone know if DIA will generate CREATE TABLE statements from an ER > diagram? > > I'd like to have a program where I can create my db design, then be > able to instantiate the design in PostgreSQL as well as MySQL. > > I'l

Re: [GENERAL] How to do a "CREATE DATABASE" and then connect to it?

2006-06-03 Thread Frank Finner
On Sat, 3 Jun 2006 04:36:59 -0400 Terry Lee Tucker <[EMAIL PROTECTED]> thought long, then sat down and wrote: > On Saturday 03 June 2006 04:07 am, Joseph Brenner <[EMAIL PROTECTED]> > thus communicated: > --> > --> Joshua D. Drake <[EMAIL PROTECTED]> wrote: > --> > --> > Joseph Brenner wrote: >

Re: [GENERAL] How to do a "CREATE DATABASE" and then connect to it?

2006-06-03 Thread Terry Lee Tucker
On Saturday 03 June 2006 04:07 am, Joseph Brenner <[EMAIL PROTECTED]> thus communicated: --> --> Joshua D. Drake <[EMAIL PROTECTED]> wrote: --> --> > Joseph Brenner wrote: --> --> > > After you do a "CREATE DATABASE", how do you programatically --> > > connect to what you just created? --> > > -->

Re: [GENERAL] How to do a "CREATE DATABASE" and then connect to it?

2006-06-03 Thread Joseph Brenner
Joshua D. Drake <[EMAIL PROTECTED]> wrote: > Joseph Brenner wrote: > > After you do a "CREATE DATABASE", how do you programatically > > connect to what you just created? > > > > In the psql monitor, you'd use the "\c" command. > > > > If the DATABASE already exists when you connect to post

Re: [GENERAL] Best open source tool for database design / ERDs?

2006-06-03 Thread Tomi NA
On 6/2/06, Rich Shepard <[EMAIL PROTECTED]> wrote: On Fri, 2 Jun 2006, Michael Dean wrote: > a caveat: I don't believe, from my reading of the license, that this is an > open source software product. May not be. I don't recall. Neither is Java. But, if you're using it for your own purposes,