Re: [GENERAL] Suse Linux 10.0

2006-01-12 Thread Jerome Lyles
On Sunday 08 January 2006 06:36, John Meyer wrote: > Jerome Lyles wrote: > > On Thursday 05 January 2006 10:57, Peter Eisentraut wrote: > >> Am Donnerstag, 5. Januar 2006 21:15 schrieb Joseph M. Day: > >>> Has anyone been able to get the latest version of Postgres

Re: [GENERAL] Suse Linux 10.0

2006-01-08 Thread Jerome Lyles
On Thursday 05 January 2006 10:57, Peter Eisentraut wrote: > Am Donnerstag, 5. Januar 2006 21:15 schrieb Joseph M. Day: > > Has anyone been able to get the latest version of Postgres working on > > Suse 10.0 ? I just switched form Fedora and realized that this version > > is not specifically suppor

[GENERAL] Spacing in output

2004-09-14 Thread Jerome Lyles
I have a small training database: sql_tutorial. It works fine but the spacing between the output lines is too much. This is the way it looks when I copy and paste from the Konsole to this email: sql_tutorial=> SELECT prod_name FROM Products; prod_nam

Re: [GENERAL] Postgresql and scripting

2004-09-08 Thread Jerome Lyles
On Tuesday 07 September 2004 10:22 pm, Dorward villaruz wrote: > hi! > > try this in commandline i assume you save the file in sams.txt > final file will be sams2.txt > > cat sams.txt | sed -e 's/ /@@/g' -e 's/ //g' -e 's/@@/ /g' > sams2.txt > > or put this in a script say convert.sh > > script st

[GENERAL] Postgresql and scripting

2004-09-08 Thread Jerome Lyles
I took the white space between characters out of my script 'create.txt4' and ran it on database 'test'. There were errors: 26 27 -- Create Orders Table 28 29 CREATE TABLE Orders 30 ( 31Order_num int NOT NULL, 32Order_datedatetimeNOT NULL, 33cust_id char

Re: [GENERAL] Permission Problems:-)?

2004-01-27 Thread Jerome Lyles
On Tuesday 27 January 2004 03:51 pm, Alvaro Herrera wrote: > On Tue, Jan 27, 2004 at 03:08:23PM -1000, Jerome Lyles wrote: > > > I don't think so --- the postmaster will actively refuse to start if > > > you try to run it as root. Better take another look at exac

Re: [GENERAL] Permission Problems:-)?

2004-01-27 Thread Jerome Lyles
On Tuesday 27 January 2004 06:41 am, Tom Lane wrote: > Jerome Lyles <[EMAIL PROTECTED]> writes: > > I'm trying to build a database. But none of the users I try to use > > works. > > I think you are confused about the distinction between Postgres users > and

Re: [GENERAL] Permission Problems:-)?

2004-01-27 Thread Jerome Lyles
On Tuesday 27 January 2004 12:05 am, Richard Huxton wrote: > > OK - it's complaining it can't connect to template1. This is the database > that contains all the default tables/types/functions etc. that will appear > in your new database. > > First thing to check is that PG is running. Does it show

[GENERAL] Permission Problems:-)?

2004-01-27 Thread Jerome Lyles
I'm trying to build a database. But none of the users I try to use works. I as normal user doesn't work: :~> createdb mydb createdb: could not connect to database template1: FATAL: user "adriel" does not exist I as postgresql user doesn't work: :~> createdb mydb createdb: could not connect to

[GENERAL] Where is initdb?

2004-01-26 Thread Jerome Lyles
Hello List, I have installed Postgresql 7.4 on a Suse 9.0 system using apt. I cannot do this: /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data Because there is no "/pgsql/bin/initdb" nor /pgsql/bin/ on my system. Since apt did not create these directories how can I do it manually? Thanks, Je