Dear Anjan Dave ,
Upgrading from 7.2.4 (RH 8) to 7.4 (RH9)
I would like to start planning on
upgrading a few servers from RH8 to RH9, essentially, also upgrading
Postgres from 7.3.2 to 7.4 from the OS.
There's also a box with RH7.3
(postgres 7.2.1) that could be upgraded to RH9 an
# include
# include
# include
int main()
{
PGresult *result;
PGconn *conn;
int feild;
printf("successful");
conn = PQconnectdb ("ashok");
result = PQexec (conn, "select * from bill");
feild = PQntuples (result
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 09 December 2003 08:21 pm, Bhartendu Maheshwari wrote:
> Dear Hal, Frank, Oli and all,
>
> I understand what you all trying to say, I know this is not good way of
> designing, but we are planning for using the database for the keeping
> mobi
Dear Hal, Frank, Oli and all,
I understand what you all trying to say, I know this is not good way of
designing, but we are planning for using the database for the keeping
mobile transactions and at the same time we need to provided the HA
solutions. The one solution i derive from the discussion t
On Tuesday 09 December 2003 03:43, Sai Hertz And Control Systems wrote:
> Dear Robert Treat ,
>
> First of all accept gratitude for answering the question
>
> >phppgadmin=# set autocommit = off;
> >ERROR: SET AUTOCOMMIT TO OFF is no longer supported
> >phppgadmin=#
>
> Now does this mean that the
Title: Upgrading from 7.2.4 (RH 8) to 7.4 (RH9)
Hi,
I would like to start planning on upgrading a few servers from RH8 to RH9, essentially, also upgrading Postgres from 7.3.2 to 7.4 from the OS.
There's also a box with RH7.3 (postgres 7.2.1) that could be upgraded to RH9 and Postgres 7.4.
Title: -- CONFIDENTIALITY NOTICE --
I'm assuming you are using pg_dumpall for your backups. In that
case, i'd restore the instance somewhere else, and pg_dump the one
database.
At 09:12 AM 12/9/2003, Jodi Kanter wrote:
I am working with someone who has
been running creating and maintaining his ow
Erwin Brandstetter wrote:
> people.debian.org has been down since the debian hack.
> I am also desperately looking for postgresql 7.4 on debian woody.
> Is there a trusted mirror of people.debian.org or any other source to
> get these .debs?
For the time being, I've copied Oliver Elphick's 7.4/woo
Jose Mendoza wrote:
How can be efectivly configured the PostgreSQL to run in a machine with
2 CPUs Xeon 2.4 GHz and 4GB of RAM? The PostgreSQL work with the 2
processors?
I had run tests and the tiems is always the same that in a computer with
1 CPU pentium 4 2.4GHz and 2GB RAM.
The way it wo
Here are few links to get you started.
Intro info about PostgreSQL
http://www.postgresql.org/docs/aw_pgsql_book/index.html
Conversion to Oracle:
http://techdocs.postgresql.org/redir.php?link=http://www.samse.fr/GPL/ora2pg/ora2pg.html
http://techdocs.postgresql.org/redir.php?link=http://www
Jose Mendoza wrote:
> How can be efectivly configured the PostgreSQL to run in a machine
> with 2 CPUs Xeon 2.4 GHz and 4GB of RAM? The PostgreSQL work with the
> 2 processors? I had run tests and the tiems is always the same that
> in a computer with 1 CPU pentium 4 2.4GHz and 2GB RAM.
PostgreS
I am a newbie and need to find out if
PostgreSQL is a good replacement for Oracle. I need to find out the best
way to import data from Oracle to PostgreSQL. I also need to find out what
the DBA capabilities are of PostgreSQL compared to that of Oracle. This is
something that we are lookin
"Miquel van Smoorenburg" wrote:
> It sure is.
> www.mail-archive.com/[EMAIL PROTECTED]/msg71008.html
Thnax for the hint - but it sure ain't.
people.debian.org has been down since the debian hack.
I am also desperately looking for postgresql 7.4 on debian woody.
Is there a trusted mirror of peop
-- Forwarded message --
Date: Tue, 9 Dec 2003 12:55:55 +0100
From: Ferdinand Smit <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [ADMIN] Full textsearch & gist
Hi,
I'm experimenting with tsearch2. It works very good, but i have a few
questions:
- Is there a tsearch maillingslis
Can anyone tell me, what harm would setting a field size to 1000 characters do to the size?
By increasing the size, will the database require more
space? Or does it only consume space if there is data in the field only?
Regards,
Ganesan
Hi,
I am trying to port from oracle database to postgres. I was not able to
port Oracle synonyms to postgres. I appriciate if anybody can give a
solution.
Thanks and Regards
Sachdev
-
This email was sent using DACafeMail.
Get Your FREE 25 MB eMail Accoun
How can be efectivly configured the PostgreSQL to
run in a machine with 2 CPUs Xeon 2.4 GHz and 4GB of RAM? The PostgreSQL work
with the 2 processors?
I had run tests and the tiems is always the same
that in a computer with 1 CPU pentium 4 2.4GHz and 2GB
RAM.
I intend to use the postgr
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
> I am trying to port from oracle database to postgres. I was not able to
> port Oracle synonyms to postgres. I appriciate if anybody can give a
> solution.
>
> Thanks and Regards
> Sachdev
I'm brand new to PostgreSQL and face the
Jodi Kanter wrote:
I am not sure I understand your question. why does the type of backup
matter? It is a tape backup and it includes the entire /var directory
where the pgsql directory exists. I am trying to determine what
particular files need to be retrieved in order to restore the database
a
Jodi Kanter wrote:
> I am not sure I understand your question. why does the type of backup
> matter? It is a tape backup and it includes the entire /var directory
> where the pgsql directory exists.
That was the missing piece of information.
> I am trying to determine what
> particular files need
Kris Kiger wrote:
Is there a way to force a shared object to reload? I've compiled a new
version of a .so, but postgres seems to be pulling the old version out
of memory. I've tried deleting the .so and recompiling it, but postgres
is insistant, for some reason, of using the old version. Any
I am not sure I understand your question. why does the type of backup
matter? It is a tape backup and it includes the entire /var directory
where the pgsql directory exists. I am trying to determine what
particular files need to be retrieved in order to restore the database
as it existed yester
Is it a postgres shared object only? Then shuting down and restarting
postgres should have worked. If it is a OS shared object then my best guess
is postgres will see it already in memory and not reload the object/lib. In
which case you will need to bounce the OS. Is it possible another program
Kris Kiger wrote:
> Is there a way to force a shared object to reload? I've compiled a
> new version of a .so, but postgres seems to be pulling the old
> version out of memory. I've tried deleting the .so and recompiling
> it, but postgres is insistant, for some reason, of using the old
> version
Jodi Kanter wrote:
> Is there anyway that I can assist him in retreiving his tables from
> backup tapes? I am not sure how or where that data is stored.
Tell us more about how the backup was made, then we can tell you more
about how to restore it.
---(end of broadcast)--
Is there a way to force a shared object to reload? I've compiled a new
version of a .so, but postgres seems to be pulling the old version out
of memory. I've tried deleting the .so and recompiling it, but postgres
is insistant, for some reason, of using the old version. Any ideas?
Thanks for
I am working with someone who has been running creating and maintaining
his own database. He somehow managed to blow away his database and
needs to restore. However, he has not been running regular dumps
because he figured the tape backups were enough.
Is there anyway that I can assist him in r
On Tue, 9 Dec 2003, Chris Travers wrote:
> Case in point:
>
> MS Access was designed to have multiple database managers manipulating
> the files themselves directly and uses another file for locking
> information. However-- as anyone who has ever worked with the process
> will tell you: Don't do
Case in point:
MS Access was designed to have multiple database managers manipulating
the files themselves directly and uses another file for locking
information. However-- as anyone who has ever worked with the process
will tell you: Don't do it. Data corruption (often unrecoverable) will
resul
Hello Bhartendu,
It happens that I was just talking to Sam on irc, and he's gone to lunch,
so I'll have a shot at this.
This should never work for any respectable DBMS. The DBMS is what
manages access to the data files. The DBMS does the locking and
concurrency control, and state information ab
On Tue, 9 Dec 2003 18:03:31 +0530
[EMAIL PROTECTED] wrote:
> Dear Sam,
>
> Thank you for the quick response.
>
> Can I you tell me why its not possible, it is possible with mysql then
> why not with postgres. Actually I am working on High Avaibility
> framework, and its our need, we can't make a
Dear Sam,
Thank you for the quick response.
Can I you tell me why its not possible, it is possible with mysql then
why not with postgres. Actually I am working on High Avaibility
framework, and its our need, we can't make a separate database server. I
want to read/write and then close the file, v
Hi,
I'm experimenting with tsearch2. It works very good, but i have a few
questions:
- Is there a tsearch maillingslist ?
- How can i create a muticolumn index of an date and a text field, so i for
example can textsearch in de last few days.
CREATE INDEX test_ix ON test USING gist(date,tsvect
Don't do that This absolutely cannot be done in any sane way.
Instead, consider locating the database itself on one server, and then
having multiple other servers running the client application.
On Tue, 9 Dec 2003, Bhartendu Maheshwari wrote:
> Dear All,
>
> I am working in Linux 8.0 and run
Dear All,
I am working in Linux 8.0 and running postgresql 7.2. I am trying to
access same data files from the two postgres daemons. I mean there are
two PC's running with postgres and one NAS server where data files are
kept. To run postgres on the machines I first mount the NAS file system
and t
Dear Robert Treat ,
First of all accept gratitude for answering the question
phppgadmin=# set autocommit = off;
ERROR: SET AUTOCOMMIT TO OFF is no longer supported
phppgadmin=#
Now does this mean that their must exist some PHP.INI file option that
will make client side auto commit on
Bu
36 matches
Mail list logo