hi ppl,
I am using postgres7.3 version.I am unable to find any log.
all the files
1)
/usr/local/pgsql/data/serverlog
2) /var/log/pgsql
etc are empty
pg_xlog and pg_clog directory files dont seem to be meaningful.
i tried
log_connections = truelog_pid =
truelog_statement
Hello,
I have a few questions:
1 - I would like to know if I can install several
installations of PostgreSql on the same machine with silent install (different
ports) ?
2 Can I make a backup of the database without shutting it
down?
3 Is there support for multi-CPU?
4 Is there a
On 9/13/05, Yossi Kachlon [EMAIL PROTECTED] wrote:
1 - I would like to know if I can install several
installations of PostgreSql on the same machine with silent install (different
ports) ?
of course. you can have as many installations as you want (limited by number of ports, memory
Thanks for the quick
answer.
I have two more
questions:
1 Does PostgeSql support partitions and/or
partition views?
2- I tried to install two
installations of PostgreSql on windows-2000 and after the first installation
the wizard ask me if I want to modify or remove the first
Yossi Kachlon wrote:
1 - I would like to know if I can install several installations of
PostgreSql on the same machine with silent install (different ports)
Yes
2 - Can I make a backup of the database without shutting it down?
Yes
3 - Is there support for multi-CPU?
Yes
4 - Is there a
well there is nothing in the /var/log
or /var/lib/pgsql/data
any explanation
or how can i enable logging
i am using postgres7.3 on whitebox linux
4
thanks a lot Tom, it worked.
Dilipan
Tom Lane wrote:
Dilipan Sebastiampillai [EMAIL PROTECTED] writes:
I tried ( after copying thes PGDATA dir obviously ) :
pg_resetxlog /var/lib/pgsql/data/ -f
After that postgreSQL starts but I realised that pg_database is
Hello..
I've installed plperl.so in postgresql lib directory but when I try to create
lang, such error occures:
pgsql2-test:~# su pgadmin
[EMAIL PROTECTED]:/root$ /usr/local/postgresql/bin/createlang -p 5433
plperlu pl
createlang: language installation failed: ERROR: could not load library
Dnia wtorek, 13 września 2005 14:18, Marcin Giedz napisał:
Hello..
O I didn't mention what Linux .
Debian Sarge 3.1
kernel 2.6.12.5
perl lates 5.8.7 from sources
perl 5.8.4-8 from dselect
postgresql 8.0.3 from sources
I've installed plperl.so in postgresql lib directory but when I
Thanks, Tom.
The statement_timeout setting was also raised on the JDBC list, and has been
checked -- there is nothing setting statement_timeout. The connection shows
this value at zero. None of our code contains anything PostgreSQL specific, so
there is nothing in our framework or
One more thought -- I keep coming back to the fact that when we turn on logging
in the JDBC driver on the client side, the problem does not occur. The only
possible reason I can see for this having any affect on the problem is the
small delay introduced by the synchronous logging. Since this
Dnia wtorek, 13 września 2005 14:42, Sergiusz Jarczyk napisał:
Hi Marcin
Marcin Giedz napisał(a):
Hello..
I've installed plperl.so in postgresql lib directory but when I try to
create lang, such error occures:
pgsql2-test:~# su pgadmin
[EMAIL PROTECTED]:/root$
Dnia wtorek, 13 września 2005 17:01, Marcin Giedz napisał:
Additional info: I've also checked plperl with postgresql snapshot - problem
still exists ;( -
didn't anyone have something similar? or maybe I'm only one who uses Sarge
3.1? :D:D
Marcin
Dnia wtorek, 13 września 2005 14:42,
Yogvinder Singh [EMAIL PROTECTED] writes:
I am using postgres7.3 version. I am unable to find any log. =
In 7.3 your best bet is to log via syslog. Set syslog to 2 in
postgresql.conf and adjust the other settings if needed, then make sure
your syslog daemon is configured to put the
I have a vacuuming question.
What does a vacuum have to do when it runs?
The reason I'm asking this question is that we are running a 5 minute
vacuum analyze on a key table in one of our databases to try and
resolve some performance problems. Due to i/o issues, we have
only been running a
Marcin Giedz [EMAIL PROTECTED] writes:
createlang: language installation failed: ERROR: could not load library
/usr/local/postgresql-8.0.3/lib/plperl.so:
/usr/local/postgresql-8.0.3/lib/plperl.so: undefined symbol: Perl_croak
I think you've got some kind of mismatch between the compilation
Dnia wtorek, 13 września 2005 17:24, Tom Lane napisał:
Marcin Giedz [EMAIL PROTECTED] writes:
createlang: language installation failed: ERROR: could not load library
/usr/local/postgresql-8.0.3/lib/plperl.so:
/usr/local/postgresql-8.0.3/lib/plperl.so: undefined symbol: Perl_croak
I think
Kevin Grittner [EMAIL PROTECTED] writes:
One more thought -- I keep coming back to the fact that when we turn
on logging in the JDBC driver on the client side, the problem does not
occur. The only possible reason I can see for this having any affect
on the problem is the small delay
Marcin Giedz [EMAIL PROTECTED] writes:
I don't see any libperl.so :( But doesn't plperl use shared libperl library?
Yeah, it's supposed to. On an FC4 machine I get
$ ldd libplperl.so
linux-gate.so.1 = (0x00682000)
libperl.so =
Hi again
My PostgreSQL (built from sources) is running on Sarge too, bit I didn't
have any such a problems.
What's more, I have both Perls installed in standard places. Try to run
'locate *libperl*' to check
if there isn't more then one on your system.
Sergiusz
Hi
Tom Lane napisał(a):
Marcin Giedz [EMAIL PROTECTED] writes:
I don't see any libperl.so :( But doesn't plperl use shared libperl library?
Yeah, it's supposed to. On an FC4 machine I get
$ ldd libplperl.so
linux-gate.so.1 = (0x00682000)
libperl.so =
I'm having a really hard time coming up with theories about the cause
or things to check.
We ran the test again with logging to disk, and it didn't happen in an
hour of testing. The logging boosted the average run time of the
series of database modificates we attempt as a single transaction
Tom Lane napisał(a):
Marcin Giedz [EMAIL PROTECTED] writes:
I don't see any libperl.so :( But doesn't plperl use shared libperl library?
Yeah, it's supposed to. On an FC4 machine I get
$ ldd libplperl.so
linux-gate.so.1 = (0x00682000)
libperl.so =
Chris Hoover [EMAIL PROTECTED] writes:
there is 1 exception. Everytime there is work to do, it seems to spike our
load from 1 to a load of 3+ for a short time. This tends to cause
significant slowdowns for our customer if they happen to do anything that is
causing the database to access
Sergiusz Jarczyk napisał(a):
Hi again
My PostgreSQL (built from sources) is running on Sarge too, bit I
didn't have any such a problems.
What's more, I have both Perls installed in standard places. Try to
run 'locate *libperl*' to check
Does nothing :( - h???
What packages related to
Marcin Giedz [EMAIL PROTECTED] writes:
Tom Lane napisa³(a):
How big a plperl.so do you have?
~57kB plperl.so
~1.2MB libperl.so
Well, it's not statically linked then. You should go back into
src/pl/plperl and do make clean all so you can see what command was
done to produce plperl.so.
Kevin Grittner [EMAIL PROTECTED] writes:
I'm having a really hard time coming up with theories about the cause
or things to check.
Have you tried strace'ing the backend process to see if you can see a
signal being delivered to it?
regards, tom lane
OK ... I have compiled it once again - really don't know why this time
libperl is visible?:
pgsql2-test:/usr/src/postgresql-8.0.3/src/pl/plperl#
pgsql2-test:/usr/src/postgresql-8.0.3/src/pl/plperl# ldd libplperl.so
libperl.so = /usr/lib/libperl.so (0xb7ed1000)
libdl.so.2 =
Marcin Giedz [EMAIL PROTECTED] writes:
OK ... I have compiled it once again - really don't know why this time
libperl is visible?:
Sounds like you did it wrong the first time ;-)
pgsql2-test:/usr/src/postgresql-8.0.3/src/pl/plperl# ldd libplperl.so
libperl.so = /usr/lib/libperl.so
Marcin Giedz napisał(a):
OK ... I have compiled it once again - really don't know why this time
libperl is visible?:
pgsql2-test:/usr/src/postgresql-8.0.3/src/pl/plperl#
pgsql2-test:/usr/src/postgresql-8.0.3/src/pl/plperl# ldd libplperl.so
libperl.so = /usr/lib/libperl.so
Did you build from source? Did you explicitly enable PL/Perl during configuration?You need to specify --with-perl to configure to get it to build:http://www.postgresql.org/docs/8.0/static/install-procedure.html --Thomas F. O'ConnellCo-Founder, Information ArchitectSitening, LLCStrategic Open
Hi
I need some help implementing Hot
standby.
Here is what I have done.
Create a base backup
select
pg_start_backup(label);
create a tar of data dir.
restore
on standby node
select pg_stop_backup;
ftp WAL
files to standby database;
configure
Ok guys... thanks you both ;) I've installed perl once again into
default location and now IT'S ALIVE !
Thanks once again.
Marcin
---(end of broadcast)---
TIP 6: explain analyze is your friend
Thanks, Tom. An excellent suggestion. (This 50 year old dog has
today learned a new trick.)
There is good news and bad news. The good news is that I found
the cause, and we can keep this from happening with a change on
our end. The bad news is that I think it also points to a backend bug,
Kevin Grittner [EMAIL PROTECTED] writes:
The SELECT statement was easy to find, and it became clear that a
programmer had code which was incorrectly canceling a JDBC
Statement after reaching the end of the (empty) ResultSet. One
time out of 1,799 this was causing the error we were seeing on
Tom Lane wrote:
This has been discussed before (try the pgsql-jdbc list archives).
I believe we concluded that an appropriate fix was to not consider the
cancel request done until the client sees the separate connection
dropped by the postmaster. libpq's cancel functions wait for that to
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Hi,
Is there any way to find out the
information regarding the databases and tables?
I mean,
Details about database like
..the time of creation,User who created it,Last Accessed and the
user...etc
Similarly for the tables .
Also is there any way to list outthe tables
created bya
38 matches
Mail list logo