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
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
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
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
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
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
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
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
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
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
>
>
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
>
>
>
28 matches
Mail list logo