Re: [GENERAL] Postgres with php3

2000-06-21 Thread Poul L. Christiansen
I don't think Postgres is started by default. Open linuxconf and make it start every time your Redhat starts. PgAdmin requires ODBC drivers on the windows machine, have you got them? HTH, Poul L. Christiansen Carsten Huettl wrote: > Hello, > > I have setup a RH 6.2 box with p

Re: [GENERAL] How to dump from Postgre

2000-06-27 Thread Poul L. Christiansen
Generally a lot of the questions here on the mailing lists are answered in the documentation. So read the docs first ;-) It's: "pg_dump databaseName > someFile.sql" "Morten W. Petersen" wrote: > > The PostgreSQL documentation is invisible? > > Yeah, it just vanished. Not my fault. The bitbucke

Re: [GENERAL] Great Bridge re-runs benchmark with MySQL "tuned"

2000-08-22 Thread Poul L. Christiansen
It would be interesting to see how well PostgreSQL performed when it was tuned. Or has it allready been tuned? Ned Lilly wrote: > Folks, > > We posted the following announcement on our website today, at > http://www.greatbridge.com/news/press.html. > > Please feel free to email me off-list with

Re: [GENERAL] Upper and Lower case sensitivities

2000-09-05 Thread Poul L. Christiansen
Try using ~* Her are the General Operators: http://www.postgresql.org/docs/user/x2125.htm "Campbell, Scott" wrote: > Hey, > > Is there a function within postgres that lets you search for both upper and > lower case at the same time? > I know of the upper() and lower() functions but if a word ha

Re: [GENERAL] windows UI tool???

2000-09-15 Thread Poul L. Christiansen
Try PgAdmin: http://www.pgadmin.freeserve.co.uk/ Poul L. Christiansen chris markiewicz wrote: > hello. > > can anyone recommend a windows ui tool for viewing data in postgres? > essentially i want to use something other than the command line for looking > at results. as

Re: [GENERAL] replication

2000-09-21 Thread Poul L. Christiansen
em. You are not the first person to ask for this feature and it is on the TODO list: http://www.postgresql.org/docs/pgsql/doc/TODO.detail/replication but it is categorized under "exotic features", so I don't know when we'll see it implemented :( But I think www.psql.com

Re: [GENERAL] PostgreSQL on Cobalt Raq and Cold Fusion on NT usingODBC?

2000-09-25 Thread Poul L. Christiansen
Try "netstat -nap" on the PostgreSQL box and see if the postmaster is listening to requests at all. HTH, Poul L. Christiansen Randall Smith wrote: > > The machines are on the same subnet, nearly side by side. I thought maybe I > could telnet into port 5432 but still no

Re: [GENERAL] full text indexing

2000-10-03 Thread Poul L. Christiansen
erge them together again :) > > Anyway, I'll try and get that trigger together that I did and send it to the > PG guys to see if it's worthy of being added to contrib -- I'll send you a > copy in private if you'd like. Note: I think there have been more people to > re-write that trigger, I haven't seen anything else though.. > Where can i find the FTI code? I looked in ftp://ftp.postgresql.org/pub/contrib/ , but no luck :( Thanks for the reply, Poul L. Christiansen

Re: [GENERAL] alternative DB locations

2000-10-04 Thread Poul L. Christiansen
This has discussed before (I brougt it up) and there was talks of using the http://openacs.org/ site to do this. But I don't think there has happened anything on that matter. I think we should either use the openACS site, or write our own extension of the manual in PHP. Poul L. Christi

Re: [GENERAL] drop column?

2000-10-04 Thread Poul L. Christiansen
You don't :) Currently you can't drop an column from a table, but I think you can in version 7.1. So you have to wait to november. In the mean time, just rename it. Andrew Gould wrote: > > How do you drop a column from a table? I'm using > PostgreSQL 7.0.2. > > Thanks, > > Andrew Gould > >

Re: [GENERAL] True ACID under linux (no fsync)?

2000-10-31 Thread Poul L. Christiansen
Strange. I did a test on Redhat Linux 7.0 with fsync() turned off and my batchfile of inserts ran 10 times as fast. But that was on an slow PC with a slow IDE harddrive. What Linux distribution and kernel version are you running? Poul L. Christiansen "Gary Howland (During daytime)&q

Re: [GENERAL] True ACID under linux (no fsync)?

2000-10-31 Thread Poul L. Christiansen
Use the "-F" option. I start PostgreSQL with this line: su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o '-i -B 4096 -o -F' start >/dev/null 2>&1" < /dev/null Poul L. Christiansen Kevin O'Gorman wrote: > > I must ha

Re: [GENERAL] Query caching

