Re: [ADMIN] Postgresql slow on XEON 2.4ghz/1gb ram

On Wed, 6 Aug 2003, Wilson A. Galafassi Jr. wrote: > do you now how to turn off the xeon Hyperthreading ?? Not sure ... in Unix, you just dont' enable it ... at least under FreeBSD (its disabled by default) ... check in your BIOS though, I *thought* I heard mention that there is a setting in ther

Re: [ADMIN] Postgresql slow on XEON 2.4ghz/1gb ram

On Wed, 6 Aug 2003, Wilson A. Galafassi Jr. wrote: > Hello. > I have this problem: i'm running the postgre 7.3 on a windows 2000 > server with P3 1GHZ DUAL/1gb ram with good performance. For best > performance i have change the server for a XEON 2.4/1gb ram and for my > suprise the performance

Re: [ADMIN] Whats wrong with www.postgresql.org

already fixed On Mon, 28 Jul 2003, Dani Oderbolz wrote: > Hi guys, > when I navigate to www.postgresql.org, > all I see is the default Apache screen : > "If you can see this, it means that the installation of the Apache web > server software on this

Re: [ADMIN] news.us.postgresql.org

no, so far, we ahven't been able to get teh news2mail gateway to work ... On Sun, 20 Jul 2003, Mendola Gaetano wrote: > Hi all, > Are the messages posted to this new server sended to > mailing list too ? > > Thank you > Gaetano > > > > ---(end of broadcast)---

Re: [ADMIN] News server

news.us.postgresql.org is up right now, and gatewaying ... news.postgresql.org will come back online as soon as I'm able to get some more hardware online handle it, which we're just getting ready to ship out ... message pointesr will be out of sync, unfortunately, so altho we are adding redundancy

Re: [ADMIN] Re: 7.1 out soon?

most likely "within days" ... Lamar tends to have a pretty decent turn around ... On Tue, 10 Apr 2001, Peter Peltonen wrote: > > Will the 7.1 RPMs be ready at the same time? > > Peter > > > The Hermit Hacker wrote: > > > > I'm packaging up R

Re: [ADMIN] 7.1 out soon?

I'm packaging up RC3 as I type this ... if all goes well, the only thing holding up full release is the docs themselves, so, mid-April is looking promising ... On Fri, 6 Apr 2001 [EMAIL PROTECTED] wrote: > A while back someone said 7.1 would be out by now. Any new date(s)? I really > can't go f

Re: [ADMIN] 7.1 out soon?

Oh, as a side note ... unless someone comes up with something *major*, the server side of things is locked down now ... if you pull RC3 down and use that, there should be little to no changes between that and full release, again, unless there is something *major* that crops up ... On Fri, 6 Apr

Re: [ADMIN] Release of 7.1

On Fri, 9 Mar 2001, Paul Huppe wrote: > Hi, > > Is there an anticipated date for the release of version 7.1? end of march > > Thanks, > > Paul. Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] se

RE: [ADMIN] v7.1b4 bad performance

Okay, am going to guess that all four of these results are with CommitDelay=0, and for each higher number of clients, the results get better and better ... what if you increase CommitDelay back to 5, for those various levels of client connections? On Fri, 16 Feb 2001, Schmidt, Peter wrote: > >

Re: [ADMIN] Outer Joins

full release is planned for end February, if all goes well ... On Sat, 3 Feb 2001, Steve Doerr wrote: > I saw that outer joins will be supported in ver. 7.1. Does anyone know > when this is expected, or if there is beta support for them currently? > > Thanks, > Steve > > Marc G. Fournier

Re: [ADMIN] postgres limitation

