Hi,
Finally I have found the problem: the table was corrupted, so i have
recreated it and it works fine.
I wonder if instead of recreating it i would have had to execute a vacuum.
Thanks to you all for your help and your suggestions (i will keep them for
the future).
Gabi :-)
Hi,
I need to define a very large db in a disk partition /data that is not the
default partition of Postgres.
The Chapter 10 of the admin guide describes a procedure that fails (postgres
6.5.3):
$ PGDATA2=/data
$ initlocation $PGDATA2
We are initializing the database area with username postgres (
On Wed, 22 Mar 2000, Stefano Bargioni wrote:
> $ PGDATA2=/data
> $ initlocation $PGDATA2
initlocation PGDATA2
> We are initializing the database area with username postgres (uid=40).
> This user will own all the files and must also own the server process.
> $ createdb -D $PGDATA2 ucc2
createdb
Peter Eisentraut wrote:
> On Wed, 22 Mar 2000, Stefano Bargioni wrote:
>
> > $ PGDATA2=/data
> > $ initlocation $PGDATA2
>
> initlocation PGDATA2
>
> > We are initializing the database area with username postgres (uid=40).
> > This user will own all the files and must also own the server process.
On Wed, 22 Mar 2000, Stefano Bargioni wrote:
> Dear Peter, thank you, the manual has an error: in the initlocation command,
> the $ must be deleted; but there is still a problem with createdb:
Yes, thank you.
> $ createdb -D PGDATA2 ucc2
> ERROR: Unable to locate path 'PGDATA2/ucc2'
>
Hi all,
Is it possible to get the mailinglistarchives back in sync on the
website or does majordomo2 something to prevent this?
And is there a special reason why the beta versions don't have the
current documentation in /doc ? I know, the source is there but you
have to have the right tools to m
On Wed, 22 Mar 2000, Henk van Lingen wrote:
> Hi all,
>
> Is it possible to get the mailinglistarchives back in sync on the
> website or does majordomo2 something to prevent this?
RSN ...
Does anyone see a problem with executing something similar to this on a
nightly basis (in a Cron job) to run vacuum on all databases?
--
#!/usr/bin/perl
while (<`ls -1 /usr/local/pgsql/data/base`>) {
`/usr/local/pgsql/bin/vacuumdb $_`;
}
---
On Tue, Mar 21, 2000 at 04:07:20PM -0800, Arthur M. Kang wrote:
> Was wondering if there was a way to use an aggregate value in a single
> select query to make a calculation within that query...
>
> Example:
> Table has column bool of type boolean with various random boolean
> values.
>
> Want t
Help, I'm drowining in eMail... anybody know how to set digest mode?
Thanks
Rob
Title: bulk copy in postgresql
Hi.
Can someone please tell me if there is a tool in postgres similar to BCP?
I need to populate some tables using data from some text files and don't know how to do it.
Thanks in advance,
Carlos Felipe Zirbes
11 matches
Mail list logo
