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 "
order by the time was jus
1 or 2 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 http://
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
ader in a separate file and do something like
|
| (cat 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
t = warning
log_min_duration_statement = 1000
log_line_prefix = '[%u:%d:%t] '
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
| When I run the Unix ps command 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
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
that don't 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 <[EMAI
sorry, wrong list!
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
50117
(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&
the "psql"
command.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
TIP 6: explain analyze is your friend
nd them to postgres from
| 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/
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 Pun
.
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&
14 matches
Mail list logo
