"shreedhar" <[EMAIL PROTECTED]> writes:
> I would like read time taken by each query in my triggers.
> so i created a temporary table and inserted timestamp before i start qurey
> and inserted again timestamp after completion of the query. But i am getting
> same time. How can I get the time taken
One of the options you can specify in postgresql.conf, is to write to log the
amount of time of each query. That should give you the precision you need,
although of course you need to look at a log file and not at a DB table...
If you try this approach, I recommend you specify printing out the
Hi All,
I would like read time taken by each query in my triggers.
so i created a temporary table and inserted timestamp before i start qurey
and inserted again timestamp after completion of the query. But i am getting
same time. How can I get the time taken by each query.
Regards,
Sreedhar
"Faith
Minghann Ho <[EMAIL PROTECTED]> writes:
> Can I logon to other server, say "B Server" and start Postmaster using the
> database cluster PGDATA which I created from "A Server".
Not when they're not the same machine architecture.
> I tried to do this, but got a msg say:
> FATAL 2: The database c
Frans Haarman <[EMAIL PROTECTED]> writes:
> I tried:
> local all password
> but then it asks for a password when booting the server, and I would
> like to have this done automaticly.
You could tell the pg_ctl script not to try to check whether the
postmaster started; then it won't need to connect
I just found the solution in the docs (DOH!):
LD_LIBRARY_PATH=/usr/local/lib:/usr/local/ssl/lib
export LD_LIBRARY_PATH
Andrew Sullivan wrote:
On Wed, Jan 22, 2003 at 12:27:40PM -0600, Matt Mello wrote:
I'm having trouble compiling pg7.3.1 for Sol7.
The configure command I used was:
./configure
On Tue, Jan 21, 2003 at 20:14:56 +0100,
Frans Haarman <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am building a webapplication for school, as a project.
>
> Basicly I want users to connect with their postgresql password an
> username.
>
> I tried:
> local all password
>
> but then it asks for a pa
On Wed, Jan 22, 2003 at 12:27:40PM -0600, Matt Mello wrote:
> I'm having trouble compiling pg7.3.1 for Sol7.
>
> The configure command I used was:
> ./configure --prefix=/usr/local/pgsql731 --enable-multibyte --with-java
> --enable-syslog --without-readline
>
> I get the following error:
> ld.so.
I'm having trouble compiling pg7.3.1 for Sol7.
The configure command I used was:
./configure --prefix=/usr/local/pgsql731 --enable-multibyte --with-java
--enable-syslog --without-readline
I get the following error:
ld.so.1: ./conftest: fatal: libz.so: open failed: No such file or directory
(I am
Hi,
I have problem with SuSE Linux 8.1 and PostgreSQL 7.3 (all SuSE built
packages).
PostgreSQL server (which is launched via "rcpostgesql start") refuses
connections from localhost (to any database), whenever I am trying to
connect with phpPgAdmin or pgaccess with message "blah blah blah...
Thanks, Andrew for your suggestion. I should change 255.255.0.0 to
255.255.255.255 to allow users of the PC to access the database.
zhiqiang
At 13:40 21/01/03 -0500, you wrote:
Be careful with your pg_hba.conf entries (read
the comments in the file itself, they are lengthy but useful). What
yo
Hi
One question about Postgresql admin:
On "A server", I use "initdb" to create a database cluster PGDATA on a "file
server".
Can I logon to other server, say "B Server" and start Postmaster using the
database cluster PGDATA which I created from "A Server".
I tried to do this, but got a msg
Thank Leland and Andrews for your help.
I successfully use pgaccess to add users and now can start postgresql as a
normal user.
However, it seems pgaccess requires TCP/IP port connection so I have to
include
host allIP_address_of_pc255.255.0.0 trust
in the
Hi,
I am building a webapplication for school, as a project.
Basicly I want users to connect with their postgresql password an
username.
I tried:
local all password
but then it asks for a password when booting the server, and I would
like to have this done automaticly.
Basicly I want everybody
Make sure you have started the server allowing TCP/IP connections (-i
option form postmaster command). Otherwise, only local Unix domain
socket connections are accepted.
Regards,
Raul Gutierrez
"Andrei Verovski (aka MacGuru)" wrote:
>
> Hi,
>
> I have problem with SuSE Linux 8.1 and PostgreSQ
On Wednesday 22 January 2003 10:35, Andrei Verovski (aka MacGuru) wrote:
> PostgreSQL server (which is launched via "rcpostgesql start") refuses
> connections from localhost (to any database), whenever I am trying to
> connect with phpPgAdmin or pgaccess with message "blah blah blah...
> refused co
Hi,
I have problem with SuSE Linux 8.1 and PostgreSQL 7.3 (all SuSE built
packages).
PostgreSQL server (which is launched via "rcpostgesql start") refuses
connections from localhost (to any database), whenever I am trying to
connect with phpPgAdmin or pgaccess with message "blah blah blah...
I have tried to perform a cryp authentication but it seems not to work
if the user passwords are stored md5-encrypted in the database. Is this
behaviour normal?.
Regards,
Raul Gutierrez
---(end of broadcast)---
TIP 2: you can get off all lists at on
18 matches
Mail list logo
