A new system came in with RH7.1 and PG7.0.3 installed (no data).
I want to upgrade to PG7.1.3 After reading README.rpm-dist, it is my
understanding that rpm -U postgresql713 followed by the db initialization is
enough.
The system locale is en_US; I will change it to C.
The question is: when the ne
Is anyone aware of FAQs or HowTos for using crypt type authentication and
storing encrypted passwords?
I am mainly interested in two things: 1) if passwords have to be stored in a
plain text file (pg_passwd), can they be stored encrypted? and 2) is it
possible to authenticate with an encrypted pa
Hi,
I am trying to install PostgreSQL on winNT platform.
These are the steps I performed:
1. Installed Cygwin.
2. Installed cygipc.
3. Now while running ./configure I am getting following error:
$ ./configure
loading cache ./c
On Fri, 19 Oct 2001, Brett W. McCoy wrote:
> Save all of your conf files, and probably pg_control & pgpasswd also. If
> you have data, you should also do a database dump so you can restore it.
OK. Makes sense.
> Take a look at the administrator's manual also. It has more details on
> what c
> On Fri, 19 Oct 2001, Brett W. McCoy wrote:
>
> > A good idea. I usually back up all of my databases (if required) and
> > configuration data before running an installation (I build PostgreSQL from
> > source only), then replace after I am done upgrading.
>
> Brett,
>
> Thanks. Other than p
Ooops.. didn't notice the LIMIT # OFFSET # part. IMHO the idea sounds
good and is definitely more readable.. and fair to both Mysql and
postgresql loyalists ;).
Postgres is backwards? Or did you mean you got the syntax backwards ?
;).
---(end of broadcast)
I'm not sure what version of postgres you are using but if you are use 7.1.?
you edit the postgresql.conf file. The file is in the same location as the
data. Just uncomment the "tcpip_socket=false" and change the "false" to
"true". I'm giving fair warning "I'm a newbie". But this is how I fixe
On Fri, 19 Oct 2001, Rich Shepard wrote:
> Thanks. Other than pg_hdb.conf, what files do I save?
Save all of your conf files, and probably pg_control & pgpasswd also. If
you have data, you should also do a database dump so you can restore it.
Take a look at the administrator's manual also.
"Tille, Andreas" <[EMAIL PROTECTED]> writes:
> psql: connectDBStart() -- connect() failed: No such file or directory
> Is the postmaster running locally
> and accepting connections on Unix socket '/var/run/postgresql/.s.PGSQL.5432'?
That's not the usual location for a PG socket fi
On Fri, 19 Oct 2001, Brett W. McCoy wrote:
> A good idea. I usually back up all of my databases (if required) and
> configuration data before running an installation (I build PostgreSQL from
> source only), then replace after I am done upgrading.
Brett,
Thanks. Other than pg_hdb.conf, what f
On Fri, 19 Oct 2001, Rich Shepard wrote:
> Should I move configuration files (such as pg_hba.conf) to a safe area,
> then manually delete all references to postgres that locate and find reveal,
> before starting from scratch?
A good idea. I usually back up all of my databases (if required) an
Brett
I am using Windows 2000 Server
-Mensagem original-
De: Brett W. McCoy [mailto:[EMAIL PROTECTED]]
Enviada em: sexta-feira, 19 de outubro de 2001 10:44
Para: Flávio Brito
Cc: [EMAIL PROTECTED]
Assunto: Re: [GENERAL] Backup Postgre Windows to Linux
On Fri, 19 Oct 2001, Flávio Brito
On Fri, 19 Oct 2001, Andy Hallam wrote:
> I am porting our applications from SQL SERVER, ORACLE and DB2 to PostgreSQL.
>
> I have just read that PostgreSQL does NOT support cross-database queries.
Nope, it doesn't. However, you can simulate this in your client
application by having two database
On Fri, 19 Oct 2001, Brett W. McCoy wrote:
> There should be! Are you sure you are using 7.1.3? It sounds like the
> data directory didn't get upgraded properly.
Brett,
I am no longer sure what's installed. When I look at
/var/lib/pgsql/data/base/PG_VERSION I see '7.1.2'. But, I ran 'rpm -U
On Fri, 19 Oct 2001, Flávio Brito wrote:
> I am using "pg_dumpall -h localhost -p 5432 > db.out"
> When I try it on Windows its turns my printer on and freeze
Ouch! What version of Windows are you using? I seem to recall that DOS &
Windows used to remap an interrupt (divide by zero? overflow
On Thu, 18 Oct 2001, Michael Coughlin wrote:
> The docs say to startup, using postmaster -i (Internet?) switch - for TCP/IP
> use. They don't elaborate on where to properly implement postmaster -i.
Have you read the administrator's manual? It gives tips on what to put
into start up scripts.
>
On Thu, 18 Oct 2001, Rich Shepard wrote:
> Just in case I mis-typed at the command line, I just tried the above. Same
> error: cannot find database system (in /var/lib/pgsql/data, where it is)
> and failed looking for /var/lib/pgsql/data/global/pg_control.
>
> The problem is that the file, pg
On Fri, 19 Oct 2001, Mark Muffett wrote:
> Is there a simple query to return the column names used in a table?
If you start up psql with the -E option, and then do \dt , it
will spit out the SQL used to retrieve the metadata on your table. You
can use that as your basis.
-- Brett
Is there a simple query to return the column names used in a table?
Thanks for any help.
Msark Muffett
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi Joel,
I am using "pg_dumpall -h localhost -p 5432 > db.out"
When I try it on Windows its turns my printer on and freeze
Em Qui 18 Out 2001 20:05, you wrote:
> On Thu, 18 Oct 2001, Andrew Gould wrote:
> > If all else fails, try to access the PostgreSQL
> > database from MS Access via ODBC.
On Fri, 12 Oct 2001, William Winter wrote:
> I'm Having a hard time with this statement:
>
> Select Jobs.*, ProjectedDates.* FROM Jobs, ProjectedDates WHERE (Plotted =
> False) And (JobName = 'Boulder Valley') AND (BuilderName = 'Elliott Homes')
> AND (Jobs.JobID = ProjectedDates.JobID)
>
> Ca
Without providing the error message returned, we can only guess. One likely
issue is "Plotted = False", because all values must be quoted except
numbers. Better to use Plotted = 'f'.
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
> From: "William Winter" <[EMAIL PRO
Hello,
I compiled the snapshot from 16. Oct on Sparc Linux. Make and make
install worked perfectly and I was able to start the postmaster as
described in INSTALL. But:
postgres:~$ ps ax | grep post
8575 ttyp4S 0:00 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
8576 ttyp4
23 matches
Mail list logo
