Re: [ADMIN] Multiple users, same DB

2000-09-12 Thread John McKown
On Tue, 12 Sep 2000, Jeremy Buchmann wrote: > Does anyone know how to create a postgresql user that can read/write to an > existing database? I have used createuser, but it never asks if I want the > new user to have access to an existing DB. When I connect to a DB with that > new user, I can't

[ADMIN] PLSQL

2000-09-12 Thread Paulo Roberto Siqueira
Where can I find a tutorial on PL/SQL for postgres? Is there any documentation focused on it on postgres' site? Thank you

[ADMIN] Multiple users, same DB

2000-09-12 Thread Jeremy Buchmann
Does anyone know how to create a postgresql user that can read/write to an existing database? I have used createuser, but it never asks if I want the new user to have access to an existing DB. When I connect to a DB with that new user, I can't read or write from any of the tables. Any suggestio

Re: [ADMIN] same postmaster, different directory? V7.0.2

2000-09-12 Thread Jeremy Buchmann
Which FM did you read? There are several, but the Admin Guide talks about disk management in chapter 10. I put my databases in /home with postmaster running like this: /usr/local/pgsql/bin/postmaster -D /home/post/data -i -- Jeremy Buchmann System Admin/Database Programmer Wells Gaming Research

Re: [ADMIN] gzip, gcc, gmake utilities to install POSTGRES on solaris ???

2000-09-12 Thread Christopher R. Jones
gzip is in two formats, the first is not zipped, it is a valid Solaris package. Download it to your Solaris and use ppkgadd -d gzip-1.2.4a-sol7-intel-local #(or sparc if you are using sparc) Read the man pages on ppkgadd. Once gzip is installed, then you down load the other packages, unzip t

Re: [ADMIN] gzip, gcc, gmake utilities to install POSTGRES on solaris ???

2000-09-12 Thread Dana Hudes
As I said privately before, sunfreeware is only one place. sunsite.unc.edu is somewhat more comprehensive. download the binaries as packages, pkgadd and go . there is a suitable version of gzip , possibly as a .pkg.Z but you have compress. As to process, I don't think it fair to ask the list for

Re: [ADMIN] gzip, gcc, gmake utilities to install POSTGRES on solaris ???

2000-09-12 Thread Andrew Perrin - Demography
http://www.sunfreeware.com/faq.html#q0 gives details on getting gzip onto your system. There are also copious instructions on how to install everything. - Andrew J. Perrin - [EMAIL PROTECTED] - NT/Unix Admin/Support Department of

Re: [ADMIN] gzip, gcc, gmake utilities to install POSTGRES on solaris ???

2000-09-12 Thread Dronamraju Rajesh
Hi, Thanks for the reply. But I have some doubts. they are the following:- 1.) At sunfreeware.com there are two gcc files in gz format. There is a make utility also but is it the gmake what postgres uses. 2.) Even the gzip is in gz format. Now how do I unzip it and once I start installing t

[ADMIN] data modeler

2000-09-12 Thread Chris Ryan
Does anyone know of a good data modeler preferably for linux that works with PostgreSQL? Chris Ryan

[ADMIN] gzip, gcc, gmake utilities to install POSTGRES on solaris ???

2000-09-12 Thread Dronamraju Rajesh
Hello everyone, I am need to install postgres ver 7 database on solaris 7. can anybody pl suggest me where do i get these modules. Pl don't suggest me that it is from sunfreeware.com because i did not get these from there. I'll just put the utilities in order i need. kindly suggest where do