I'm administering a database that is not immediately a good candidate
for replication via Slony. As an interim solution, I'd like to give
PITR a shot. The primary goal is to have a failover scenario that
allows for recovery within a window that's much smaller than it would
be if the only op
I have a large database (20 Gb) on PostgreSQL 8.1.0 where I need to make a
copy of the structure and also copy the data from a few of the tables
(approximately 40 out of 140, resulting database is approximately 10 Mb)
which have dependencies on each other. The problem I am having is finding
the
Start by taking a gander at:
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
and
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
Why are you using 7.4.8 instead of the current version of PostgreSQL?
Probably because it is what shipping which his copy of Linux :)
Tom Lane wrote:
The rule is very simple: the first entry that is able to match an
incoming connection request is the one that's used. "Match" is on
the basis of connection type (local or TCP) and the requested database
name and user name. When the match occurs, the connection is checked
using t
Given, Robert A wrote:
Greetings,
We are beginning to implement uPortal on Postgresql 7.4.8 on a z/Linux
server. We are interested in obtaining information pertaining to any
modification of the configuration parameters as distributed with the
DBMS..
Start by taking a gander at:
http:/
Am Donnerstag, 2. März 2006 16:53 schrieb Olivier Boissard:
> I would like to call an external "shell" script from a trigger.
> I use actually pgplsh. It works fine but there is a lot of problem with
> special characters.
Details please.
> In addition I can not compile this language any more..
D
Title: Postgresql and uPortal
Greetings,
We are beginning to implement uPortal on Postgresql 7.4.8 on a z/Linux server. We are interested in obtaining information pertaining to any modification of the configuration parameters as distributed with the DBMS. Can anyone provide details on cha
I would like to call an external "shell" script from a trigger.
I use actually pgplsh. It works fine but there is a lot of problem with
special characters.
In addition I can not compile this language any more..
Do you know others solutions to call an external script?
Is it possible with python
Title: sql copy does not work
Hi Jason
You are a genius:-)) It worked
I am fighting with it since a
week...
Thank you so much.
Regards
Aniko
From: Jason Minion
[mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 3:49
PMTo: Badzong Aniko, FX-IT-SDY-CIA-MSG;
pgsql-admin@postgres
Title: sql copy does not work
You probably need to add escaped slashes into your perl
string to escape the quotes on the command line. Maybe try:
system ("su - postgres -c \"echo \"\\\"\"copy test from
\'/data/log/20060115.out\'\;\"\\\"\" | psql imsdb\"");
Jason Minion
From: [EMAIL PROT
Not the real solution for your problem, but if you are already using perl, then why not give a try to Pg?
http://search.cpan.org/search?query=Pg&mode=all
Regards,
G.-On 3/2/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]
> wrote:
Hi
I have a problem with the copy command. I need to write a P
Title: sql copy does not work
Hi
I have a problem with the copy command. I need to write a Perl script where I copy the log files into the database.
If I use the copy following syntax in shell script it works, but I need to use it in Perl.
In shell script look like this and it works.
s
12 matches
Mail list logo
