Peter Schmidt wrote:
>
> PostgreSQL v7.0.2
>
> My company is looking for a way to implement failover w/Postgres.
>
Hi Peter,
We have "fight" with this kind of stuff and found two directions:
-software RAID 1 with nbd (for nbd you can search http://freshmeat.net
site)
-another toy named drbd (h
Nathan,
Thanks for your response. It is great to know that Postgres is working out
fine. However, I don't understand what "Vaccum of the DB" means nor what
the "WAL" functionality is. If you could briefly explain these, that would
be great.
Thanks again!
-ngd.
> The main problem that you have
Title: RE: [GENERAL] info please
For an SQL tutorial try http://sqlcourse.com/ but if you want information on PostgreSQL then look at http://www.postgresql.org/users-lounge/docs/7.0/tutorial/ which is not really written for beginners but if you persist you should get there in the end ;).
Hope
I use DBD/DBI in perl.
use DBI;
my $dbh =
DBI->connect("dbi:Pg:dbname=YourDatabase;host=localhost",'username','passwor
d');
my $sth = $dbh->prepare("select * from my_view");
$sth->execute;
my @row;
while (@ row = $sth->fetchrow_array) {
print join("\t",@row); #or whatever
}
$sth->finish;
$db
El Mar 12 Dic 2000 11:05, Bruce Momjian escribió:
>
> I thought I fixed that, but it seems to have moved again. Vince, is
> this the page that gets generated automatically?
Sorry, but where (in which manual) can I find specific information on how
TOAST works, how to use WAL, and how to make a g
Nikhil,
Vacuuming the DB removes deleted entries from the database as they are not
actually deleted when you use SQL to delete them, just marked as deleted.
This operation clears up space and rearranges the data. If you don't
perform many deletes, you may not need to run this. The only wrinkle
All,
I have already posted this message yesterday but didn't get any reply yet...
Please help me with this..I am having trouble doing db authentication with
'pg_hba.conf' file..
I have added two users using 'CREATE USER' command for a db. And then I have
created two separated password file to do
hi
If getting the output of the query is all u want then u can spol the
output of the query to a file..
I think it is done using
\o ..
Hope this helps
Annad
On Tue, Dec 12, 2000 at 04:36:10PM +, Steve Heaven wrote:
>The COPY TO filename doesnt seem to work.
>Copying a table works OK.
I've got an articles table where I want to store texts, of which several translations
exist. Thanks to TOAST I can now store texts of arbitrary length directly in the table,
which is already a big advantage over stuffing them into the file system and trying to
keep the database and file system in
Tom,
I have that 'local all trust' line commented out. And there is no other
entry in the file at all...
And what do you exactly mean by connecting via IP??? I assume that I am
connecting through UNIX socket because when I commented out the
local db1 crypt file1.dat
local db2 crypt
Niral Trivedi <[EMAIL PROTECTED]> writes:
> Also, I have added separate lines in 'pg_hba.conf' file for two db as
> follows:
> local db1 cryptfile1.dat
> local db2 cryptfile2.dat
That looks correct as far as it goes.
> But problem is
hi,
i have an apache private directory and i would like to manage the
user&pass from a postgresql database. i think there is something like
mod_auth_pgsql but i do not know how can i use it. (i do not have mysql)
this is the current configuration:
AuthName "ZONA RESTRINGIDA"
AuthType B
On Tue, 12 Dec 2000 [EMAIL PROTECTED] wrote:
> Hello, can you PLEASE send me some information on what this is all about.
> I'm lost here. I'm brand new to the whole SQL language and I need all the
> help I can get.
> Thanks,
Sounds like trolling for e-mail addresses.
Sorry but I'm not an
Hi,
I came across an anomaly yesterday which I would like clarified. I am using
6.5.3 but I don't know whether this is version specific.
I created a new db user with a name that was 14 characters long, I allowed
createuser to also create a dbase of the dame name. So far so good. There
is no corr
Hi All
Any one know if Postgres have a support for the Hebrew charset.
like when sorting with 'order by'
--
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-6-6925757
Fax: 972-6-6925858
http://www.canaan.co.il
--
is there some sort of standard init script
availiable? I know the redhat ones don't seem to work in some cases for
postgres7.1beta1
Mike
"Schmidt, Peter" <[EMAIL PROTECTED]> writes:
>> Seems like this still means a single point of failure, ie the NFS box. So
>> what's the point?
> The idea is to have a failover for postmaster itself. I realize you stated
> that postmaster crashes are rare, but if the primary machine goes down we
Could anyone tell me how can I write the applet to connect the
PostgreSQL?
I have installed the Postgresql 7.0.3 RPM on RedHat 6.2 server and try
to write the applet program to access the database. But the following
error make me confuse :
java.lang.ClassNotFoundException: java.io.FileNotFoundE
Title: RE: [GENERAL] Postgres failover implementation
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 10:10 AM
>Performance across an NFS mount will doubtless suck badly.
It's a fact of life at this point. I'm hoping performance won't
I putting together a small (10 tables) postgresgl database for a non-profit
organization, and would like to use an entity relationship diagram
tool. They would like to be maintain it in the future, using a tool that
preferably runs on a Windows client. Are there any decent tools available
th
http://www.heraut.demon.nl/
I've only played with it and stopped because the SQL it generated was a
little odd (but maybe I'm just not thinking straight). It's the only one
I've ever found that supports mysql/postgresql though.
-philip
On Wed, 13 Dec 2000, Phil Glatz wrote:
> I putting toget
> I putting together a small (10 tables) postgresgl database for a
non-profit
> organization, and would like to use an entity relationship diagram
> tool. They would like to be maintain it in the future, using a tool that
> preferably runs on a Windows client. Are there any decent tools availabl
Uh, I think I was wired rather the wrong way up, this question is
confused. What a little fresh air can do. Cycling home from the office
cleared the confusion in my head: It is of course nonsense to store all
translations in a single row, also to have different tables for
different languages. You
Has anyone experienced referential integrity (RI) problems while restoring
data from a dump? Like, if the dump doesn't restore the data in the right
order, then primary keys might not be in place before the foreign keys are
restored. I want to know this from people who have experience before
On Wednesday 13 December 2000 17:04, Robert B. Easter wrote:
> Has anyone experienced referential integrity (RI) problems while restoring
> data from a dump? Like, if the dump doesn't restore the data in the right
> order, then primary keys might not be in place before the foreign keys are
> rest
On Wed, Dec 13, 2000 at 05:30:49PM -0500, Robert B. Easter wrote:
> On Wednesday 13 December 2000 17:04, Robert B. Easter wrote:
> > Has anyone experienced referential integrity (RI) problems while restoring
> > data from a dump? Like, if the dump doesn't restore the data in the right
> > order,
One problem: use "org.postgresql.Driver", not "postgresql.Driver".
I don't write applets. Can they have jars in the classpath or do you
have to extract all the .class files?
--
Bruce R. Lewis http://brl.sourceforge.net/
For example
create table testTable (
id integer,
name char(20)
);
an ASCII file format with field separator "|" is
1|Hello|
2|Again|
..
There is a way to do this in Oracle, Sybase, Informix and MySQL.
But I want to know how to do this in PostgreSQL.
Please don't tell me use pg_dump, becau
On Wednesday 13 December 2000 17:45, Matt Beauregard wrote:
> On Wed, Dec 13, 2000 at 05:30:49PM -0500, Robert B. Easter wrote:
> > On Wednesday 13 December 2000 17:04, Robert B. Easter wrote:
> > > Has anyone experienced referential integrity (RI) problems while
> > > restoring data from a dump?
I'm not sure if this helps, but for some reason,
Class.forName("postgresql.Driver") is listed but probably should be
Class.forName("org.postgresql.Driver") ... the driver is actually beneath
the org directory. I'm not familar with linux variants of the PostgreSQL
stuff. Sometimes when in doubt,
http://www.postgresql.org/mhonarc/pgsql-committers/
errors out with:
'Cant load template [search.htm]! '
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
Why is pg_dump not correct? You need to elaborate on the parameters of the
situation.
--rob
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 13, 2000 6:26 PM
Subject: Daily Digest V1 #108
> Daily Digest (mime) - Volume 1 : Issue 108
32 matches
Mail list logo
