Hi Jason,
sounds a bit weird. Can you check which user the database files belong
to? A 'ls -lah /var/lib/pgsql' should do the job. Then switch from root
user to the postgresql user and try to start the cluster manually with
the command line from below (put from your message):
/usr/bin/postgres -D
Hi all,
> I would very much appreciate a copy or a link to these slides!
here they are:
http://www.scribd.com/mobile/doc/61186429
Have fun!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
Hi Mihai.
> We are now at the point where the csv files are all created and amount
> to some 300 GB of data.
> I would like to get some advice on the best deployment option.
First - and maybe best - advice: Do some testing on your own and plan
some time for this.
> First, the project has been s
On 23.03.2012 06:45, Gerhard Wiesinger wrote:
> With a database admin of a commercial database system I've discussed
> that they have to provide and they also achieve 2^31 transactions per
> SECOND!
> As PostgreSQL uses transaction IDs (XIDs) in the range of 2^31 they
> would turn around in about
Hi Dmytrii,
just as short idea, put "fsync = off" in your postgres.conf. That turns off
that after a commit data is forcilby written to disk - if the database crashes
there might be dataloss.
Von meinem iPhone gesendet
Am 23.02.2012 um 06:13 schrieb Dmytrii Nagirniak :
> Hi guys,
>
> I wonde
> eg, insert into logtable values ( 'vehicle123', now(),
> {{'voltage','13'},{'rpm','600'}};
>
> However, I am not sure how I can write a query - for example to read all
> records where the voltage field is less than 13. Performance in this case is
> not a real significant issue.
>
> Would I
> Can you please explain why? ( just curious, this seems a very strange
> requirement )
I'm on some research for election systems - an interesting field. On one
hand there is a requirement of realiablility, so there is the need for
stable and proven software and backups of systems for example. On
Hello Savio,
> top - 21:43:35 up 55 days, 8:07, 4 users, load average: 0.05,
> 0.25, 0.17 Tasks: 257 total, 1 running, 256 sleeping, 0 stopped,
> 0 zombie Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa,
> 0.0%hi, 0.0%si, 0.0%st Mem: 8165696k total, 7943160k used,
> 222536k free,
