On Mon, 23 Feb 2004 [EMAIL PROTECTED] wrote:
Hi,
We are running Postgresql 7.3.4. Does anyone know how to make pg_dump
write
dumps larger than 2 GB?? Compilation with D_FILE_OFFSET_BITS=64 gave
no results...
Hi, what OS and such are you running on? I've had no problems on RH7.2
On Wed, 11 Feb 2004, Mark Lubratt wrote:
Interesting discussions on IDE drives and their write caches.
I have a question...
You mentioned that you'd see the problem during a large number of
concurrent transactions. My question is, is this a necessary condition
for the database
ftp3.us.postgresql.org is working for me.
On Tue, 11 May 2004, Thomas Burns wrote:
Hi,
I'm having a really stupid problem -- it seems to be impossible to
download postgre. All of the US mirrors timeout. Is this normal?
There are no apparent problems with my connection.
Thomas E. Burns
On Tue, 11 May 2004, Bjoern Metzdorf wrote:
Hi,
I am curious if there are any real life production quad processor setups
running postgresql out there. Since postgresql lacks a proper
replication/cluster solution, we have to buy a bigger machine.
Right now we are running on a dual 2.4
On Tue, 11 May 2004, Bjoern Metzdorf wrote:
scott.marlowe wrote:
Sure, adaptec makes one, so does lsi megaraid. Dell resells both of
these, the PERC3DI and the PERC3DC are adaptec, then lsi in that order, I
believe. We run the lsi megaraid with 64 megs battery backed cache.
The LSI
On Tue, 11 May 2004, Bjoern Metzdorf wrote:
scott.marlowe wrote:
Well, from what I've read elsewhere on the internet, it would seem the
Opterons scale better to 4 CPUs than the basic Xeons do. Of course, the
exception to this is SGI's altix, which uses their own chipset and runs
On Wed, 5 May 2004, Chris Gamache wrote:
When I run an query (that I have identified as expensive, and non-critical), I
would like to be able to take its priority down a few notches to allow the
standard every-day tasks of the DB to run unhindered. As it stands, postmasters
elbow each other
On Tue, 4 May 2004, Bruno Wolff III wrote:
On Tue, May 04, 2004 at 18:50:09 +,
Bradley Kieser [EMAIL PROTECTED] wrote:
Hi All,
Is this the correct place to submit a bug report or should I do it
somewhere else?
Bugs go to pgsql-bugs, how I don't think this is really a bug, but
On Fri, 30 Apr 2004, kandiah ratnavale wrote:
unable to complete install of PosrtgreSQL without undernoted libraries
libcrypto.so.2
libssl.so.2
need assistance to locate these libraries for download??
earlier request of few days ago not responded to!!
Those
On Sat, 17 Apr 2004, Joseph A. Nagy, Jr. wrote:
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.
My biggest tips would be:
Get to know psql. The postgresql monitor, with history, tab
A couple of points,
1: One might want to look at the global file system, which i think is
still in some kind of active development.
2: Remember when the whole firebirdSQL thing went down and we said no
would ever use the same name as our database for another project??? haha.
The universe
On Thu, 15 Apr 2004, Cris Carampa wrote:
scott.marlowe wrote:
The current king of putting postgresql on multiple platters and getting
best overall performance is a battery backed caching raid controller run
one or more many disk RAID-5 arrays.
I thought the best choice were RAID-10
On Tue, 13 Apr 2004, Stefan Holzheu wrote:
I'd like to alter all columns from type varchar to text. Could I do this by:
UPDATE pg_attribute SET atttypid = 25, atttypmod=-1 where attrelid
=(select oid from pg_class where relname='table_name') and atttypid=1043;
I just tried on a test
On Thu, 8 Apr 2004, hal wrote:
What is the best/simplest way to split:
a database
multiple databases
a table
multiple tables
across more than one disk drive?
I know that this has come up before but I can't find
any info. A pointer to a HOWTO or other info would
On Fri, 9 Apr 2004, Ben Kim wrote:
Dear admins,
I have a table whose primary key is a record_id with serial type.
I would like to know, when I insert a new row, what was the value of the
record_id that I just inserted. Since this is a multi user application, I
cannot simply select max
I replied, and finally got him unsubscribed from the list.
He was just tired of receiving our admin list all the time and couldn't
figure out how to turn it off, so I walked him through the web interface
to get off the list.
On Thu, 8 Apr 2004, Terry Hampton wrote:
Anyone know this
Note that the innefficiency could well lie with Informix's file system
interfacing as easily as it could lie with the operating system. Do they
charge extra for being able to access raw devices or somehow make more
money by supporting them? If so, there could be a clear business case for
On Mon, 5 Apr 2004, Gastón Simone wrote:
Hi all,
I have a slave disk with an old PostgreSQL installation. Now I want to
migrate its information to my new primary disk with a new PGSQL
installation. I have to do it this way because de old disk does not boot as
primary any more. It
On Fri, 2 Apr 2004, Mark Bross wrote:
What is your recommendations for code editin in Postgresql?
I'm a student at Regis university in Denver co.
Do you mean for editing the backend code itself, stylewise, or do you mean
for editing your own code, like plpgsql functions?
I'll assume you mean
For quite some time. I believe the max table size of 32 TB was in effect
as far back as 6.5 or so. It's not some new thing. Now, the 8k row
barrier was broken with 7.1. I personally found the 8k row size barrier
to be a bigger problem back then. And 7.1 broke that in 2001, almost
exactly
On Thu, 1 Apr 2004, Hemapriya wrote:
Hi,
Does anyone know postgres performance in Linux vs Mac
Os.. Pls suggest the best platform to go for..
Generally, linux on X86, dollar for dollar, offers better performance than
the Mac. Even a relatively cheap single CPU ~2GHz machine with 1 gig ram
On Thu, 1 Apr 2004, Bradley Kieser wrote:
I think as far as PG storage goes you're really on a losing streak here
because PG clustering really isn't going to support this across multiple
servers. We're not even close to the mark as far as clustered servers
and replication management goes,
On Thu, 1 Apr 2004, Tony and Bryn Reina wrote:
let alone the storate limit of 2GB per
table. So sadly, PG would have to bow out of this IMHO unless someone
else nukes me on this!
I just checked the PostgreSQL website and it says that tables are limited to
16 TB not 2 GB.
Actually,
On Tue, 30 Mar 2004, Juan Miguel wrote:
This is a little question :
In postgres, delete database dbsample, frees the disk space used for
this DB?, or I have to drop the files manually ?
I wondered this question, because I read that when you delete records,
you must run vacuum for freeing
On Fri, 26 Mar 2004, Radu-Adrian Popescu wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Doug Quale wrote:
| Chris Browne [EMAIL PROTECTED] writes:
|
|
|The FSF characterizes the PostgreSQL license as being an X11 style
|license. They felt a need to distinguish between different
On Thu, 25 Mar 2004, Eric Yum wrote:
Dear Sir
I am a developer of one commercial organization. We are going to develop
some applications with PostgreSQL 7.3.3. I learn from some websites that
it cost no charge for developing software with PostgreSQL in commercial
environment. However, I
On Wed, 17 Mar 2004, Louie Kwan wrote:
Hi All,
I did a pg_dumpall and psql the output and created a db. Basically, I would
like to clean up everything including users and groups.
I tried to do initdb, but it didn't work.
My question is that can I just delete the directory where the
On Fri, 19 Mar 2004 [EMAIL PROTECTED] wrote:
Hi,
Can any body explain me how to set the date style exactly as oracle date
style like dd-mon-.
http://www.postgresql.org/docs/7.4/static/datatype-datetime.html#DATATYPE-DATETIME-OUTPUT
should cover it.
---(end
On Wed, 17 Mar 2004, Marc Mitchell wrote:
This is follow-up to a problem first reported on 3/1/04. The problem
has continued to occur intermittently and recently we experienced the
first occurrence where the first column of a table was the column where
the corrupted and thus we could not
On Mon, 15 Mar 2004, Bruce Momjian wrote:
scott.marlowe wrote:
On Thu, 11 Mar 2004, Christopher Kings-Lynne wrote:
You could also consider not using syslog at all: let the postmaster
output to its stderr, and pipe that into a log-rotation program.
I believe some people use
On Wed, 10 Mar 2004, Erwin Brandstetter wrote:
Hi List!
Howdy!
Short version:
It is for a medium sized database. ~ 50 users, 5GB, biggest table 1
million tupples, 60 tables, lots of indices, triggers, rules, and other
objects.
SNIP!
What will I purchase?
CPU:
Single AMD Opteron.
What version of Postgresql are you running. Versions 7.2 and before would
gladly swap around day / month when they needed to be to fit, and this
caused me a few headaches where I had data feeds that were partially
failing and couldn't figure out why.
On Sat, 6 Mar 2004, Dario Ottaviano wrote:
On Tue, 9 Mar 2004, Mira Kaloper wrote:
Hi,
I have a postgres database that is VERY slow - in one table we have 50
mil records in it.
I have tried to play with postgres.conf file and shared memory but was
not able to speed it up to something that we can work with. We have
apple RAID
On Mon, 8 Mar 2004, gerold kathan wrote:
hi,
i built/installed a pgsql 7.4.1 on a redhat ES3 system. everything works
fine - but connections via tcp from outside are NOT working (as i was
used to in 7.3)
* configured postgresql.conf and pg_hba stuff
= is there a way to check locally
On Sat, 6 Mar 2004, Dario Ottaviano wrote:
Hi, i use Postgresql 7.2 on a windows server (Win 2000 Server).
The problem is that when i write a date into a timestamp field of a table,
it writes it in to No-Europe format.
7.2 had some issues with accepting the wrong date formats and just
On Thu, 4 Mar 2004, Indibil wrote:
Hi:
I have a PostgreSQL 7.2.2 running in a Linux Mandrake 8.2 Server.
I want to upgrade to PostgreSQL 7.3
I would like to accomplish this by installing fit rpm packages, because my
linux skills are limited.
However, there aren't any packages of
On Mon, 8 Mar 2004, mlists wrote:
Can PostgreSQL use multiple processors if they are present in a
computer, and if so, how much will it speed up database server? Tnx in
advance.
Yes, Postgresql can use 1 CPU. Each process can use one, and only one
CPU by itself. however, the OS can use
On Fri, 5 Mar 2004, Silvana Di Martino wrote:
Alle 15:11, venerdì 5 marzo 2004, Alex Page ha scritto:
If you're trying to protect against somebody taking down your server
room door with a sledgehammer, lifting your server out of the rack,
driving it away and booting off an alternative
On Fri, 5 Mar 2004, Silvana Di Martino wrote:
Alle 19:38, venerdì 5 marzo 2004, scott.marlowe ha scritto:
Unfortunately, the new Italian law forces us to take seriously into
account this catastrophic scenario and another one that is almost as
worring: an unfaithful SysAdmin that copies
On Mon, 1 Mar 2004, Bjoern Metzdorf wrote:
Louie Kwan wrote:
If there is no SYSDATE defined in PostgreSQL , what can I do ?
createTimeStamp DATE default (SYSDATE)
Perhaps NOW() ist what you are looking for?
createTimeStamp DATE default 'NOW()'
I don't think
On Thu, 26 Feb 2004, John Allgood wrote:
Hello
I am building a server to run 9 databases. Can I run a seperate
postmaster for each of the 9 databases. I would be setting the port
number to a different value for each db of course. The reason I wish to
do this is so that I can install
On Fri, 20 Feb 2004, Jeremy Smith wrote:
I have newly installed PostgreSQL onto my server, the server's main function
is to serve up a fantasy football site that has a tremendous number of
queries per page. Right now with very low traffic I am seeing a server load
of 2.0+. That got me a
On Fri, 20 Feb 2004, Lamar Owen wrote:
How fast does the page load? That would be the big question. Run apache
bench (ab) against the page and see how many pages per second yu can get. A
load of 2.0, an average CPU of 60-100%, and 7 running processes is not bad at
all. It just means
Are you getting problems with crashing backends in postgresql and such
showing up? I'm wondering if you have bad memory or something like that.
In my experience, Linux/apache/php/postgresql never crashes, it just goes
unresponsive when you get into severe overload.
Is your database vacuum /
On Fri, 13 Feb 2004, Jeremy Smith wrote:
Hi,
my php is not set up for postgres yet. When I try to install it using Build
Apache, I get an error that file libpq-fe.h is not found. Does anyone
know where to get this file and where it should be placed?
It this all installed from source, or
.
On Fri, 13 Feb 2004, Jeremy Smith wrote:
It is a third party utility that installs it by RPMs. It should work the
same way as if I were installing the RPMs command line.
Jeremy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of scott.marlowe
Sent
On Wed, 11 Feb 2004, Jeremy Smith wrote:
Thanks Lamar
I will try that link later, for some reason it's not coming up now. I tried
one of the FTPs off of the postgresql.org site, and the folder for 7.4.1 and
Redhat 7.3 was empty.
Btw, I have removed my RPM installation of 7.4.0, and my
On Thu, 12 Feb 2004, Jeremy Smith wrote:
Scott,
I kept plugging away at it and I now have 7.4.0 installed, and I'm very
happy about it :)
There were a couple of mistakes that I made, one was in not looking at the
order that I was removing the 7.3.3 RPMs. When I would try to remove the
On Thu, 12 Feb 2004, Steve Crawford wrote:
I'm running a reasonable sized (~30Gb) 7.3.4 database on Linux
and I'm getting some weird performance at times.
snip
I am having a similar problem and this is what I've found so far:
During the checkpoint the volume of data that's written
On Wed, 11 Feb 2004, Peter Galbavy wrote:
scott.marlowe wrote:
Oh, spreading misinformation isn't lying? You live in a different
world than I do.
Again, I apologise if you took my comment so strongly. I can understand when
something that someone works on so hard is critisised. OTOH
On Wed, 11 Feb 2004, Jodi Kanter wrote:
Do constraints effect performance significantly?
That depends.
Foreign key constraints on int4 columns or int8 columns (matching of
course) are usually quite fast.
FK constraints on non-int (numeric, text, etc...) tend to be slower.
check constraints
Or maybe rpm -Uvh postgresql-7.4.rpm
would work too.
---(end of broadcast)---
TIP 8: explain analyze is your friend
You need to rpm -e 'oldpostgresqlpackagenamehere' to get rid of 7.3 first.
On Wed, 11 Feb 2004, Jeremy Smith wrote:
To follow up on this, I just did try deleting those files and running the
RPM process again, and received the same errors.
rpm -ih postgresql-libs-7.4-0.3PGDG.i386.rpm
On Mon, 9 Feb 2004, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
That said we have a really HUGE (~200 drive) IDE storage array my web /
app server sits on top of. No clue if that thing will reliably work under
a database, and I'm in no hurry to find out.
But since
On Tue, 10 Feb 2004, Peter Galbavy wrote:
scott.marlowe wrote:
I don't know who you think you are, but I've physically tested the
stuff I'm talking about. Care to qualify what you mean?
I would genuinely be interested in seeing the results and the methodology.
IDE drives (all
!
Jeremy
-Original Message-
From: scott.marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 5:50 PM
To: Jeremy Smith
Subject: RE: [ADMIN] Upgrading from 7.2 to 7.4.1 on Redhat 7
On Tue, 10 Feb 2004, Jeremy Smith wrote:
Hello,
thank you for this link. But I
] Behalf Of scott.marlowe
Sent: Tuesday, February 10, 2004 7:15 PM
To: Jeremy Smith
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Upgrading from 7.2 to 7.4.1 on Redhat 7
You're welcome. Glad it all worked for you. If it's any consolation,
that's probably the hardest stuff you'll have to deal
On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote:
Hi,
I actually try to insert varchar which length is higher than 32 in a column
which type is varchar(32). I can't change the type of the column, and I
want to trunc the data. I know it's possible ! I have seen this !
Example : j'aime les
On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote:
Hi,
I actually try to insert varchar which length is higher than 32 in a column
which type is varchar(32). I can't change the type of the column, and I
want to trunc the data. I know it's possible ! I have seen this !
Example : j'aime les
On Fri, 6 Feb 2004, Ernst Roebbers wrote:
Dear Sirs,
I would like to communicate with the postgres backend
using port 5432 from a small remote machine where only
a socket is available - no application layer.
Do You have any hints where I can find some information
what kind of input the
On Wed, 4 Feb 2004, Harley Milne wrote:
I urgently need to a working windows installer that can successfully install
and configure a version of postgresql.
It's been a frustrating experience trying to locate and use anything I have
found out there.
I've tried installing a couple
On Wed, 4 Feb 2004, Iain wrote:
If I understand checkpoints correctly, data that is already written to the
WAL (and flushed to disk) is being written to the DB (flushing to disk).
Meanwhile, other writer transactions are continuing to busily write to the
WAL. In which case a disk bandwidth
On Wed, 4 Feb 2004, Edoardo Ceccarelli wrote:
I have a simple query that scans each record, like this: select * from utente where
luogorilasciodoc='ciao'
The execution time BEFORE vacuum is: 1203ms The execution time AFTER vacuum is:
6656ms
!!!
What is going on? Thought that one vaccum the
Is the file postgres IN the directory /etc/init.d? If so, is it set
executable???
On 2 Feb 2004, Remi wrote:
Hello,
I've installed redhat enterprise 3 on a system to use as a db server.
Manually I can install and run postgresql 7.3 (the one on the extras
CD). The problem is when you try
On Thu, 29 Jan 2004, Juan Miguel wrote:
You can kill the procs (connections) using kill -9 PID
Just use kill PID first!
'kill -9' PID will force all backends to flush cache for no good reason.
Note that on most unixes, a plain kill PID will send the term signal,
which tells the process to
On Mon, 19 Jan 2004, Arun Gananathan wrote:
Hi,
Could anyone please let me know how to perform the following in
postgresql
I have two tables called P , Q with the same attributes and data
tpyes. I want to insert a record ( for example called A) into table P,
when deleting the same
On 16 Jan 2004, Ashok Chauhan wrote:
hello
i am selecting ten fields form a table and i want to replace the null
values with any other value.
Look up coalesce(), it should do exactly what you need.
---(end of broadcast)---
TIP 1: subscribe
You likely need this line in postgresql.conf:
tcpip_socket = true
On Thu, 15 Jan 2004, Norbert Beckers wrote:
I'm a novice when it comes to PostgreSQL and PostgreSql Admin. I having
truoble connecting to PostgreSQl Server running on the localhost. Every
time I try to connect I get the
On Sat, 20 Dec 2003, C. Bensend wrote:
pg_dumpall seems to do this for me, without any command-line args
needed. Am I correct in saying that 'pg_dumpall filename' will
produce
a PostgreSQL dump that includes _everything_ I need to go from a clean
PG install to accepting
On Fri, 19 Dec 2003, Priya G wrote:
Hi all,
Is Incremental backups possible in Postgres 7.3 or 7.4
Nope.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
On Tue, 16 Dec 2003, Robert Creager wrote:
When grilled further on (Tue, 16 Dec 2003 22:30:04 -0600),
Patrick Spinler [EMAIL PROTECTED] confessed:
According to the theory they expound, a database with any significant
write activity whatsoever should never be on raid 5, but instead be
On Wed, 17 Dec 2003, Adam Witney wrote:
On 17/12/03 3:45 pm, scott.marlowe [EMAIL PROTECTED] wrote:
On Tue, 16 Dec 2003, Robert Creager wrote:
When grilled further on (Tue, 16 Dec 2003 22:30:04 -0600),
Patrick Spinler [EMAIL PROTECTED] confessed:
According to the theory
On Tue, 16 Dec 2003, Adam Witney wrote:
Hi all,
I am experimenting with a few OS's for my new hardware. I plan to have a
software RAID5 device for my pgsql data directory.
I have been experimenting with FreeBSD and with Linux, does anyone have any
thoughts on whether vinum RAID devices
On Tue, 16 Dec 2003 [EMAIL PROTECTED] wrote:
I am experimenting with a few OS's for my new hardware. I plan to have a
software RAID5 device for my pgsql data directory.
I have been experimenting with FreeBSD and with Linux, does anyone have any
thoughts on whether vinum RAID devices are
On Wed, 12 Nov 2003, exciteworks hosting wrote:
Is there an easy way to copy all DBs and users on a server to another
server?
I need to get an exact duplicate.
pg_dump -h source_server|psql -h dest_server
---(end of broadcast)---
TIP 5:
On Wed, 12 Nov 2003, ow wrote:
Hi,
Is there a way to take the database offline to keep users out?
Is there a way to take the database offline but still allowing pg_restore to
run against it?
Yes, as of 7.3 you can create entries in pg_hba.conf that control who can
connect to what
On Tue, 11 Nov 2003, Gaetano Mendola wrote:
Danielle Cossette wrote:
Good morning,
Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
If it does, are you aware of any issues.
Seems that solaris is the worst choice for run Postgres.
Am I completely wrong ?
I
On Thu, 6 Nov 2003, William Yu wrote:
scott.marlowe wrote:
Note that if you're on an IDE drive and you haven't disabled the write
cache, you may as well turn off fsync as well, as it's just getting in the
way and doing nothing, i.e. the IDE drives are already lying about fsync
so why
On Thu, 6 Nov 2003, Jeff wrote:
On 06 Nov 2003 15:21:03 +0100
Marek Florianczyk [EMAIL PROTECTED] wrote:
fsync = false
HOLD THE BOAT THERE BATMAN!
I would *STRONGLY* advise not running with fsync=false in production as
PG _CANNOT_ guaruntee data consistancy in
On 6 Nov 2003, Marek Florianczyk wrote:
... And my management says, that there is no good support for Open
Source, heh... ;)))
That's because your support needs are different. A developer wants
answers and solutions, a manager often wants someone to blame. :-)
On 5 Nov 2003, Marek Florianczyk wrote:
W li¶cie z ¶ro, 05-11-2003, godz. 19:52, Tom Lane pisze:
Marek Florianczyk [EMAIL PROTECTED] writes:
Maybe reconnect is to often, but how to explain that reular queries like
select * from table1 ale much faster than \d's ? ( my post to Jeff )
On 31 Oct 2003, Marek Florianczyk wrote:
Hi all
We are building hosting with apache + php ( our own mod_virtual module )
with about 10.000 wirtul domains + PostgreSQL.
PostgreSQL is on a different machine ( 2 x intel xeon 2.4GHz 1GB RAM
scsi raid 1+0 )
Tom's right, you need more memory,
On Thu, 30 Oct 2003, David Wagoner wrote:
In Oracle, you can select * from dictionary to see the data dictionary
table names and descriptions. Is there something similar in PostgreSQL?
Old way (still supported, not going away):
\d from a psql session
New way: select * from
On Tue, 28 Oct 2003, Tom Lane wrote:
Epps, Aaron M. [EMAIL PROTECTED] writes:
I've got an authentication questions. I've just setup pg_hba.conf to use
localallalltrust for testing purposes, but when the application I'm
using tries to connect to the PostgreSQL Db (Using
-tracker/includes/classes/dbi.class.php on line 98
Thoughts?
-Original Message-
From: scott.marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 2:37 PM
To: Tom Lane
Cc: Epps, Aaron M.; '[EMAIL PROTECTED]'
Subject: Re: [ADMIN] Authentication Question
On Tue, 28 Oct
On Fri, 24 Oct 2003, Duffy House wrote:
Hello:
It looks like I got caught sleeping.
I am running Postgresql 7.2 under Red Hat 7.3.
Postgresql failed today. When I tried to restart it, I got a message
stating that the device is full.
I used df to confirm that /var where postgres reside
]#
i have done new installs using RPMs, but not an upgrade.
silly question time:
are these the correct RPMs?
do I just upgrade them one at a time as follows:
rpm -Uvh postgresql...rpm
many thanks
kd
[EMAIL PROTECTED] (scott.marlowe) wrote in message news
A quick note, anytime you're gonna upgrade, you need to first shut down
the postmaster...
On Mon, 27 Oct 2003, scott.marlowe wrote:
Assuming you'll be upgrading from 7.2 to 7.2.4, then yes, all you need to
do is upgrage the rpms. you can do tham all at once, assuming they're in
the same
You'll have to transfer the data over to a 7.0.x machine to recover it.
On Thu, 23 Oct 2003, Dave [Hawk-Systems] wrote:
have a server that went belly up on us.
We do have copies of the data directories on backups, but no recent dumps.
Old server was ver 7.0 branch (7.0.3 if memory serves)
On Wed, 22 Oct 2003, Ganesan Kanavathy wrote:
All the while I was doing pg_dump as backup method for my pgsql db.
Today I came across File system level backup on Postgresql
Documentation.
After reading it, I am quite unsure whether File system level backup is
better than pg_dump.
If you need a generic client side ODBC for unix, look also at
www.iodbc.org. Nice little LGPL odbc driver, we use it to connect to
non-pgsql databases at work and it's quite stable.
On Wed, 22 Oct 2003, David Wagoner wrote:
Jeff,
Thanks, I saw that page but thought is was only for
On Tue, 21 Oct 2003, dotaku wrote:
scott.marlowe wrote:
On Mon, 20 Oct 2003, dotaku wrote:
Hi all..
i've got a problem with the memory that postgresql 7.3.2 used in RedHat 9.
When the memory usage reached 80% or more of the total memory in the
system..
the memory just keep
It sounds like you are using pg_pconnect. First, try using pg_connect and
see if it can handle the load. If it can't, write back and I'll tell you
how to configure apache / php / postgresql to handle the load you want
with pg_pconnect. pg_pconnect is dangerous, and pg_close will NOT close
On Mon, 20 Oct 2003, dotaku wrote:
Hi all..
i've got a problem with the memory that postgresql 7.3.2 used in RedHat 9.
When the memory usage reached 80% or more of the total memory in the
system..
the memory just keep stuck there..The thing did not reduce bt itself...
Then i decided to
On Mon, 20 Oct 2003, Priya G wrote:
Is there any encrypt function in postgres? like encrypt('string')...
Yes, but they're not built in, you need to look in the
source/contrib/pgcrypto directory to find them.
---(end of broadcast)---
TIP 4:
There's also the initlocation $ENVAR solution:
http://www.postgresql.org/docs/7.3/static/manage-ag-alternate-locs.html
On Fri, 10 Oct 2003, Rudi Starcevic wrote:
Hi Wim,
It is possible to compile PostgreSQL so that it can keep each users
database in their home dir. ( or another dir. of
,
ganesh
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of scott.marlowe
Sent: Tuesday, October 07, 2003 10:36 PM
To: Ganesan Kanavathy
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Pgsql crashes frequently
On Tue, 7 Oct 2003, Ganesan Kanavathy
On Tue, 7 Oct 2003, Ganesan Kanavathy wrote:
Dear all,
How to check database size for Posgresql db. I need give hardisk
utilization of the database on daily basis.
Here's how I do it:
su - postgres
cd $PGDATA
du -s base
---(end of
On Tue, 7 Oct 2003, Ganesan Kanavathy wrote:
We are running Postgresql db and it crashes almost every hour Unable to
load up pgsql after a crash.
We need to restart the server to start back pg.
What would be the cause of this problem. Please help.
Bad hardware. Check for bad memory,
On Tue, 7 Oct 2003, Priya G wrote:
I saw this error
PostgreSQL server: FATAL 1: Sorry, too many clients already in
/usr/share/php/phplib/db_pgsql.inc on line 49.
It seems like I have to increase the maximum connections in the postgresql.conf .Is
that the
right step to fix the
1 - 100 of 166 matches
Mail list logo
