Re: [ADMIN] initdb failing - core dump

2002-07-15 Thread Tom Lane
"Ben Witkowski" <[EMAIL PROTECTED]> writes: > creating template1 database in /usr/local/pgsql/data/base/1... Bad system > call - core dumped According to the FAQ, "bad system call" is usually a symptom of not having SysV IPC support enabled in your kernel ... regards, tom

Re: [ADMIN] Performance impact of record sizes

2002-07-15 Thread Bruce Momjian
Bruce Momjian wrote: > > I see in the data types section for character types this text: > > There are no performance differences between these three types, > apart from the increased storage size when using the blank-padded > type. > > I can't improve on that. I added a mention

Re: [ADMIN] Performance impact of record sizes

2002-07-15 Thread Bruce Momjian
I see in the data types section for character types this text: There are no performance differences between these three types, apart from the increased storage size when using the blank-padded type. I can't improve on that. ---

Re: [ADMIN] Controlling performance impact of multiple users

2002-07-15 Thread Curt Sampson
On Mon, 15 Jul 2002, John Moore wrote: > This is how we did it at a previous employer. I was hoping somebody has > some other trick, since we don't have any easy way to replicate the data! Well, if you've got scheduled downtime every day, and can live with once-a-day updates, you could always sh

[ADMIN] initdb failing - core dump

2002-07-15 Thread Ben Witkowski
running initdb gives the following: /usr/ports/databases/postgresql7>su -l pgsql -c initdb The files belonging to this database system will be owned by user "pgsql". This user must also own the server process. creating directory /usr/local/pgs

Re: [ADMIN] Help

2002-07-15 Thread Bruce Momjian
Chad R. Larson wrote: > At 10:12 PM 7/11/02 , Bernal Fernandez wrote: > >A grafic tool exists to administer the data base? > > Several that I know of. One for UNIX/X11 written in TCL/TK and one for The tcl one is pgaccess in the source tree or at www.pgaccess.org. > Windows written as a nativ

Re: [ADMIN] problems removing foreign-key triggers, postgresql 7.1.1

2002-07-15 Thread Stephan Szabo
On Sun, 14 Jul 2002, Andre Schlieper wrote: > Hi there, > I've some problems droping tiggers (foreign key-constraint) on > postgresql 7.1.1, > example-tables are like this : > > CREATE TABLE pers ( > pid INT NOT NULL PRIMARY KEY, > pname TEXT NOT NULL); > > CREATE

Re: [ADMIN] Help

2002-07-15 Thread Chad R. Larson
At 10:12 PM 7/11/02 , Bernal Fernandez wrote: >A grafic tool exists to administer the data base? Several that I know of. One for UNIX/X11 written in TCL/TK and one for Windows written as a native Window application. There are probably more. Check http://pgadmin.postgresql.org for the Windows

Re: [ADMIN] Controlling performance impact of multiple users

2002-07-15 Thread John Moore
At 09:04 PM 7/14/2002, Curt Sampson wrote: >On Thu, 11 Jul 2002, John Moore wrote: > > > The issue is how to prevent users from hogging the system, and especially > > from slowing down the on-line users. > >Mixing OLTP and OLAP on one database server has never seemed like a good >idea to me. Part

[ADMIN] Novedad Mundial

2002-07-15 Thread Portatiles.net
  Con 4 años sus hijos se familiarizaran jugando,con su herramienta del futuro PEDIDOS : 902 30 12 30 POR EMAIL: [EMAIL PROTECTED] PEDIDOS: MANDAR E-MAIL O FAX CON LOS SIGUIENTES DATOS: -NOMBRE O RAZON SOCIAL -CIF/NIF -TELEFONO DE CONTACTO -DIRECCION Y CODIGO POSTAL   FAX: 954 27 92

[ADMIN] FROM $200 TO $2000 IN 30 DAYS!

2002-07-15 Thread Remove
TURN $200 INTO $2000 & MORE IN 30 DAYS TURN-KEY SYSTEM – RECEIVE $2,000 WITHIN FIRST 30 DAYS. THEN $3,600/MONTH IN RESIDUALS Do you need cash infusion so you can build your MLM, buy a new car, or just pay some bills? ONLY $200 ONE TIME!! This is a private by-invitation-only activity. NO d

[ADMIN]

2002-07-15 Thread ventas
---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[ADMIN]

2002-07-15 Thread ventas
---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] FW:> Men & Women, Spruce up your life! 2338

2002-07-15 Thread bcase23117
NEW! -> Vigoral Herbal Love Enhancers <- NEW! Straight from our lab to you! We Now Offer 3 NEW - Specially Formulated & 100% Natural - products to help stimulate your moments with that special someone for Only $24.99! "The Most Exciti

[ADMIN] Du nouveau sur la toile

2002-07-15 Thread admin
bonjour, juste un petit mail pour vous informer qu'il y a du 'nouveau' sur le web: LE RETOUR DU GRATUIT ! http://www.chouab.com/ vous propose: - Une mail-liste gratuite, - Un monitoring serveur gratuit, - une regie publicitaire gratuite, - un memo-mail gratuit ... Le site vous propose aussi u

[ADMIN] Corrupted Database

2002-07-15 Thread Martin Kuria
Hi, my linux machine crushed and my postgresql 6.5 database was corrupted. I have /var/lib/pgsql/data intact, When I reinstalled Linux in a new machine, Can I copy this directory back in the new postgresql database, and will it work, because I have tried to do that but it did not work. Note: I

[ADMIN] problems removing foreign-key triggers, postgresql 7.1.1

2002-07-15 Thread Andre Schlieper
Hi there, I've some problems droping tiggers (foreign key-constraint) on postgresql 7.1.1, example-tables are like this : CREATE TABLE pers ( pid INT NOT NULL PRIMARY KEY, pname TEXT NOT NULL); CREATE TABLE tasks ( taskidSERIAL NOT NULL PRIMARY KEY,

[ADMIN] Help

2002-07-15 Thread Bernal Fernandez
Hi A grafic tool exists to administer the data base? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing li

[ADMIN] Help

2002-07-15 Thread Orion Orion
Hi. A grafic tool exists to administer the data base Thank you __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com ---(end of broadcast)--- TIP 1: subscribe and unsub

Re: [ADMIN] Indexes on separate disk ?

2002-07-15 Thread Steve Lane
On 6/13/02 10:22 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote: > BTW, I'd certainly recommend getting the WAL files (pg_xlog directory) > moved to their own drive long before you worry about separating indexes > from data. That's a lot simpler (you only need a symlink for the > directory). tom: Co

Re: [ADMIN] [SQL]

2002-07-15 Thread Bruce Momjian
Wallingford, Ted wrote: > Hi, > > Can any of you hackers tell me where postgres looks for pg_hba.conf when it > starts up? In /data. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, |

[ADMIN]

2002-07-15 Thread Wallingford, Ted
Hi, Can any of you hackers tell me where postgres looks for pg_hba.conf when it starts up? Thanks, Ted ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]