Dear all,
I am trying to configure a pentium II 128 Megs of memory and 8 gigabytes of
hard disk a Linux server for storing a database using PostgreSQL and also an
Apache Server ( I will use www_sql to access the database through the web).
I am trying to install the postgreSQL server using the
Hello you out there,
I'm having some strange problem with a server postgresql 7.4.3, some times
the server crashes and restarts inmediatly, heres is the error message
catch from the log file
ERROR: cache lookup failed for namespace 105183855
LOG: server process (PID 3942) exited with exit code
[EMAIL PROTECTED] writes:
> I'm having some strange problem with a server postgresql 7.4.3, some times
> the server crashes and restarts inmediatly, heres is the error message
> catch from the log file
> ERROR: cache lookup failed for namespace 105183855
> LOG: server process (PID 3942) exited w
Hi,
Thanks a lot to all of you for your help, after long nigths looking at the
log files for a possible cause, we find out that this error condition
refered to some kind of problem with the SCSI array controller (hardware)
that was not reported by the watchdog program installed by the hardware
pro
Hello Sir,
During the installation of "Postgresql Database Server" when I am
tring execute the command "/usr/local/pgsql/bin/postgres -D
/usr/local/pgsql/data" it shows an error message:
LOG: could not translate host name "localhost", service "5432" to
address: Name or service
On 9/18/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hello Sir,
> During the installation of "Postgresql Database Server" when I am
> tring execute the command "/usr/local/pgsql/bin/postgres -D
> /usr/local/pgsql/data" it shows an error message:
> LOG: could not translate
On 9/18/07, Ankur <[EMAIL PROTECTED]> wrote:
> Sir,
> Thanks for your reply. I am giving you the necessary information. I am
> using Red Hat Enterprise Linux AS (Version 3 Update 9). Postgresql version
> is 8.2.4. When I am initializing the database server by executing the
> command "$ /usr/l
Dear Friends,
For client requirements, I am testing postgresql 9.0.4 on windows 7 with
plpython. First I installed python 2.7 and then added python installation
path to windows PATH variable. Then installed postgresql from one-click
installer. Server started and every thing was ok. Then I go to cre
On Mon, Nov 19, 2012 at 2:51 PM, Prabir Maity wrote:
> Dear Respected Sir,
>
> Now I'm using postgresql 9.1 version , at first it is work very fine. Now
> it occurs some problem.
> 1. When open pgAdminIII and double click on Server then a error show ,
> which I sending a print screen.
> 2. When
On 9/08/2011 10:54 PM, c k wrote:
Normal python functions returning text etc. are working but when conatining
import sys
from uuid import getnode as get_mac
mac = get_mac()
return mac
fails. What will be the reason?
You still haven't supplied the error message you get when you run this.
In
I didn't get any error message. When calling the function from PGAdmin I get
error**.
When I try to re-execute it, it says 'no connection to the server'. When
checked the logs I found
2011-08-09 19:46:00 IST LOG: database system was interrupted; last known up
at 2011-08-09 19:45:1
On Wed, Aug 10, 2011 at 1:23 AM, c k wrote:
> When I try to re-execute it, it says 'no connection to the server'. When
> checked the logs I found
>
> 2011-08-09 19:46:00 IST LOG: database system was interrupted; last known up
> at 2011-08-09 19:45:17 IST
> 2011-08-09 19:46:00 IST LOG: database s
System info: Lancelot 1874-T dual Intel Xeon(Nehalem-DP) SATAII 24GB
RAM, CentOS release 5.4 (Final), postgresql-server-8.4.4-1PGDG
hi,
We installed a fresh version of postgresql-server-8.4.4-1 using RPMs
from PGDG. We are seeing the following errors, if the system trys to do
'anything' sort
On Mon, Jul 26, 2010 at 16:01, Irene Barg wrote:
>> 2010-07-26 11:33:33 MST system_admin metadataERROR: could not write block
>> 503414 of temporary file: No space le
>> ft on device
>> 2010-07-26 11:33:33 MST system_admin metadataHINT: Perhaps out of disk
>> space?
>> -bash-3.2$ df -h
>> Files
Alex Hunsaker writes:
> On Mon, Jul 26, 2010 at 16:01, Irene Barg wrote:
> 2010-07-26 11:33:33 MST system_admin metadataERROR: Â could not write block
> 503414 of temporary file: No space le
> ft on device
> 2010-07-26 11:33:33 MST system_admin metadataHINT: Â Perhaps out of disk
> space?
> Ok s
Alex,
It's funny how one cannot see what is right in front of them. I did NOT
notice that 'var' was mounted as '/var/log', so postgres was getting
installed in root '/'. So I moved pgsql to /data1, and created a symlink
in /var/lib/pgsql to /data1/pgsql.
Now I have a pgsql_tmp file that has
On Tue, Jul 27, 2010 at 15:58, Irene Barg wrote:
> I'm afraid I don't understand how turning on 'log_temp_files' will help?
Well, postgres is probably doing exactly what its told. You just need
to figure out what that is and why. ( and if it is some kind of bug,
we wont be able to do anything ab
Alex,
Thanks for the explanation. That helps.
After looking at some of the pgsql_tmp files, It was clear we needed to
increase work_mem. So I switched back to the pgtune suggestions with one
change:
-bash-3.2$ diff postgresql.conf postgresql.conf.local | grep "< "
< log_temp_files = 0
On Wed, Jul 28, 2010 at 15:43, Irene Barg wrote:
> Alex,
> The postmaster wouldn't start with shared_buffers = 5632MB, so we reduced it
> to 2GB. The system's shared memory is:
>
>> [dpp...@pipen18 ~]$ sudo /sbin/sysctl -a | grep kernel | grep shmmax
>> kernel.shmmax = 4182863872
You can bump tha
19 matches
Mail list logo