2000-11-01 Thread Poul L. Christiansen
B of RAM. You can change this to whatever you want. I'm using Cold Fusion and it can cache queries itself, so no database action is necessary. But I don't think PHP and others have this possibility. But Cold Fusion costs 1300$ :( Poul L. Christiansen

Re: [GENERAL] Query caching

2000-11-01 Thread Poul L. Christiansen
Frank Joerdens wrote: > > On Wed, Nov 01, 2000 at 10:16:58AM +, Poul L. Christiansen wrote: > > PostgreSQL hits the disk on UPDATE/DELETE/INSERT operations. SELECT's > > are cached, but the default cache is only ½MB of RAM. You can change > > this to whatever you

Re: [GENERAL] Synchronizing Data?

2000-11-06 Thread Poul L. Christiansen
Check this out: http://www.erserver.com/ I don't know the status of this project, but I'm certainly looking forward to try it. Poul L. Christiansen [EMAIL PROTECTED] wrote: > > Is there a way to synchronize data between postgresql on a local machine > and postgresql on

Re: [GENERAL] Full text searching?

2000-11-10 Thread Poul L. Christiansen
Gunnar R|nning wrote: > > "Poul L. Christiansen" <[EMAIL PROTECTED]> writes: > > > I chose to use a 3rd party product (Verity) for full text indexing even > > though I would prefer to use PostgreSQL for fti. > > How is the support for Danish in Veri

Re: [GENERAL] Re: What is the size of DB in Postgresql??

2000-11-23 Thread Poul L. Christiansen
ning into the 2GB barrier. Poul L. Christiansen Ould wrote: > > Ould wrote: > The size of any file is limitted (for exemple in linux 2.2.x to 2GO). If > database (tablespace) is considered as file how we can atteign 60 GO? > > > Ould wrote: > > > > > Hello, &g

Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-13 Thread Poul L. Christiansen
And now it's on www.slashdot.org ... http://slashdot.org/articles/00/11/13/1342208.shtml Poul L. Christiansen Michael Fork wrote: > > Thought this may be of interest to some... > > http://www.phpbuilder.com/columns/tim20001112.php3 > > Michael Fork - CCNA - MCP

[GENERAL] syntax of outer join in 7.1devel

2000-12-06 Thread Poul L. Christiansen
Hi I just grabbed the latest development version from the CVS, because i need the outer join functionality. But how do I make an outer join? What's the syntax? I will RTFM if someone points me to the docs :-) Poul L. Christiansen

[GENERAL] shutting down postmasters

2001-01-09 Thread Poul L. Christiansen
here an easir way to shutdown all postmasters? What if I had a larger setup with 100 postmasters? That would take ages. Poul L. Christiansen

Re: [GENERAL] exporting table to txt

2001-01-15 Thread Poul L. Christiansen
Use the pg_dump utility. pg_dump -t MyTable MyDatabase>MyFile.sql See also "man pg_dump". Poul L. Christiansen Marcos wrote: > hi, > > i would like to make some changes in the configuration of the fields > from a table so my first doubt is concerning to keep t

Re: [GENERAL] Cant connect if -B 1024 was set to postmaster

2001-03-19 Thread Poul L. Christiansen
I remember having this problem. You need to pass the '-i' switch. Try: '-B 1024 -i' I don't know if this behavior is an error or not. Poul L. Christiansen On Mon, 19 Mar 2001, Vilson farias wrote: > Greetings, > > There are a very weird problem h

Re: [GENERAL] Cant connect if -B 1024 was set to postmaster

2001-03-19 Thread Poul L. Christiansen
H, don't you mean /var/lib/pgsql/data/postmaster.opts ? My pg_options file contains: verbose=2 query=2 syslog=0 I'm running PostgreSQL 7.0.2 on Redhat 7.0. Poul L. Christiansen Lamar Owen wrote: > > "Poul L. Christiansen" wrote: > > On Mon, 19 Mar 2001

Re: [GENERAL] Cold Fusion/ODBC

2001-03-21 Thread Poul L. Christiansen
I'm using Postgres and CF and AFAIK the only way to connect to Postgres is with ODBC. I wish there was a native interface, like the oracle interface. Maybe a Cold Fusion CFX (in C++) tag could be made that allow native Postgres connections? Poul L. Christiansen On Wed, 21 Mar 2001, Mic

Re: [GENERAL] .mdb to Postgres ?

2001-03-27 Thread Poul L. Christiansen
You can use some conversion tools that can be found on www.greatbridge.org I've used PgAdmin (windows only) to convert MS Access files to PostgreSQL. Poul L. Christiansen On Tue, 27 Mar 2001, Jean-Arthur Silve wrote: > Hi ! > > One of our customers has an MS Access DB (I th

Re: [GENERAL] What could be the reason for EXTREMELY slow INSERTs?

2001-04-02 Thread Poul L. Christiansen
Try to run a vacuum on the box with slow inserts (don't know if that helps, though). Run a /sbin/hdparm -t , to compare the speed of the harddisks. HTH, Poul L. Christiansen Daniel ?erud wrote: > > I have this little test application that compares > retreiving and inserting data

Re: [GENERAL] SSL

2001-04-18 Thread Poul L. Christiansen
Is it possible to use a SSL connection from the Windows ODBC driver to PostgreSQL? Or do I have to make a SSH link instead? Poul L. Christiansen Ron Peterson wrote: > > The BOFH wrote: > > > > Just installed 7.1 (first time) and enabled SSL support. Is there a way t

Re: [GENERAL] Database Recovery Help...

2001-05-08 Thread Poul L. Christiansen
If you are sure that no other postmaster is running, try deleting the file /tmp/.s.PGSQL.5432, as the error message suggests. When you've done that, you should be able to start the postmaster. Poul L. Christiansen On Tue, 8 May 2001, John Clark L. Naldoza wrote: > Hi, > > >