Lukas schrieb:
nope, no use of it.. Situation stays the same.. Does any one have more
ideas?
[...]
I am trying to run PostgreSQL with SSL, so I compiled and
linked with
options:
./configure --prefix=/DB --with-openssl
Configured and installed successfully.
In postgresql.conf I have option
seconds ... on this installation the time it's about 10 seconds or
more,
could you provide the explain analyze-output for those queries? This should
help analyzing your problems.
Ciao,
Thomas
--
Thomas Pundt thomas.pu...@rp-online.de http://rp-online.de/
--
Sent via pgsql-admin
Scott Marlowe schrieb:
On Mon, Nov 10, 2008 at 8:50 AM, Dana Holland
[EMAIL PROTECTED] wrote:
Is it at all possible to get pgsql installed on a system without access to a
shell? A friend is wanting me to install a particular bulletin board system
on her website; however, her hosting plan only
header-file ; cat split-1 ; cat tail-file ) | psql
even simpler: cat usually takes any number of file name arguments,
so usually you simply can do
cat header-file split-1 tail-file | psql
No need for parentheses and starting a new process for each file.
Ciao,
Thomas
--
Thomas Pundt [EMAIL
] '
autovacuum = on
autovacuum_naptime = 30
autovacuum_vacuum_threshold = 500
autovacuum_analyze_threshold = 250
autovacuum_vacuum_scale_factor = 0.2
autovacuum_analyze_scale_factor = 0.1
Ciao,
Thomas
--
Thomas Pundt [EMAIL PROTECTED] http://rp-online.de
as above I don't see autovacuum. Does
| anyone know if it's running or not? This is on a box running Solaris.
you will only see it if it is currently processing your databases. Look
at the PostgreSQL log file, if it has entries from autovacuum.
Ciao,
Thomas
--
Thomas Pundt [EMAIL PROTECTED
at where
exactly it barfs. I'd guess this could be a shared memory problem (too
low shm settings).
Ciao,
Thomas
--
Thomas Pundt [EMAIL PROTECTED] http://rp-online.de/
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project
take in account case-sensitive, or any
| other way to treat??
name ilike 'a%';
name ~* '^a';
For pattern matching operators you can take a look at
http://www.postgresql.org/docs/8.2/interactive/functions-matching.html
Ciao,
Thomas
--
Thomas Pundt [EMAIL PROTECTED] http://rp-online.de
(prerelease) (SUSE Linux)
Any idea what's going wrong? Did the wxWidgets include structure change
recently?
Ciao,
Thomas
--
Thomas Pundt [EMAIL PROTECTED] http://rp-online.de/
make all-recursive
make[1]: Entering directory `/home/pundt/projects/pgadmin3'
Making all in i18n
/home/pundt
sorry, wrong list!
Ciao,
Thomas
--
Thomas Pundt [EMAIL PROTECTED] http://rp-online.de/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
--
Thomas Pundt [EMAIL PROTECTED] http://rp-online.de/
---(end of broadcast)---
TIP 6: explain analyze is your friend
| the shell?
yes; the following should work:
#!/bin/bash
psql _EOT_
ALTER USER foo with encrypted password 'bar';
CREATE USER foo;
CREATE DATABASE bar owner foo;
_EOT_
Ciao,
Thomas
--
Thomas Pundt [EMAIL PROTECTED] http://rp-online.de/
---(end of broadcast
On Monday 31 July 2006 10:06, Aaron Bono wrote:
| Is there a way I can tell PostgreSQL to give session a low priority so even
| if it does take the full CPU, it only does so if it would otherwise be
| idle?
the nice command might do what you want...
Ciao,
Thomas
--
Thomas Pundt [EMAIL
.
there's a Perl script in the PostgreSQL contrib/oracle directory, that does a
good job after some tweaking.
Ciao,
Thomas Pundt
--
Dr. Thomas Pundt [EMAIL PROTECTED] http://rp-online.de/
---(end of broadcast)---
TIP 5: don't forget
14 matches
Mail list logo