[GENERAL] pgaccess not connecting
Running Debian 2.2. Had to reinstall postgresql 7.02 Can access database with psql but not pgaccess. The log that follows is from a stop and restart of postmaster. Script started on Sat Aug 26 01:17:33 2000 kgb10:/home/billb# /etc/init.d/postgresql stop Stopping PostgreSQL postmaster Stopped /usr/lib/postgresql/bin/postmaster (pid 24386). kgb10:/home/billb# /etc/init.d/postgresql stop kgb10:/home/billb# /etc/init.d/postgreql start -i Starting PostgreSQL postmaster kgb10:/home/billb# ps ax | grep postmaster 24746 pts/5S 0:00 /usr/lib/postgresql/bin/postmaster -b /usr/lib/postgresql/bin/postgres -B 128 -D /var/lib/postgres/data -d 0 24749 pts/5S 0:00 grep postmaster kgb10:/home/billb# ls -al /tmp | grep .s.PGSQL srwxrwxrwx1 postgres postgres0 Aug 26 01:18 .s.PGSQL.5432 kgb10:/home/billb# exit What could account for the missing -i switch in the running postmaster? The last 2 lines of /etc/init.d/postgresql/pg_hda.conf: # By default, allow anything over UNIX domain sockets and localhost. localall trust host all 127.0.0.1 255.255.255.255 trust Thanks Bill Barnes
RE: [GENERAL] pgaccess not connecting
That's it. Found the switch in /etc/postgresql/postmaster.init. Thank you very much, Bill >= Original Message From Tom Lane <[EMAIL PROTECTED]> = >Bill Barnes <[EMAIL PROTECTED]> writes: >> kgb10:/home/billb# /etc/init.d/postgreql start -i >> Starting PostgreSQL postmaster >> kgb10:/home/billb# ps ax | grep postmaster >> 24746 pts/5S 0:00 /usr/lib/postgresql/bin/postmaster -b >> /usr/lib/postgresql/bin/postgres -B 128 -D >> /var/lib/postgres/data -d 0 > >> What could account for the missing -i switch in the running postmaster? > >Are you sure your /etc/init.d/postgreql is designed to pass its own >commandline switches on to the invoked postmaster? Usually startup >scripts don't do that, since they are not designed to be run by hand >but from /etc/rc. My bet is that there is a config file somewhere that >the init.d script is reading (which is where the other switches given >to the postmaster are coming from). You need to put -i in that file. > >regards, tom lane
RE: [GENERAL] pgaccess not connecting
Thanks for the response. You will already have my last posting. The script, BTW, I referred to at /etc/postgresql/postmaster.init has the tag PGALLOWTCPIP=yes/no and the default is no. regards, Bill >= Original Message From Jesus Aneiros <[EMAIL PROTECTED]> = >Check the script in /etc/rc.d/init.d/postgresql it doesn't accept >parameters in the command linea except start, stop, status. Change the >line that runs postmaster adding -i option. > >-- >Jesus Aneiros Sosa >mailto:[EMAIL PROTECTED] >http://jagua.cfg.sld.cu/~aneiros > >On Sat, 26 Aug 2000, Tom Lane wrote: > >> Bill Barnes <[EMAIL PROTECTED]> writes: >> > kgb10:/home/billb# /etc/init.d/postgreql start -i >> > Starting PostgreSQL postmaster >> > kgb10:/home/billb# ps ax | grep postmaster >> > 24746 pts/5S 0:00 /usr/lib/postgresql/bin/postmaster -b >> > /usr/lib/postgresql/bin/postgres -B 128 -D >> > /var/lib/postgres/data -d 0 >> >> > What could account for the missing -i switch in the running postmaster? >> >> Are you sure your /etc/init.d/postgreql is designed to pass its own >> commandline switches on to the invoked postmaster? Usually startup >> scripts don't do that, since they are not designed to be run by hand >> but from /etc/rc. My bet is that there is a config file somewhere that >> the init.d script is reading (which is where the other switches given >> to the postmaster are coming from). You need to put -i in that file. >> >> regards, tom lane >>
RE: [GENERAL] 7.1 Release Date
Oh, if only I could be so sanguine about my learning curve in matters of Linux, PostgreSQL, Enhydra, Glade, gnome-db, bonobo, HTML, XML, DHCP, NIS, NSF, DNS, ABC, XYZ, ETC, ETC, ETC. Bill >= Original Message From Lamar Owen <[EMAIL PROTECTED]> = >Tom Lane wrote: >> Lamar Owen <[EMAIL PROTECTED]> writes: >> > Did you also miss where I'm willing to do the legwork myself? > >> If you want to write and maintain such an update program, no one is >> going to stand in your way ;-). > >I was afraid you'd say that. :-) As long as I can get questions >answered here about the gory details, and without laughing too hard at >my missteps, I'll see if I can tackle this. > >> Personally I am not going to work on such a thing; I have a very long >> list of to-do items that I consider more pressing and more interesting. > >Like Outer Joins? (which I also consider more pressing and more >interesting -- and more out of my reach). > >> But hey, it's open source: *you* can fix the problems that *you* >> consider pressing and interesting. Go for it. > >Pressing, yes. Interesting? Not particularly. Useful? Most >definitely. Educational? I'm liable to learn quite a bit. > >-- >Lamar Owen >WGCR Internet Radio >1 Peter 4:11
RE: [GENERAL] are my questions being received?
Yes >= Original Message From [EMAIL PROTECTED] (Wade D. Oberpriller) = >Hello, > >Are my questions being posted? If so, could someone just reply so I have peace >of mind. > >Wade Oberpriller >StorageTek >[EMAIL PROTECTED]
RE: [GENERAL] Talking with other Dbases.
If memory serves me correctly, Virtuoso (OpenLinkSW) and AOLserver both claim inter-database connections. >= Original Message From "Mitch Vincent" <[EMAIL PROTECTED]> = >> Hi, >> >> I'm pretty new to PgSQL (been lurking) and am wondering if >> it's possible to talk with other DB's easily? I'm using >> FreeBSD atm and the project I'm working on will be moving >> from dbase to postgres in the next release. It will also >> have a web based side to it that I plan on using MySQL for >> possibly, since all it's going to do is return records. >> (I have yet to do some testing between postgres and mysql >> to determine if pgsql would be sufficient or mysql would >> work better). > >If you're talking about connecting to another RDBMSs from within PostgreSQL >I suppose it would be possible with custom written functions (since most >RDBMSs have a C API) but it being easy depends on your level of experience >with C (and the two database APIs).. > > > Is it possible to write data to other databases? Also >> is it possible to get a secure connection between 2 postgres >> databases, or other databases for that matter? Either through >> ssh or Kerberos(sp?) etc etc. > >You can tunnel virtually anything through SSH, sure. > >I know MySQL is fast but just remember, it's just "A filesystem with an SQL >interface" -- that's ALL... :-) > >-Mitch
[GENERAL] RE: pgaccess on Win95
>> Has anyone been able to execute the subject on PostgreSQL7.0.2 >> Error message reports unable to find libraries. > >You need to have Tcl/Tk installed. > >-- >Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ I should have been more specific. Sorry! TclPro 1.4 (evaluation copy) is installed. Uses Tcl vs 8.3. It is in directory \Program Files\TclPRO 1.4 pgaccess version 0.98.6 is installed in ~\TclPro 1.4. It lists the following files in ~\pgaccess\win32\dll libpgtcl80.dll-6.4.2 libpgtcl80.dll-6.5.1 libpgtcl81.dll-6.5.1 libpgtcl82.dll-6.5 libpq.dll-6.4.2 libpq.dll-6.5.1 pgaccess in Linux supports pg vs 7.x. What has to be done to bring the windows version up to speed.? Thanks for your help, Bill Get your own FREE, personal Netscape WebMail account today at http://home.netscape.com/webmail
[GENERAL] archive search fails
Entering a search request at the archives website yields the following result: the website for ReadySetNet Error: File not found - Did you enter the correct domain name or URL Same results in Opera and Netscape. Appreciate a fix. Bill __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
[GENERAL] Re: A How-To: PostgreSQL from Tcl via ODBC
Hooray! These instructions are just what an almost-novice needs. With the exception of changing the password to 'postgresql', the procedures started smoothly. Ran into a hitch at 'make' which reported that 'bison' was not installed. I'm running debian potato, so used the apt-get install of bison. Bison is installed in /usr/bin. I copied it to /home/billb/pgsql. Still getting the 'bison missing' message. Can anyone show me the error of my ways. TIA Bill --- Dan Lyke <[EMAIL PROTECTED]> wrote: > A friend asked me to figure out how to access > PostgreSQL from Tcl via > ODBC. For posterity, here's the step by step "how I > did it" that I > emailed to him. I don't know Tcl, this was just > about getting the > compile options correct and doing the proper > sysadminning to make > things work. > > Comments, suggestions and clarifications > appreciated, hopefully this > will save the next person going through the pain a > few steps: > > http://www.flutterby.com/archives/2001_Feb/19_PostgreSQLfromTclwithODBC.html __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
Re: [GENERAL] Re: A How-To: PostgreSQL from Tcl via ODBC
Thanks. That cleared the bison problem. flex didn't work the same way though. Copied it also to /home/billb/pgsql. Reported missing. Needs to go someplace else? TIA Bill --- Tom Lane <[EMAIL PROTECTED]> wrote: > Bill Barnes <[EMAIL PROTECTED]> writes: > > Ran into a hitch at 'make' which reported that > 'bison' > > was not installed. I'm running debian potato, so > used > > the apt-get install of bison. Bison is installed > in > > /usr/bin. I copied it to /home/billb/pgsql. > > > Still getting the 'bison missing' message. > > Re-run configure, and watch to make sure that it > finds bison this time. > You'll need flex too, if you intend to build from > CVS sources. > > regards, tom lane __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
[GENERAL] RE: postgresql-tcl-7.03 requires libtcl8.0.so
Aah! Life is so good when things are working. Thanks very much. Regards, Bill --- "Trewern, Ben" <[EMAIL PROTECTED]> wrote: > Mandrake 7.2 includes tcl-8.3.2-4mdk. Make sure > this is installed then, as > long as thats the only remaining dependency, install > postgresql-tcl-7.0.3-2mdk with --nodeps and all > seems to work ;-) > > Regards > > Ben > > > -Original Message- > > From: Bill Barnes [mailto:[EMAIL PROTECTED]] > > Sent: 27 February 2001 09:59 > > To: pg-general > > Subject: [GENERAL] postgresql-tcl-7.03 requires > libtcl8.0.so > > > > > > > > > > > > The required library comes from tcl8.0 and I have > been > > all over the web looking for it. Does anyone have > a > > URL for this? > > > > Would like to run pgaccess. Downloading that one, > > however, leads me into another mess looking for > > 'main.tcl'. > > > > Running Mandrake 7.2. > > > > Thanks for your help. > > > > -Bill > > > > __ > > Do You Yahoo!? > > Get email at your own domain with Yahoo! Mail. > > http://personal.mail.yahoo.com/ > > > __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
[GENERAL] pgaccess on Win9x
Hi Y'all: Unzipped pgaccess to C:\. Have TclPro 1.4 at c:\Program Files\TclPro1.4 Executing C:\pgaccess\main.tcl I get: couldn't load library "libpgtcl.dll": this library or a dependent library could not be found in library path while executing "load libpgtcl[info sharedlibextension]" [procedure "main" line 3] invoked from within "main $argc $argv" [file "C:\PGACCESS\MAIN.TCL" line 249] Copied libpgtcl83.dll-7.0 to \windows\system as libpgtcl.dll. Appreciate your help. -bill __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[GENERAL] URL for gmake
Trying to rebuild v6.5.3 and the procedure calls for gmake. A google search is a dog-chasing-tail exercise. Can anybody help with a URL or an alternative. Thanks, -Bill __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[GENERAL] Re: URL for gmake
Wow! Got a lot of reponses. Thanks all. I must be, however, asking the wrong question. Running debian 2.2 and make is in the system. Here's a short list of the last few commands: $./configure --prefix=/usr/local/pgsql --with-odbc $make all > make.log 2>&1 & [1] 8486 $tail -f make.log lot of missing prototypes messages but it gurgled on and finally said All of Postgresql is successfully made. Ready to install. had to Ctrl-c to get terminal back $gmake install > make.install.log 2>&1 & [2] 10419 [1] Done(127) gmake install >make.install.log 2&1 $tail -f make.install.log sh: gmake: command not found Thus the reason for confusion about gmake. Cannot find a binary or link for gmake. How does it get called. Thanks again, -Bill --- Bill Barnes <[EMAIL PROTECTED]> wrote: > > Trying to rebuild v6.5.3 and the procedure calls for > gmake. > > A google search is a dog-chasing-tail exercise. > > Can anybody help with a URL or an alternative. > > Thanks, > -Bill > __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[GENERAL] Re: HOWTO for pg 7.1 installation from cvs
Well, this wasn't the posting I had in mind, but it's even better. Didn't know that 7.1 was so well documented. Thanks, Developers. For anyone else's benefits here's the URL for the CVS fetch. http://www.postgresql.org/devel-corner/docs/postgres/cvs.html And here's the URL for the installation procedure. http://www.postgresql.org/devel-corner/docs/postgres/install-procedure.html I' m still in trouble, however. Install in Mandrake 7.2 gives me an error message: In file included from pgtkAppInit.c:15: /usr/include/tk.h:83: X11/Xlib.h: No such file or directory A search thru Google turns up only a bunch of postings asking where Xlib.h is. Install in Debian 2.2 gives me an error message: tclConfig.sh is required for Tcl Debian does, however, have X11/Xlib.h Thanks for your help. -Bill > > Hello All: > > I lost it. Printed it, used it, trashed it. > > There was recently a very well done procedure for > compiling postgres 7.1 from cvs posted to one of the > lists. http://www.postgresql.org/devel-corner/docs/postgres/cvs.html > __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] Installing in SuSE 7.1
Thanks for the responses to my question. Tried the RH rpm's and fell into endless layers of dependencies. Solved the problem with purchase of Red Hat 7.1. I always appreciate the efforts that listers make. Hope to repay in kind. -Bill --- Trond Eivind Glomsrød <[EMAIL PROTECTED]> wrote: > Martín Marqués <[EMAIL PROTECTED]> writes: > > > On Jue 03 May 2001 22:51, Trond Eivind Glomsrød > wrote: > > > Bill Barnes <[EMAIL PROTECTED]> writes: > > > > Does anyone know of a package for 7.0.3 or 7.1 > that > > > > will install in SuSE's latest release. > > > > > > > > How about the Red Hat 7.1 RPMS? > > > > > > Try? They require glibc 2.2, but AFAIK the > newest SuSE release has this. > > > > Maybe the libs would pass OK, but (at least this > happend to me with 7.0.x) > > when trying to install the rpm on SuSE, it asks > for chkconfig, which the damn > > SuSE distro dosn't have. > > You can download and install that package too :) > > -- > Trond Eivind Glomsrød > Red Hat, Inc. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ ---(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
[GENERAL] date format and copy command
Using 6.5.3 on SuSE 6.4 and program kpgsql. Dumped data to a ';' delimited file wherein the date looks like '1997-12-27'. The date field may be null. Created the appropriate table using variously date/datetime/timestamp for data type, set datestyle to ISO/SQL/others. The copy command is copy tablename from '/usr/.../namefile.txt' using delimiters ';'; The pgsql response is 'bad date format'. Recommendations, please. Thanks, Bill Barnes
[GENERAL] kpgsql query executes but does not complete
Using 6.5.3 on SuSE 6.4 Create a new table works and the results box shows 'CREATE'. The next query, however, reports that a query is still in progress. Tried the new query button and simply erasing last query entered. Seems the only way to correct this is to disconnect. Upon reconnect I can select the new table. I have been able to execute 'select' and 'drop' queries in succession. Thanks for any clues. Bill Barnes
RE: [GENERAL] date format problem
Hello Anand: Thanks for the input. The problem turned out to be date fields with null values. Disappointing! A lot of my Sybase procedures tested for null dates. So my workaround was to edit the null dates to a pseudo date. This is least got my database poplulated. Will try the cast for queries and updates. I don't know which SQL, Postresql or Sybase, is an extension or non-compliant. Bill Barnes >= Original Message From "Anand Raman" <[EMAIL PROTECTED]> = >HI bill >Try to cast the field to the datetime type > >'ur_string_goes_here'::datetime > >Hope this will help >Anand Raman > >- Original Message - >From: Bill Barnes <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Friday, April 28, 2000 6:09 PM >Subject: [GENERAL] date format problem > > >> Hello List: >> >> Using 6.5.3 on SuSE 6.4. >> >> Built a table with a date field as type 'datetime'. >> >> I try to copy a text file to the table and get a 'bad date format' >> Dates in the text file may be null, but are in the form 1997-12-15. >> Have tried several of the date field types with the same result. >> The copy executes properly if I redefine the date field to varchar. >> >> Thanks for your help. >> Bill Barnes >> >> >> This e-mail has been sent to you courtesy of OperaMail, a >> free web-based service from Opera Software, makers of >> the award-winning Web Browser - http://www.operasoftware.com >> >> This e-mail has been sent to you courtesy of OperaMail, a free web-based service from Opera Software, makers of the award-winning Web Browser - http://www.operasoftware.com
[GENERAL] Creating tables with psql
Hello list; When I attemp another SQL command after doing a 'create table' the results box displays PQsendQuery() -- another query already in progress So far, the only way I have found around this is to close and restart psql. Other SQL commands can be executed in succession. What might I be missing? TIA Bill Barnes This e-mail has been sent to you courtesy of OperaMail, a free web-based service from Opera Software, makers of the award-winning Web Browser - http://www.operasoftware.com
RE: [GENERAL] Book completed except for chapters 18 and 20
KUDOS! Looked for a statement of release version. Presumably, it is 7.x current. >= Original Message From Lincoln Yeoh <[EMAIL PROTECTED]> = >Comments: >Make your book upgradeable? > >e.g. have a release that can be optionally ring bound. Then you can insert >updates downloaded and printed from the web (updates maybe available only >to registered users ;) ). [1] Agreed. This is a significant challenge, to the publisher and the reader, as anyone who has ever subscribed to a tax or like reference will attest, still the updateable areas would appear to have rather narrow scope and it's better than reprinting the whole book if the updates are not spelled out. Addison-Wesley is equipped for this. > >If it's upgradeable, then release sensitive material like >field,query,row,etc limits/limitations could be included. I believe info >like this would go a long way towards problem+pain avoidance. > >Cheerio! >Link. > Thanks for this great piece of work. Bill Barnes This e-mail has been sent to you courtesy of OperaMail, a free web-based service from Opera Software, makers of the award-winning Web Browser - http://www.operasoftware.com
[GENERAL] COPY fails to read source file
Hello all: Using 6.5.3, SuSE 6.4, logged in as 'billb'. Here are 2 instances of the COPY command; - copy custprofile from '/home/billb/custpr.txt' using delimiters ';'; The result is: ERROR: COPY command, running in backend with with effective uid 26, could not open '/home/billb/custpr.txt' for reading. Errno = Permission denied (13). The file looks like -rw-r--r-- 1 billb users 58902 May 16 11:45 /home/billb/custpr.txt copy custprofile from '/mnt/DOS_C/sybase/custpr.txt' using delimiters ';'; The result is: COPY The file looks like -rwxr-xr-x 1 rootroot 58902 May 16 11.56 /mnt/DOS_C/sybase/custpr.txt --- The second instance gave me the results I wanted, but why did the first instance fail? If anything, I would have expected permission denied on the root owner. I have had the same results on other ocassions. What am I missing? TIA Bill Barnes This e-mail has been sent to you courtesy of OperaMail, a free web-based service from Opera Software, makers of the award-winning Web Browser - http://www.operasoftware.com
