Johnny C wrote:
I have the following tables:
TABLE A
month | year | item | num
1 2005 myitem 003
TABLE B
num| date | descr
003 02-01-2005 blahblah
003 01-01-2005 toratora
I am trying to come up with
Joel Fradkin wrote:
I am trying to use a different drive for the data.
I have edited postgres.conf to point to the new location, but I get the
error /pgdata/PG_VERSION is missing.
Do I have to do a initdb?
When I try an initdb it says it is not empty. (has lost and found folder in
it).
Create a sub
Hi,
yes that's my problem.
I've got a table and I put lots of contraints on it so that data stays
consistent. One constraint calls a fcn to do some kind of count() over that
table but it omits the 'to be inserted record'. What to do?
concrete problem:
Suppose a table
i | tel | status | ...
..|
Thank you for all the help.
I was able to get system up (8.0 RPMS, not a build of 8.0.1)
I installed to the normal /var/lib/pgsql/data directory.
I did an initdb on the pgdata drive initdb /pgdata/data
This created a data folder on that drive set.
I used the instructions below for linking my wal
