On 2/11/11 9:09 AM, Frederiko Costa wrote:
> Paying close attention to details to avoid any corruption issue in a
> shared environment, I don't think it would be a problem going for NFS.
FYI -- beware of NFS related kernel bugs in recent Red Hat 5.x kernels:
http://archives.postgresql.org/pgsql-h
Kevin Grittner wrote:
> "Pankaj Mandal (pmandal)" wrote:
>
>> creating template1 database in
>> C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/base/1
>> ...
>> initdb: could not execute command
>> ""C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/
>> postgres.exe" --boot
Thanks Tom.
Unfortunately, none of the tables oid column have a unique index on them at
this time. Will add them to adjust for this.
You mentioned "performance glitches". What would those be? Errors or system
performance slowdowns.
Joseph Lipker
>Weyerhaeuser Real Estate
What it is appears to be doing is restarting from beginning.
What I am concerned about is when the 8.1.9 version assigns an oid that already
exists.
Any help on why this is happening would be appreciated.
Thanks,
Joe
Joseph Lipker
Weyerhaeuser Real Estate Company - IT Department
EC3-3C8
Federal Way
hope don't have to re-install
Postges, that would be a real bummer.
--Joe
On Thu, 2006-12-21 at 00:47 -0500, Tom Lane wrote:
> Joseph McClintock <[EMAIL PROTECTED]> writes:
> > Now our database has grown and the pg_dump give me a 2.1 GB file which
> > is taking 1
I have inherited the on going management of our company's PostgreSQL 8.0
database. I'm having a very serious problem with the restore process.
I've been running periodic pg_dumps from our production database and
then restoring the data on our development system. That has been working
find until now
unsubscribe
--Joseph M. Day
Global Innovative
Solutions
651 W. Washington Blvd
Chicago, IL 60661
(312) 224-2703 :P
(312) 421-8557 :F
(312) 371-3054 :C
--CONFIDENTIAL: This e-mail, including its
contents and
I was talking to someone just recently who was saying that they
were thinking about going with Oracle rather than Postgresql
because Oracle has a their story in place about how to do
disk encryption. So I am of course, looking into how to do it
with Postgresql...
(As to why you would *care* ab
Joseph M. Day wrote:
>> I am trying to convert a MSSQL DB thats roughly 45GB, to Postgres. I
>> am
>> trying to find the equivalent of Full / Incremental / Differential
>> backups. It looks like pg_dump is the equivalent of a full backup,
but
>> how do I keep t
backup.
To
keep the same functionality, I will need a full backup once a week, and a
differential once a day.
Thanks,
Joe,
Joseph M. Day Global Innovative
Solutions
Hello All,
I cannot re-create a database properly.
I did a dump all of one database that runs on production.
I copied the dmp file to dev environment, DROPped the existing database, CREATEd
the database anew and then ran the dump in psql to recreate the database.
The database (and/or db serv
I'm new to PostgreSQL and I was wondering if there were any tips or tricks
to admining a postgre db and if there are any tools like phpmyadmin for
postgre.
TIA
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org
Political Activist Extraordinaire Peace, Life, Liberty
&quo
ially about how to set these params and
what the defaults are (the official docs don't say much)?
Thanks.
--- Gaetano Mendola <[EMAIL PROTECTED]> wrote:
> Joseph Lemm wrote:
> > IN RELATION TO THIS POST:
> >
> > On Sun, Jan 26, 2003 at 06:31:50PM +0530, shreedhar wr
IN RELATION TO THIS POST:
On Sun, Jan 26, 2003 at 06:31:50PM +0530, shreedhar wrote:
> Hi All,
>
> Before indexing query plan was showing cost as 40.00, after indexing query
> plan again showing as 'seq scan' and cost as 3060.55.
> The field which i indexed is primary key to this table.
> May i k
> --
> Bruce Momjian| http://candle.pha.pa.us
> [EMAIL PROTECTED] | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
--
Joseph Shraibman
[EMAIL PROTECTED]
Increase signal to noise ratio. http://www.targabot.com
Help me for "DBI->connect failed: Sorry, too
many clients already."my cgi program is
test.cgi:###require
"./connectdb.pl";&connectdatabase();$query="select count(*) from
messages";$sth=$dbh->prepare($query);$sth->execute();$count=$sth->fetchrow_array();print
"Content-typ
my cgi program is
test.cgi:###require
"./connectdb.pl";&connectdatabase();$query="select count(*) from
messages";$sth=$dbh->prepare($query);$sth->execute();$count=$sth->fetchrow_array();print
"Content-type: text/html\n\n";print
<<"TAG"; The count is
$count. TAGexit
0;#
Ok, once again let me make this clear...
We are not thinking of using access for our dataserver, your right, its NOT
a data SERVER. My question simply was, why does a program like access, which
is not a data server, outperform pgsql in our comparison??
I know if we loaded it down with large amou
t do it
for this test.
I am a believer in Linux, and the open source revolution, and I didnt mean
for this to be one of those "NT vs Linux" posts!
Joe Sircy
Webmaster
dnhawaii.com
- Original Message -
From: "Gavin M. Roy" <[EMAIL PROTECTED]>
To: "The Hermi
I would like to know why access is outperforming
pgsql in a simple database setup. I have the exact same databases, one in
access, the other in pgsql, on the same server, a linux box running redhat 6.2.
They are being accessed by an asp page running IIS
4 on a NT box ( i cant change that).
20 matches
Mail list logo