How about the full answer? I think Tom did a fantastic job of writing up, be a shame to make it go to waste for brevity? :( On Sat, 27 Jan 2001, Bruce Momjian wrote: > OK, how is this? > > > These are the limits: > > Maximum size for a database? unlimited (60GB databases exis

Re: [ADMIN] Some thoughts on replication

Have you looked at the replication code that is in contrib? On Thu, 25 Jan 2001, Dirk Heinrichs wrote: > Hi folks, > > Maybe this belongs to the developers mailing list, but I'm not subscribed to > that list, so I post it here. > > I've read through todo list on the website, especially the plan

Re: [ADMIN] Rule - Delete or Upgrade will not work with primary key

have you tried this under v7.0.3 and/or 7.1, to see if its long since been fixed? On Sun, 14 Jan 2001, miss wrote: > Hello there > > I am using Postgres 6.5.3 on SuSE Linux 6.4 > > The problem is that on using rules on a view it will only work for > insert and delete - not update. Even for ins

[ADMIN] pgsql-admin list should now be working ...

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org

Re: [ADMIN] Archives?

See under General Info in the User Lounge ... On Tue, 24 Oct 2000, dk smith wrote: > Before I start posting the S.O.S. (on a different day), can someone please > share with me the location of the archives for the admin group? I checked > the obvious places. > > thx, > dk > -- > [EMAIL PROTEC

Re: [ADMIN] tablename.columnname support

On Sat, 16 Sep 2000, vijayendra mohan agrawal wrote: > Hi all, > > say, we have a table created by : > create table a ( a char(11), b char(22) ); > > For adding data into table 'a', ORACLE supports column name format as > tablename.columnname as follows : > insert into a ( a.a, a.b ) values ( '

Re: [ADMIN] Cannot vacuum! Stops on first table, pg_type

On 29 Aug 2000, Palle Girgensohn wrote: > Hello again, > > OK, I dumped && restored (had to fix a couple of duplicates that had > been hidden by indices, not too bad), and updated to 6.5.3 + patches, > so I guess that makes me happy for now. I never did like 6.5.2 > anyway... ;-) would highly r

Re: [ADMIN] Cannot vacuum! Stops on first table, pg_type

check out the REINDEX command: http://www.postgresql.org/docs/user/sql-reindex.htm that may/may not help ... On 29 Aug 2000, Palle Girgensohn wrote: > Hi! > > This is really strange. Starting from the beginning, I was running > postmaster with logs redirected to a file (on a differen

RE: [ADMIN] [7.0.2] rotating log files ...

Just as an FYI ... I just enabled the syslog facility so that it all goes through there instead ... On Mon, 28 Aug 2000, Neil Toronto wrote: > The process still has an open file handle, and will continue to do so even > after you move it. So, if your file is /var/log/messages, and you do a m

[ADMIN] [7.0.2] rotating log files ...

can someone recommend on how to rotate the following log files without having to stop/start the server? postgres 85333 pgsql1w VREG 13,131084 995 762037 /pgsql/logs/postmaster.5432.61308 postgres 85333 pgsql2w VREG 13,131084 316501241 762038 /pgsql/logs/5432.61308 its the 316

Re: [ADMIN] MS Access out-performs PostgreSQL 7?

On Tue, 18 Jul 2000, Joseph Sircy wrote: > 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. You can run MS Access under Linux? Postgr

Re: [ADMIN] Web hosting and PostgreSQL?

http://www.pgsql.com and http://www.hub.org are co-located and work closely together ... On Sat, 3 Jun 2000, Thomas wrote: > Anyone knows of any good web hosting that support PostgreSQL? > > Regards, > Thomas. > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy S

[ADMIN] PostgreSQL Mailing Lists ...

NOTE: Four new Developer related mailing lists have been created!! == Last Modified May 24th, 2000

Re: [ADMIN] Need some shmget advice

what does ipcs -a show? On Wed, 12 Apr 2000, Hamilton, Andrew Mr. wrote: > Architecture: Solaris 2.6 Sparc > Compiler: gcc 2.95.1 > postgres version postgres-v6.5.3 > > I am getting this no matter what value I pass to postmaster -B. There is > something else going on here. I did hav

Re: [ADMIN] pgsql and nfs

there is, but even Sun doesn't do NFS locking properly, and they are the ones that originally designed it ... amongst other problems with NFS :( On Tue, 14 Mar 2000, Jeff MacDonald wrote: > just to throw a wrench into the conversation, > > isn't thre a tcp/ip nfs that does more error checking

Re: [ADMIN] postmaster failure

On Thu, 3 Feb 2000, Christopher R. Jones wrote: > I should have read more messages in the archives. Right after I sent my > message, I read that the following is typical: > set shmsys:shminfo_shmmax=16777216 > set shmsys:shminfo_shmmin=1 > set shmsys:shminfo_shmmni=100 > set shmsys:shminfo_shmse

Re: [ADMIN] postmaster failure

what does an 'ipcs' show? did you reboot after editing /etc/system? if you can't reboot, use the -B option to reduce the number of segments used until you can reboot with the new /etc/system in place ... On Thu, 3 Feb 2000, Christopher R. Jones wrote: > I installed postgres-6.5 on Solaris 7,

Re: [ADMIN] serachable index on site

try http://www.postgresql.org/search.php3 we're still working on it, so it *is not* complete, but it will at least give you a start ... On Wed, 5 Jan 2000, Dana Hudes wrote: > Attempting to search old messages results in > > ht://Dig error > htsearch detected an error. Please report this to t

Re: [ADMIN] replication

On Tue, 30 Nov 1999, F. Roettger wrote: > dear developers, > > I've seen the replication skill on the todo-list. when will this be > released? when someone decides to take it on as a project :) Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator

Re: [ADMIN] When postgres will be faster?

On Mon, 29 Nov 1999 [EMAIL PROTECTED] wrote: > Yes! But I recommend backend pool too. What is it? The postmaster task > runs now backend for each query. Good. But After query backend > finished. I recommend to stay backend running within a some timeout. > If the next query occured the postmaster

Re: [ADMIN] When postgres will be faster?

On Mon, 29 Nov 1999, Oleg Broytmann wrote: > On Mon, 29 Nov 1999 [EMAIL PROTECTED] wrote: > > When postgres will use posix threads or support pool of backends (like apache)? > > I guess it will increase speed very fast. > >I am pretty sure it wouldn't. Postgres is slow (I think you compare i

Re: [ADMIN] When postgres will be faster?

What version of PostgreSQL? Each version we've released has been faster then the previous releases... On Mon, 29 Nov 1999 [EMAIL PROTECTED] wrote: > Hi! > > When postgres will use posix threads or support pool of backends (like apache)? > I guess it will increase speed very fast. > > Using p

Re: [ADMIN] When postgres will be faster?

On Mon, 29 Nov 1999 [EMAIL PROTECTED] wrote: > Using 6.3 I had troubles with php (as module) and persistent connection to > postgresql. The backend fails after 2-3 requests after second pg_pconnect() > call... Hmmm... May be it was php mistake... If v6.3 is what you are using as a speed comparis

Re: [ADMIN] Re: HSA (Highly Scalable Architecture) Distribution andreplication

On Sat, 30 Oct 1999, Bruce Momjian wrote: > > I guess i'm pretty ignorant about big expensive servers. Is the > > 450 really that much faster than say a few Dual PIII's? I guess if I can Depends on what you are runnin gon the machine. We have a dual-E450 at work, and several Dual-PIIs...both ru

Re: [ADMIN] Re: [HACKERS] RFC: Industrial-strength logging (longmessage)

ther doesn' have it set at all...and should make it so that each database *should* theoretically log to different files/mechanisms? On Sat, 23 Oct 1999, Tim Holloway wrote: > > > The Hermit Hacker wrote: > > > > On Sat, 23 Oct 1999, Aaron J. Seigo wrote: > > &

Re: [ADMIN] Re: [HACKERS] RFC: Industrial-strength logging (longmessage)

On Sat, 23 Oct 1999, Aaron J. Seigo wrote: > > There MUST exist a way to alter the logging level on-the-fly; > > IMHO this is a rock bottom, non negotiable requirement. > > whilst i don't think this is MUST, it is EXTREMELY desirable and would make the > logging actually useful for large install

Re: [ADMIN] 6.5 on FreeBSD 2.2 - any problems?

Hi Robert... I did all my testing on FreeBSD 4.0, without any problems...regression tests were "as expected" and everything...haven't tried my 3.2-STABLE machine yet though, that is *after* my holidays... There have been several changes to the shared memory aspects of the code..

Re: [ADMIN] What's the status of 6.5? (spinlock crashes with 6.4.2under Solaris 2.6)

On Mon, 14 Jun 1999, Sam Hokin wrote: > I'm very anxious to install the non-beta 6.5 on a "mission-critical" project > when it's ready. I thought the planned release was June 7, but it's a week > past that now. Any word? Sorry for the delays, a few last minute things had to be done...v6.5 was

Re: [ADMIN] Account access

sorry folks, this spammer has been removed from the list...they get smart so quickly :( On Fri, 11 Jun 1999, Jim Burnett wrote: > Hi > I want to offer everyone here a free account on my server. > Includes: > POP3 Email > FTP > Unlimited WW space > Shell access > > Send account requests to [

Re: [Fwd: RE: [ADMIN] create index and date type casting: howto?]

On Thu, 3 Jun 1999, Vadim Mikheev wrote: > Terry Mackintosh wrote: > > > > P.S. > > To the list maintainer: > > Not having a "Reply-To:" mail header pointing back at the list is a > > pain. Seems to me that it used to be there, what happened? > > Agreed!!! Mark? It hasnt' been there in 2 year

Re: [ADMIN] pg_hba.conf

On Wed, 2 Jun 1999, Delain Huggins wrote: > We have created a pgsql database w/Access front end through ODBC and are > needing to set up user authentication. Right now we seem to have > successfully anabled complete acceptance of any user from anywhere on our > LAN ;-)... We want to be able

[ADMIN] Security Question ...

Okay, here's my question for the week... I have a server that I want to run with multiple client databases, each one password protected...but how do I get it so that userA can't connect to userB's database, or vice versa? I know I can grant/revoke on the tables, but how do I grant/revoke on the

Re: [ADMIN] --> Upgrade 6.1->6.4

Can I get copies of those?? :) On Fri, 16 Apr 1999, Mike Embry-RZAW80 wrote: > If you still have the need for 6.1, I found 6.1 and 6.1.1 on an old > file server or ours that is in the process of being retired. > > fulcrum# ls -al postgres* > -rw-r--r-- 1 root 2626603 Oct 31 1997 postgre

Re: [ADMIN] --> Upgrade 6.1->6.4

On Thu, 15 Apr 1999, Terry Mackintosh wrote: > Well yes, but that don't help him any... > > What you need is to re-install 6.1, do a dump, then upgrade. As you > know this then I take it that the real problem is that you no longer > have a copy of the souce. > > For the souce maybe one of the

Re: [ADMIN] Some questions about initdb

I'm going to go out on a limb here, but the *usual* Linux related problem as far as initdb is concerned is old PostgreSQL libraries. You generally have to remove all traces of the old before you can install the new :( On Thu, 15 Apr 1999, Maria Kling wrote: > Hi! > > We are trying to instal

[ADMIN] Re: Small logo

I think color wise, we're gonna be moving more towards the logo/site that Dmitry posted the other day (http://devnull.wplus.net/pub/postgres) ... Vince is working with him right now on what needs to happen. We're using Dmitry's color scheme for the CDs, since the image comes out alot clearer the

Re: [ADMIN] pg_time

On Wed, 14 Apr 1999, Piotr Plizga wrote: > On Tue, 13 Apr 1999, The Hermit Hacker wrote: > > > > > What version of PostgreSQL are you running? I thought this was only a > > problem with relatively old releases...swore we fixed it around v6.1 or so > > ... > &g

Re: [ADMIN] pg_time

What version of PostgreSQL are you running? I thought this was only a problem with relatively old releases...swore we fixed it around v6.1 or so ... On Tue, 13 Apr 1999, Piotr Plizga wrote: > In the data postgresgl directory ( $PGDATA/data ) there is file > named : pg_time ( table pg_time ).

[ADMIN] Re: pg_log

What version of PostgreSQL? Older version had this problem, but, last I heard, it was fixed in more recent ones... On Wed, 7 Apr 1999, Ivan Obuhov wrote: > Hello, everybody! > > My question is: What is pg_log in data directory? > I ask this question because file pg_log grows as more as possib

[ADMIN] Re: [NOVICE] PostgreSQL friendly ISP ?????

We do ... but we run with FreeBSD, not Linux ... See http://www.hub.org/prices.html On Tue, 6 Apr 1999, David J Jacskon wrote: > Greetings, > > I looking for a website hosting service that supports PostgreSQL +PHP > and preferably Linux. > Any pointer/URL would be appriciated. It seem that m

Re: [ADMIN] FreeBSD vs. 6.4.2 -- still

On Thu, 1 Apr 1999, hal Lynch wrote: > >I'm running a pretty stock 3.0 here, and have not had any problems. You > >need to show us what sort of errors you are seeing, though, since right > >now, all we have to work with is "it doesn't work" :( > > > >What does initdb show when you run it, start

Re: [ADMIN] FreeBSD vs. 6.4.2 -- still

I'm running a pretty stock 3.0 here, and have not had any problems. You need to show us what sort of errors you are seeing, though, since right now, all we have to work with is "it doesn't work" :( What does initdb show when you run it, start to finish? On Wed, 31 Mar 1999, hal Lynch wrote: >

Re: [ADMIN] FreeBSD vs. 6.4.2

Most odd, since I'm running v6.4.2 on 3.0 myself ... were there any errors generated by initdb? On Tue, 30 Mar 1999, hal Lynch wrote: > I trying to install postgresql-6.4.2 on an Intel FreeBSD 3.0 box. > > The compile seems to work well. I got: > All of PostgreSQL is successfully mad

Re: [ADMIN] Problem compiling perl5 interface

>From a very very quick look at the template file directory, there are two templates...one for 'hpux_cc' and one for 'hpux_gcc' ... When you ran configure, did you stipulate --template=hpux_gcc? The -Ae option, from looking athte two template files, is only used in the hpux_cc vs hpux_gcc versi

Re: [ADMIN] pg_psort.* files

On Fri, 12 Mar 1999, [iso-8859-1] Jérôme Knöbl wrote: > Hi, > > Can I remove files named pg_psort.* without trouble! > > I have about 700Mb in those files. And I think that temporary files! they are purely temp files, you should bee safe to do something like: find . -name "pg_psort.*" -mtime

Re: [ADMIN] Access privileges on table

On Fri, 5 Mar 1999, Mikhail Terekhov wrote: > Hi, > > How to query which user has what privileges on some table? >From psql, use the \z command ... Marc G. Fournier Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebs

Re: [ADMIN] sales@hub.org

On Wed, 3 Mar 1999, Christopher R. Jones wrote: > Has anyone ever sent an order for the CD to [EMAIL PROTECTED]? I sent mine 3 > days ago and requested confirmation (I sent VISA encrypted). I have sent 2 > other emails requesting confirmation, no reply. > > Perhaps Marc is on holidays? Or Mar

[ADMIN] changing user passwd ...

create user allows you to set a password for someone...how to you change that password after? update doesn't appear to work... Marc G. Fournier Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org

Re: [ADMIN] Feature patches and Postgres minor versions

On Tue, 22 Dec 1998, Herouth Maoz wrote: > I looked at the patches directory, and saw the "feature patch" there > intended to add 'LIMIT' to the syntax of SELECT. > > According to the README, feature patches add functionality, which is > something minor versions (like 6.4.1) will not do. So ther

Re: [ADMIN] Re:

On Mon, 30 Nov 1998, Terry Mackintosh wrote: > Hi Ken, Bill and all > > Na! > First, as a web interface you should be using PHP 3.x, you are right? Actually, my personal preference is perl for web interfaces *shrug* Marc G. Fournier Systems Administrato

[ADMIN] Re: I can't go futher after installing the PostgreSQL

On Fri, 27 Nov 1998, Rajesh Anandarajan wrote: > Sir, > > Because I found the articles about you SQL server very interesting I > decided to try it. But after the installation is over I am encountering > problem with it. Since in your web site no e-mail contacts other than > this is specified I

Re: [ADMIN] Compile error with 6.4 on Solaris2.6

On Fri, 13 Nov 1998, Kevin L. Gross wrote: > > Hi, > > I'm trying to compile the latest Postgresql 6.4 on a Solaris 2.6 > with gcc. Configure runs OK, but the compile bombs: Grab flex and installusing that... > > make -C preproc all > make[3]: Entering directory > `/usr/local/src/db/

[ADMIN] Re: [SQL] Can't starting postmaster with -B 512 Option

On Fri, 13 Nov 1998, [euc-kr] ¼Û±â¿ø wrote: > System Spec > SUN OS 2.6 > PostgreSQL 6.3 Version > > [Error Message] > sol% postmaster -B 512 -S -D /usr/local/pgsql/data > IpcMemoryCreate: memKey=5432001 , size=4501144 , > permission=384IpcMemoryCreate: shmget(..., create, ...) failed: In

[ADMIN] Re: About PostgreSQL 6.3.2

On Wed, 11 Nov 1998, Silvio M P Paiva wrote: > Hi all! > > I hope I sent this e-mail to the right place. This is my very first time > asking something to you! > > I started using PostgreSQL since I built a Linux based networking, > working with TCP/IP and Insight'ODBC-32bit to connect. > > I'd

Re: seperate swap drive, was Re: [ADMIN] Speed problem

On Thu, 5 Nov 1998, David Ben-Yaacov wrote: > Even under normal operations when the database is fast, we still have > problems inserting data. We have examined the insert query identified > in our error log to see if there is a problem with our code. > Apparently not, as the insert query that

Re: seperate swap drive, was Re: [ADMIN] Speed problem

mirrors by now, as well as the main site :) > p.s. Does 6.4 have page-level locking? No, Vadim was waiting for v6.4 to be released before diving into it for v6.5 ... > > The Hermit Hacker wrote: > > > > > Are you running with fsync() disabled? > >

Re: [ADMIN] unable to compile postgresql-6.3.2 on alpha-dec-osf4.0

On Thu, 5 Nov 1998, Carl Riches wrote: > > The configure program is looking for a template file called "osf1", which > is not in this distribution. This is how configure fails: Try v6.4, released yesterday...should fix most of the configure related problems of previous versions... > > _yu

Re: seperate swap drive, was Re: [ADMIN] Speed problem

On Thu, 5 Nov 1998, Lincoln Spiteri wrote: > > > I have a rather large database as well (> 2 Meg of tuples). I thought > > > my system was souped up enough: PII/400 MHz (100 MHz bus) 256 Meg SDRAM, > > > 18 Gig SCSI harddrive, Red Hat Linux 5.1. However, my swap space (512 > > > Meg) is on th

Re: seperate swap drive, was Re: [ADMIN] Speed problem

On Wed, 4 Nov 1998, Terry Mackintosh wrote: > > I have a rather large database as well (> 2 Meg of tuples). I thought > > my system was souped up enough: PII/400 MHz (100 MHz bus) 256 Meg SDRAM, > > 18 Gig SCSI harddrive, Red Hat Linux 5.1. However, my swap space (512 > > Meg) is on the same

Re: [ADMIN] Speed problem

On Tue, 3 Nov 1998, Roger Books wrote: > I have a database that I need to pull the schema off of. When > I run pg_dump -s the machine rolls over and dies. To the tune > of I left it running over the weekend and still had 98% cpu > usage by postgress monday. I managed to do a 'delete from stati

Re: [ADMIN] Postgres on Solaris Intel/Sparc

On Thu, 24 Sep 1998, Bernhard Ertl wrote: > Has someone made experiences installing Postgres on Solaris 2.6 Systems > on Sparc or Intel base? Have done so on both v2.5.1 and v2.6 Sparc...what's up? Marc G. Fournier Systems Administrator @ hub.org primary

Re: [ADMIN] Error in compiling

On Wed, 16 Sep 1998, Marc Eggenberger wrote: > Hi. > > I'm trying to compile the postgreSQL on a Sun Sparc5 with Solaris 2.6 ... the first >hint (installing bison) took me further ... but now another error occurs: > > make[3]: Leaving directory `/usr/share/src/pgsql/src/interfaces/ecpg/lib' >

Re: [ADMIN] Compilation error

On Tue, 15 Sep 1998, Ricardo Valdivia wrote: > Hi, I'm novice with postgreSQL and I want to install it. I have > a Sun machine with SunOS 4.1.3. > > While I'm compiling, it shows the next error message: > > gmake[2]: Entering directory > `/usr/share/src/pgsql/postgresql-6.3.2/src/backend/parser

Re: [ADMIN] Online Backup

On Fri, 3 Jul 1998, Jeremy G Byrne wrote: > Dear All-- > > I'm investigating PostgreSQL for a web-based dB project, and have been > unable to find any documentation about its abilities to perform backups > while online. > > The Features Comparison table on the postgresql.org site lists this as

Re: [ADMIN] Importing data

On Tue, 30 Jun 1998, Jeffrey Napolitano wrote: > > > I'm new to Postgres(or otherwise I probably wouldn't be sending this), > > > and I've gone through the HTML docs online, and looked at the man pages, > > > but I can't find anything about importing ODBC compliant data into > > > postgres ... I

Re: [ADMIN] Problem getting postgres running.

On Thu, 11 Jun 1998, Andy Doerr wrote: > Andy Doerr > [EMAIL PROTECTED] > > FreeBSD 2.2.2 > > FreeBSD AtlantisPublishing.COM 2.2.2-RELEASE FreeBSD 2.2.2-RELEASE #0: Thu > Apr 9 15:22:39 CDT 1998 > [EMAIL PROTECTED]:/usr/src/sys/compile/ATLANTIS i386 > > CPU: Pentium Pro (199.44-MHz 686-c

Re: [ADMIN] New pgAdmin program fails installation...

On Fri, 26 Jun 1998, James Olin Oden wrote: > > So anyway, I can't figure out how to get around this other than manually > installing it. > > Anyway, I just wanted someone who cared to know...james > > > Sorry if I placed this email in the wrong place For future reference, should hav

Re: [ADMIN] Still having trouble compiling Postgresql

On Fri, 26 Jun 1998, Oliver Mueschke wrote: > i'm running suse linux, too. maybe it's not the "official" way to fix > this, but changing one line in Makefile.global did the job. after > running configure i appended " -lncurses" to the line LDFLAGS=... in > Makefile.global. i guess, there should b

[ADMIN] Compiling PostgreSQL (fwd)

Morning... Someone else might know better, but can you try: ./configure --with-template=hpux-cc -- Forwarded message -- Date: Wed, 24 Jun 1998 13:39:32 -0600 (MDT) From: giuli t <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Compiling PostgreSQL

[ADMIN] Re: [NOVICE] Postgresql won't compile

This email has been redirected to [EMAIL PROTECTED]*this* is why I was against a 'novice' list in the first place *sigh* On 24 Jun 1998, John Bright wrote: > Hi, > Thanks for the very quick response. > In answer to your questions, am currently running SuSE Linux > 5.1. > Am attaching a c

Re: [ADMIN] moving databases

On Mon, 22 Jun 1998, Kevin Heflin wrote: > what would be the easiest way to move databases from one postgresql > server to another? pg_dump or pg_dumpall

Re: [ADMIN] Unable to start Postmaster

On Tue, 23 Jun 1998, rahul wrote: > Hello. I have installed PG95 on Linux which came with RH5.0 dist. Now > with all the > default config I am unable to start the Postmaster and not able to > proceed further. Please provide more details, like what error messages are generated when you try to sta

Re: [ADMIN] Problems starting

On Wed, 17 Jun 1998 [EMAIL PROTECTED] wrote: > > Im getting this error whenever I try running PostgreSQL: > > IpcMemoryCreate: memKey=5432010 , size=24588 , > permission=448IpcMemoryCreate: shmget(..., create, ...) failed: Permission > denied > This type of error is usually caused by improper >

Re: [ADMIN] Problems with 6.3.2

On Fri, 19 Jun 1998, Dirk Elmendorf wrote: > > I'm trying to install Postgres 6.3.2. I've upgraded from 6.2. > I'm running Red Hat Linux 4.2 (kernel 2.0.34) on X86 > > I've applied all the patches in the patches directory and I have removed al > l traces of previous installs. I've seached throu

[ADMIN] Re: your mail

On Wed, 17 Jun 1998, Joey Officer wrote: > [sql@dabeast sql]$ initdb > initdb: using /usr/local/pgsql/lib/local1_template1.bki.source as input > to create the template database. > initdb: using /usr/local/pgsql/lib/global1.bki.source as input to create > the global classes. > initdb: using /usr/l

Re: [ADMIN] SYSVSEM?

On Mon, 8 Jun 1998, Harri Varpanen wrote: > Hi, > > I'd like to begin experimenting with databases so I installed the > FreeBSD port for postgreSQL 6.3.2. The installation went well but I don't > seem to get anything done; this is what I get: > > -- > > $ createuser (or any command whatsoever)

Re: [ADMIN] problem with initdb

On Tue, 2 Jun 1998, Tan Poh Soon wrote: > > > When i run the initdb, the following message shown: > > > We are initializing the database system with username pstan (uid=501). > > This user will own all the files and must also own the server process. > > > initdb: creating template da

Re: [ADMIN] postgresql questions

On Tue, 2 Jun 1998, Chan Fook Sheng wrote: > 4) when I run "psql template1 " or "createdb test" I get the following: > > connection to database 'template1' failed. > PQexec() -- Request was sent to backend, but backend closed the channel > before responding. This probably means the backend termi

Re: [ADMIN] InitDB-Problem

On Mon, 25 May 1998, Dany K. wrote: > Hi everybody, > > I just downloaded and installed the new PostgreSQL 6.3.2. Everything went > fine including the installation. > Now my problem: When i run "initdb", the following error message appears : > >

[ADMIN] initdb failing on a WARN:heap_modifytuple error

Hi all, Here is a transcript of what happened when I tried to run initdb on my system. My system is Linux 2.0.32 Redhat 5.0 and I was installing Postgres 6.3.2 I can't find any documentation on this particular error. Thanks! -Fran postgres:src$ initdb initdb: using /usr/local/pgsql/lib/loca

[ADMIN] gmake install and initdb problems

Hi, I've just finished compiling postgresql v6.3 on my sparcstation2. While trying to complete the installation I ran into a problem with initdb. My output looks like this: > initdb: using /usr/local/pgsql/lib/local1_template1.bki.source as > input to creat e the template database. > initdb:

Re: [ADMIN] postgresql-6.3.2 question

On Sun, 17 May 1998, Brett W. McCoy wrote: > On Sun, 17 May 1998, The Hermit Hacker wrote: > > > Why? Once you've added the postgres user, with his home > > directory, the postgres users himself should be able to do the complete > > install... > > Exce

Re: [ADMIN] postgresql-6.3.2 question

On Sun, 17 May 1998, Brett W. McCoy wrote: > On Sun, 17 May 1998, Andy Lewis wrote: > > > I'm not totall sure but, I wouldn't think that user postgres has enough system > > rights to install. > > You should be root when doing the actual software installation to > /usr/local, but everything else

Re: [ADMIN] postgresql-6.3.2 question

On Sun, 17 May 1998, Andy Lewis wrote: > I'm not totall sure but, I wouldn't think that user postgres has enough system > rights to install. Everything for PostgreSQL gets installed, generally, in postgres users home directory...I've never had a requirement to install as anything but pos

[ADMIN] PostgreSQL questions

Hi, I just installed the postgresql database into our Sun enterprise 5000 machine. I have a few questions to ask if you don't mind. 1. Is there a TCL extension to this database? I see you have a pgtksh, pktclsh interpreter compiled with the package. I was thinking if I can have the postg

[ADMIN] postgresql-6.3.2 question

Hello, My question is this: Do I have to be user progres to install? Can I not use an existing user? If yes, is there any change to the installation process? Thank you in advance for your help. Dave

No Subject

=== This message has been sent to a DEAD mailing list, and subsequently reforwarded to the proper one: [EMAIL PROTECTED] === Hello! I'm a developer who is developin