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
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 ins
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
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 i
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 applicatio
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, September 12, 2005 6:42 PM
To: Lane Van Ingen
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Server Time Setting
"Lane Van Ingen" <[EMAIL PROTECTED]> writes:
>> I am baffled as to why some of the PostgreSQL fun
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 i
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$ /usr/loc
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, Sergiu
"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
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 vacu
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 compi
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_cr
"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 in
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 =>
/usr/lib/perl5/5.8.6/i386-linux-thread-multi
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
---(en
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 =>
/usr/lib/pe
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
from
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 =>
/usr/lib/perl5/
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 acc
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 per
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 plpe
"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
---
Hi
Here is what I have:
[EMAIL PROTECTED]:~$ dpkg -l | grep -i perl
ii libcompress-zl 1.34-1 Perl module for creation and
manipulation of
ii libdbi-perl1.46-6 Perl5 database interface by Tim Bunce
ii libft-perl 1.2-14 Perl module for the FreeType library
ii l
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 => /lib
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/libper
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 (0xb7ed1000
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 Source
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
recove
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,
alt
"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 seei
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 t
---(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 out the tables
created by a
39 matches
Mail list logo
