[ADMIN] eRserver

I would like to hear about any issues related to erserver. I was a little concerned about its use of Java. Java is a great tool for creating application frameworks for the payroll department, but using it for back-end system-level application programming is a bit unnerving. Java is generally s

[ADMIN] PGSQL and DNCL

Has anyone any experience with PGSQL 7.x and implenting the FTC do-not-call list - which is about 50 million 10 digit N. American phone numbers? If so what structures have you used and what have you done interms of performance tweaks? Is there an equivalent to Oracle's IOT (index organized tabl

[ADMIN] Compiling problems with 7.4.2

I ran into a problem compiling 7.4.2 on Sun Solaris. The details are as follows. Thanks SunOS 5.8 Generic_108528-29 sun4u sparc SUNW,Ultra-1 Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/specs Configured with: ../configure --with-as=/usr/ccs/bin/as -

[ADMIN] E-R Tool

Can someone suggest an E-R tool that will read a _PG_ database and create an E-R diagram - crows feet and all? Are there any that are available for free? Thanks ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister c

[ADMIN] problem compiling 7.4.3

While compiling 7.4.3 on Solaris 8 (sparc) I got: rm -f thread.c && ln -s ../../../src/port/thread.c . gcc -pthreads -O3 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declar ations -fPIC -I. -I../../../src/include -I/usr/local/include -I/usr/local/ssl/incl ude -D_REENTRANT -D_POSIX_PT

[ADMIN] Replication/Failover/HA solution

I am having a hard time selecting a Replication/Failover/HA solution for PGSQL. What is troubling is the number of solutions available in various states of development. Does the fact that dbmirror and rserv appear in the contrib directory, mean that they should be looked upon with more legitim

Re: [ADMIN] Documentation of Concepts

You will find it in the following links. It may not be as polished as Oracle's books, but still good. http://developer.postgresql.org/ * Flowchart of the PostgreSQL backend * Database Internals Presentation

Re: [ADMIN] Replication/Failover/HA solution

systems development. Either way I would love to see and test your solution and thanks for making it available to the public. Andrew Sullivan wrote: On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote: I am having a hard time selecting a Replication/Failover/HA solution for PGSQL. What is

[ADMIN] compile error

I reconfigured the make to use openssl and I revceived the following error using gcc 3.3 on SunOS 5.7 Generic_106541-25 sun4u sparc SUNW,Ultra-1 Thanks for any help! --- gmake[3]: Entering directory `/opt/sft/postgresql-7.3.3/src/interfaces/libpq' gcc -O3 -pthreads -Wall -Wmissing-prototypes

[ADMIN] 7.3.4 and OpenSSl

I am compiling 7.3.4 with openssl turned on. I ran into the same crypt.h errors. I commented out the crypt.h reference as Tom Lane suggested and then ran in to another error below. I am using cc: WorkShop Compilers 5.0 98/12/15 C 5.0 on SunOS 5.7 Generic_106541-25 sun4u sparc SUNW,Ultra-1 I am

Re: [ADMIN] 7.3.4 and OpenSSl

ive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit template1=# Tom Lane wrote: Renney Thomas <[EMAIL PROTECTED]> writes: "

Re: [ADMIN] 7.3.4 and OpenSSl

te query \q to quit template1=# Tom Lane wrote: Renney Thomas <[EMAIL PROTECTED]> writes: "tab-complete.c", line 108: warning: assignment type mismatch: pointer to function() returning pointer to pointer to char "=" pointer to void "tab-

Re: [ADMIN] 7.3.4 and OpenSSl

Did I forget a step in setting up SSL? Is their a way to find out if SSL is in use on a session or that it was compiled properly into the back-end and client? Tom Lane wrote: Renney Thomas <[EMAIL PROTECTED]> writes: I _can't_ get psql to connect with ssl on. You're no

Re: [ADMIN] PG 7.3.3 startup problem

A good start would be to read the logfile. A lot of startup problems can be solved from the messages within. It could be something as simple as trying to start PG as root. Kris Kiger wrote: I've installed postgres 7.3.3 on one of my debian machines. On other installations postgres is started

Re: RE : [ADMIN] Oracle to PostgreSQL

What are the legal implications of copying Oracle's own PL/SQL procedures code and porting them to PgSQL as you suggested? Bruno BAGUETTE wrote: "Marco Roda" <[EMAIL PROTECTED]> wrote .. Hi, I need to port data from an Oracle 8.0 base to PostgreSQL 7.2. I have scripts to create the base on O

Re: [ADMIN] Indexing a boolean

scott.marlowe wrote: On Thu, 21 Aug 2003, Kris Kiger wrote: I would appreciate it if I could get some thoughts on indexing a field with only two values? For example, I have a table with a few million Often the best approach here is to make a partial index: create index table_dx on table (

Re: [ADMIN] Prompts in psql

Sam Barnett-Cormack wrote: Is there any way to change the prompt in the psql CLI client? In the same way as one does with bash, or other shells. Ideally I want: [EMAIL PROTECTED]:database $ as the prompt. Anyone got any ideas/references? Put \set PROMPT1 '[EMAIL PROTECTED]:%~%R%# ' in your .

Re: [ADMIN] language "plpgsql" does not exist

You have to install the procedural language into each database as such: 1. su - postgres 2. createlang plpgsql [your dbname here] Sebastien Baudry wrote: Hi everybody. I'm a new born in the PostGreSQL domain (usually deal with Oracle or SQL Server) and I got the following error when trying to