Re: [GENERAL] install problem
Dear Wayne, Hum! you are not following exactly the instructions for a "Short Installation" which is: ./configure gmake su gmake install adduser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 & /usr/local/pgsql/bin/createdb test /usr/local/pgsql/bin/psql test Anyway, what did you enter after "useradd"? That command requires at least one parameter, the new user name which in this case should be postgres. Once that is done, the "su postgres" will work without any password since you are running it from root. Regards, Bernard On Saturday 09 October 2004 10:29, wayne schlemitz wrote: > I am using SuSE 8.0 Professional Linux and installing > postresql 7.4 by placing the tar files in /temp and > untar and unzip and followed the short install > procedure. > Log in as root > ./ configure > gmake > gmake install > useradd > mkdir /usr/local/pgsql/data > chown postgres /usr/local/pgsql/data > su postgres > /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data > ""same as above"" >logfile 2>&1 & > > At this point I checked the last 2 lines to enter and > was told I do not have the password for the postges > sence it is not a person but a program it should not > ask for the password. Have not had sucess to call up > the program or to finish the last 2 lines. > /usr/local/pgsql/bin/createdb test > /usr/local/pgsql/bin/pgsql test > > What can I do to finish the last 2 lines and call up > the potgres or pgsql? > > > > > ___ > Do you Yahoo!? > Declare Yourself - Register online to vote today! > http://vote.yahoo.com > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster ---(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 list cleanly
Re: [GENERAL] 7.5 Windows version
Hello Jonathan, Take look at URL: http://techer.pascal.free.fr/postgis/psqlwin/ That French guy has a binary version of PG for Windows. The zip is at URL: http://techer.pascal.free.fr/postgis/psqlwin.zip Note that I did not tried it! Good luck! Bernard On Tuesday 22 June 2004 15:13, Jonathan Barnhart wrote: > Is there any chance I can get a pre-release executable of the Windows > native Postgresql so I can start doing some application development? I > do not intend to deploy a buggy postgres, but even if it goes boom > occasionally it will allow me to build the app so that when everything > is finalized I'm months ahead on development. > > It's important to note that I mainly use Borland compilers so unless > this will compile in c++ builder, I'll need executables. > > = > "We'll do the undoable, work the unworkable, scrute the inscrutable and > have a long, hard look at the ineffable to see whether it might not be > effed after all" > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postgresql.org ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] [pgsql-advocacy] Best open source db poll currently
Done too :) Hum! IMHO not so many people because when I click PG went from 16% to 17% immediately. Bernard On Wednesday 31 March 2004 14:09, Marc G. Fournier wrote: > Done :) > > Guys ... poll now shows 53% for MaxDB (ie. MySQL) and 15% for PostgreSQL > ... think we can improve on that? :) > > http://www.casestudio.com > > On Wed, 31 Mar 2004, Martin Marques wrote: > > El Mar 30 Mar 2004 11:13, Marc G. Fournier escribió: > > > MaxDB - 62% > > > PostgreSQL - 13% > > > > If you throw this to the pgsql-general list that 13% will blow up, > > showing how stupid this polls are. > > > > > On Tue, 30 Mar 2004, Bruno Baguette wrote: > > > > Hello, > > > > > > > > I noticed a best open source db poll on http://www.casestudio.com > > > > (left column) where PostgreSQL is the latest currently ! :-( > > > > > > > > So, just go on that site and vote for your favorite Open Source > > > > database system ! :-) > > > > -- > > 15:47:02 up 22 days, 20:15, 2 users, load average: 0.28, 0.69, 0.46 > > - > > Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' > > Centro de Telematica | DBA, Programador, Administrador > > Universidad Nacional > > del Litoral > > - > > > Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) > Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 > > ---(end of broadcast)--- > TIP 8: explain analyze is your friend ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] License on PostgreSQL
There is no license fee either for commercial or non commercial usage as state: " Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies. HOWEVER, I AM NOT A LAWER, THEREFORE I COULD BE WRONG. Regards, Bernard On Thursday 25 March 2004 01:19, 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 would like to know that is it > necessary to pay any license charge on the usage of PostgreSQL as > database server for commercial purpose. If so, how much of it?? Does it > charge on server basis or client basis?? > > > > Best Regards, > Eric Yum > CK Life Sciences Ltd. > Finance & Administration - IT Team > Tel: 21261351 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] returning row numbers in select
Maybe by using a sequence and a function. The sequece to generate the row number. The a function 1) to reset the sequence and 2) to perform a select with the first column nextval(seq) and the column the timestamp However, I am a newbie with PostgreSQL and I am not sure it this will work correctly...you might have to play with it (or wait for somebody with more experience than me). Bernard On Wednesday 10 March 2004 16:23, Randall Skelton wrote: > >> I to return a sequential row number beginning at 1? > >> > >> i.e. > >> > >> row| timestamp > >> ---+ > >> 1 2004-02-01 23:15:00.824-05 > >> 2 2004-02-01 23:15:01.824-05 > >> 3 2004-02-01 23:15:02.824-05 > >> ... > >> > >> My reason for wanting row numbers is so I can use a 'MOD(row_number, > >> n)' to get the nth row from the table. > > Correction, I don't want to simply get the nth row, I want all rows > that are divisible by n. Essentially, the timestamp is at a regular > interval and I want a way of selecting rows at different sampling > intervals. > > > Doesn't LIMIT and OFFSET do the job? > > http://www.postgresql.org/docs/7.3/interactive/queries-limit.html > > It would if I only wanted an offset butI want a query to return the > first, fifth, and tenth, and so on row. This would be 'MOD(row_num, > 5)' but given that I don't know the number of rows a priori, it is > difficult to write a LIMIT. Moreover, the offset doesn't make it easy > to get the first row. Unless, of course, I am missing something > obvious? > > Cheers, > Randall > > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 8: explain analyze is your friend
