How do I find the date when a table was created or last modified?
hal
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
In postgresql-7.2.1 the Perl Pg interface was found in
src/interfaces/perl5.
In postgresql--7.3 there is no src/interfaces/perl5.
What gives? I have something like 100+ perl scripts which use the Pg
interface so as you can imagine I am disappointed!?
Anybody have a clue what happened?
hal
--
On Wednesday, July 10, 2002, at 08:54 AM, Kevin Brannen wrote:
Stuff deleted
> The order I would propose would be: env-var, command-line, STDIN,
> interactive prompt if we have a tty. Reorder as you see fit.
To the above list I would add a .psql (or something) file in
the home dir of the pe
Can someone give me a clue as to where I find
docs, howto, etc on how to talk to the postgresql backend
through port 5432?
hal
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
I have postgres set up to require usernames and passwords for access.
The following script works just fine in 7.1.2 without manual
intervention. Using 7.2.1 psql issues a password prompt and
blocks until a password is manually entered.
###
#!/bin/sh
psql myd
On Wednesday, May 1, 2002, at 04:09 PM, Jean-Michel POURE wrote:
> Did you restart PostgreSQL service to reload pg_hba.conf?
> "service postgresql restart"
Of course not?! :^}
Thanks, worked like a charm.
hal, the simple.
---(end of broadcast)-
I want to require users to authenticate themselves by entering
a username and/or password when:
using the psql command
connecting to a database using the perl interface module.
I am doing this on my 7.1.2 system.
I am trying to do this on my 7.2.1 system.
I have used creatuser
Is there a table or tables that contains the creation date/time
of data bases and tables?
hal
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
m
I want to use the ODBC interface to Postgres so I can query my database
from a win2k machine using Micro $oft access. What driver should I
use on the Win2k machine?
hal
I want to use the ODBC interface to Postgres so I can query my database
from a win2k
machine using Micro $oft access. What driver should I use on the Win2k machine?
hal
I want to use the ODBC interface to Postgres so I can query my database
from a win2k
machine using Micro $oft access. What driver should I use on the Win2k machine?
hal
>I'm trying to start the postmaster exactly how it is written in the
>installation instructions:
>nohup postmaster -i > pgserver.log 2>&1 &
>However, RedHat Linux 6.1 gives me an 'Ambiguous output redirect '
>error. This is probably because I'm using TCSH instead of BASH.
>Is there a way that I
Got a bit of a problem here?!
I just upgraded to Postgres-7.0
I am getting the error shown below consistantly, not always in
the same place in the database build script.
When I installed 7.0 I did not migrate my data. Instead I chose
to rebuild all databases (6) and all tables (> 40) from scratch
Got a bit of a problem here?!
I just upgraded to Postgres-7.0
I am getting the error shown below consistantly, not always in
the same place in the database build script.
When I installed 7.0 I did not migrate my data. Instead I chose
to rebuild all databases (6) and all tables (> 40) from scratch
>I want to get your opinions on production-quality backup software for
>FreeBSD 3.4. Basically, I need good backup software to back up only one
>mission-critical FreeBSD server with the possibility of expanding the backup
>to include more FreeBSD servers in the future. What software do you use o
I have both a production machine and a test machine.
The production machine is running 6.5.2 and FreeBSD 3.0.
The test machine is running 6.5.3 and FreeBSD 3.4.
The idea is to migrate all databases from the prod. machine
to the test machine. As soon as the test machine works properly
it will bec
I am running postgresql 6.5.2 on FreeBSD. I am developing a data warehouse
here at Utah State University. A quick look at the docs leaves the following
questions:
1. what is the maximum size for a database?
2. what is the maximum size for a table?
3. what is the maximum size for a row?
4. What
> First off RAM helps a LOT. 192MB RAM is not much. Look at "top"
>and keep adding it until the cache and buffer sizes are quite large.
>I would think 512MB or 1GB of RAM is what you need. The idea is
>to let the OS (Linux) cache a good partion of your database in
>RAM. Postgres has a buffer
>
>Logging classes:
>---
>1xz - The PostgreSQL server
>2xx - User-related information
>3xx - Transaction information
>4xx - EXPLAIN results (???)
>9xx - General system alerts
>1000-1999 debugging events
Is it possible that someday there will be a need for more than 99 "items"
in log c
>under psql you can get help for SQL statement grant.
>
>grant rule on table to someone
>
>menas you grant someone on the table previlige: RULE.
>
>RULE has special meaning. Other previliges you can grant are:
>select, delete, update
>
>--Banghe
Ahhh! Just what is the special meaning of RULE?
E
In the following grant statement what does rule mean? The manual page
was no help?!
grant rule on table to someone;
hal
>I'm running a pretty stock 3.0 here, and have not had any problems. You
>need to show us what sort of errors you are seeing, though, since right
>now, all we have to work with is "it doesn't work" :(
>
>What does initdb show when you run it, start to finish?
>
First let me apologize for the len
A suggestion was made to see if initdb worked ok.
Just to make sure I removed the appropriate directory and re-ran it:
no change. The regression test still fails miserably.
I believe the problem is with the way my system software is configured.
This is a new machine with a fresh install of Free
I trying to install postgresql-6.4.2 on an Intel FreeBSD 3.0 box.
The compile seems to work well. I got:
All of PostgreSQL is successfully made. Ready to install.
The install worked, I think?! I got:
Thank you for choosing PostgreSQL, the most advanced ... engine.
instead of:
>The table contains 22+ million records which are formatted so they
>can be loaded using the psql copy command.
Well I solved the problem. It turns out that I had a programmer (me)
malfunction. My 22+ million record data had every other record
containing only a single character, a newline. My
I have a tabel I am trying to use but it won't work. Here are the
particulars:
Digital Unix 4.0E
Postgres 6.3
DEC 3000 400s
100M+ memory
500M swap
8 gig drive reserved for postgres
To create the table:
#!/bin/sh
psql sis << \__EOD__
drop table trnscpt;
create table trnscpt (
SSN
26 matches
Mail list logo
