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 broadcast)--
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 mem
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 prob
this means. How do I solve this?
>
> What SHMMAX and SHMMIN and how I calculate this value? I have a 1GB of
> memory.
>
> Regards,
> ganesh
>
>
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of sc
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
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
i
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 dec
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
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
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 Wind
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 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
s:
> rpm -Uvh postgresql...rpm
>
>
> many thanks
>
> kd
>
>
>
>
>
>
>
> [EMAIL PROTECTED] ("scott.marlowe") wrote in message news:<[EMAIL PROTECTED]>...
> > On Fri, 24 Oct 2003, Duffy House wrote:
> >
> > &g
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 t
On Tue, 28 Oct 2003, Epps, Aaron M. wrote:
> 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 PHP)
> I get the following error.
>
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
ed in the pg_connect() function. However, when I remove the
> username and password I get the following error...
>
> Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT
> authentication failed for user "dbname=issue-tracker" . in
> /var/www/h
$conn_str .= !empty($this->port) ? " port=".$this->port : "";
> $conn_str .= " dbname=".$this->name;
>
> $this->link = pg_connect($conn_str)
> or $this->logger("Database connection failed!","DBI&q
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 information_s
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 memo
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 J
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 consi
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 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
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
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 data
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 Fri, 12 Dec 2003, Greg Spiegelberg wrote:
> Any rule of thumb for REINDEX DATABASE? Once per month?
> Per x transactions?
You shouldn't need to reindex databases for the most part. If there's
lots of catalog updates / delete, it might be occasionally useful to down
the database and reindex
On Fri, 12 Dec 2003, Rhaoni Chiu Pereira wrote:
Hi, is there a switch in your pgsql/odbc connector to enable cursors? If
so, try turning that on.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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
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 de
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 i
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),
> &g
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 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 acce
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: subsc
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 fo
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 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 po
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
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 vaccu
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 le
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 le
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 in
On Fri, 6 Feb 2004, Tom Lane wrote:
> kaolin fire <[EMAIL PROTECTED]> writes:
> > Where would I go to start tracking down recurring error messages of the
> > sort:
>
> > FATAL 2: open of /usr/local/pgsql/data/pg_clog/06F7 failed: No such
> > file or directory
> > FATAL 2: open of /usr/local/p
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 in
On Sat, 7 Feb 2004, Peter Galbavy wrote:
> scott.marlowe wrote:
> > Also, running on SCSI drives will be much faster than running on IDE
> > drives if the IDE drives have their caches disabled like they should,
> > since they lie otherwise. Since SCSI disks don&#
On Mon, 9 Feb 2004 [EMAIL PROTECTED] wrote:
> >
> > If you're gonna accuse me of lying, you damned well better have the balls
> > AND evidence to back it up.
> >
>
> Wow. Scott, all traffic to the admin list has ceased since you posted
> this, we are shocked!
>
> You put a lot of effort into fi
On Mon, 9 Feb 2004, Goulet, Dick wrote:
> Scott,
>
> If you feel it is necessary to apologize for such a minor
> infraction of polite etiquette please come on over to Oracle-L. We have
> harshness 10 times greater. Probably because there are so many
> practioners and so many different
Hi Jeremy. Updating major versions (i.e. 7.2 to 7.3 or 7.4) requires you
to dump and restore your database.
This page explains it:
http://www.postgresql.org/docs/7.4/static/install-upgrading.html
If you still need some more help, feel free to ask, we're a pretty
responsive community.
-
On Tue, 10 Feb 2004, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> >> Unfortunately not --- at checkpoint time, the constraint goes the other
> >> way. We have to be sure all the data file updates are down to disk
> >> before we wri
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 data
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 an
ostgresql_usin.html and it
> worked out great!
>
> 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
>
>
; -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] 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'
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 w
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 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, an
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
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.
>
> > I am having a similar problem and this is what I've found so far:
> >
> > During the checkpoint the volume of data that's wr
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 sourc
all three that work
together.
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 PROTECTE
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
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 / an
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 in
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 do
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 alternativ
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
> > > w
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
mang
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 Po
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 us
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 R
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 local
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 AM
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-r
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 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 wher
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 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
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 betwe
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
On Tue, 30 Mar 2004, Andrew Biagioni wrote:
> Alex,
>
> the answer is "no" to all of these. We are a tiny start-up (2 guys, and
> we do our own cleaning); ambient temperature varies significantly but
> is not related to the failure, and one machine starts beeping when it
> gets too hot (then
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
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 goe
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.
Act
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 f
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 mea
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
lots
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
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 inf
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 sel
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 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
1 - 100 of 189 matches
Mail list logo
