[GENERAL] Problems with kerberos 4 authenication

1999-02-18 Thread Rodney McDuff
Hi I've compiled postgresql 6.3.2 with kerberos 4 support (using the KTH-KRB Ebones distribution) on a Alpha running DU4.0D. I create a postgres_dbms principle in /etc/srvtab (and arranged for the postmaster to be able to read this file) and made the appropriate modifications to pg_hba.

Re: [GENERAL] GIS/GPS Experiences with pgsql?

1999-02-18 Thread Gregory Maxwell
On Wed, 17 Feb 1999, Peter T Mount wrote: [snip] > If the TIGER/Line data is raster, and each feature (polygon, line, > circle, etc) doesn't exceed the block size, then postgresql should be able > to handle it. [snip] Vector not raster. Right?

[GENERAL] Rename a database

1999-02-18 Thread Bryan White
Is there a way rename a database? I currently have a 'live' and a 'test' database. For reasons I won't delve into all the programs are currently using 'test'. I want a quick way of getting all the data into 'live'. I am guessing I can shutdown the postmaster and then move and/or copy directori

[GENERAL] Error in querying view

1999-02-18 Thread Adriaan Joubert
Hi I don't know whether this has been fixed in 6.4 -- I still cannot get 6.4 to compile and run on Alpha -- but I have the following error when querying a view in 6.3.2: I have a table with jobs/tasks (one job can consist of several tasks) that need to be executed, and have created a rel

Re: [GENERAL] Replication of databases (esp. postgres)

1999-02-18 Thread Clark Evans
Thomas Antepoth wrote: > > Michael, > > As Dustin pointed out, he solved it by merging a unique database > id with a sequence into a unique primary key. > If the newly inserted record gets the database id of database 2 > it will later not be recognized belonging to the relation by a > "... wh

Re: [GENERAL] Replication of databases (esp. postgres)

1999-02-18 Thread Clark Evans
Thomas Antepoth wrote: > > But what to do, if there are several local masters? I may have interpreted the problem incorrectly, but here is a similar problem I had... Say I have 5 plants in a large company. Each of these plants has a variety of machinery and tools which have detailed maintance

RE: [GENERAL] Replication of databases (esp. postgres)

1999-02-18 Thread Thomas Antepoth
Michael, On Wed, 17 Feb 1999, Michael Davis wrote: > I was thinking about creating a trigger on every table that would write an > insert, update, or delete statement into a log file. Each replicated > database would pro-actively read these and post them. Right. This is one of the prerequesites