Hi!
I have interesting in 2 problems:
1. I have xxx.so written in C for postgres countaining function yyy(). May
yyy() refers to postgres with other requests?
yyy() {
...
PQexec("... any request ...");
...
}
application:
select * from aaa where yyy()='bbb';
2. I make module xxx.so contaning fu
On Wed, 11 Aug 1999, Darren Chan wrote:
> I have 2 servers running PostgreSQL 6.5.1 with different databases. Is
> it possible to transfer one of the databases from one machine to
> another?
> I tried pg_dump streamdb > streamdb.pgdump to backup
> and cat streamdb.pgdump | psql streamdb to restore
> If the machines are identical distributions, libs, and layout you can copy
> over the entire pgsql tree for your data rollover. You won't have any time
> to test on your very loaded server before you know if something is wrong but
> you might just want to keep a copy around so that two mv's wi
Hello,
I have 2 servers running PostgreSQL 6.5.1 with different databases. Is
it possible to transfer one of the databases from one machine to
another?
I tried pg_dump streamdb > streamdb.pgdump to backup
and cat streamdb.pgdump | psql streamdb to restore
but got the message "Connection to databas
If the machines are identical distributions, libs, and layout you can copy
over the entire pgsql tree for your data rollover. You won't have any time
to test on your very loaded server before you know if something is wrong but
you might just want to keep a copy around so that two mv's will restor
I am installing posgresql 6.5.1 on a Ultra 10 sparq 333mhz 256 mg's
ram and Solaris 5.7
after compiling postgres I created a user "postgres" and added the proper
paths in his .profile.
when I do a initdb it errors on pglib, pgdata, username. if I tell initdb
all of those it errors on not findi
My guess would be the startup scripts in this case. Possibly you are
starting postgres without the -o -F options, which would cause it to be
considerably slower...
Gregory S. Youngblood
ext 2164
-Original Message-
From: Darren Greer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August
> getrusage() is used. xxx - sec in system mode, yyy - in user.
>
> BTW, upgrade to 6.5.X - vacuum is now (much) faster in some cases.
Ahhh, ok, makes sense :)
And we are looking into a way to upgrade from 6.4.2. Problem is that
it is a production system that is very busy 24x7, as we have cus
NoI haven't vacuumed in a whilebut this change in speed happened
almost overnight. Is that possible?
Darren
- Original Message -
From: Lamar Owen <[EMAIL PROTECTED]>
To: Darren Greer <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 10, 1999 12:21 PM
Subject: Re:
Darren Greer wrote:
>
> Hello all. On another maybe related note to my recovery issues, I am
> noticing a drastic slow down with my database. A couple of days ago, when
Have they been vacuumed recently?
Lamar
Hello all. On another maybe related note to my recovery issues, I am
noticing a drastic slow down with my database. A couple of days ago, when
deleting 20,000 rows of data, it would take roughly 5-10 seconds. Now it is
taking about 2-5 minutes for 2,000. Is there anything I can check to see if
Ok.thanks to the help of Oliver Elphick, I know have the correct version
of Postres installed, and my old data is there and working fine (ie I can do
a psql -c "select count(*) yada yada" dbname, with success). My problem now
is that, when I try and go into psql, I get a Segmentation fault.
I am running Postgres on a Linux 2.2.11 box with 2 Pentium III 550
processors. It appears that postgres is only using the first processor
and not both. Is there a compile-time switch I need to enable to make
postgres use both processors or is this not currently supported?
Also... does anyone ha
Darren Greer wrote:
>
> Somehow, our version of postgres got upgraded during some system
> maintenance. To make a long story short we had to completely re-install
> Posgres (6.3-15). Now I have originaly data directory backed up, but have
> found no way to import the data. I tried simply repla
OkI had mentioned that the PG_VERSION file in my original data directory
says 6.4. Well, I installed postgres version 6.3 and then copied my original
data directory over the new. This is what I get:
gandalf:/# /etc/init.d/postgresql start
The database is in an older format that cannot be re
One of my other problems is that I dont know what version of postgres I was
running. As far as I knew I was running 6.3, but upon looking at teh
PG_VERSION file of my old data directory, I see that it says 6.4. So I dont
know what version to install. Is there a way to tell from the data
directo
"Bradford L. Barrett" wrote:
>
> Greetings all..
>
> Quick question, hopefully someone can answer for me... We have been
> running PostgreSQL for over a year now, using php3 to interface our
> web site to the db.. current main db size consists of roughly 3 million
> line items (electronic com
Somehow, our version of postgres got upgraded during some system
maintenance. To make a long story short we had to completely re-install
Posgres (6.3-15). Now I have originaly data directory backed up, but have
found no way to import the data. I tried simply replacing the new data
directory wit
Greetings all..
Quick question, hopefully someone can answer for me... We have been
running PostgreSQL for over a year now, using php3 to interface our
web site to the db.. current main db size consists of roughly 3 million
line items (electronic components) split across 10 tables. When we
d
19 matches
Mail list logo
