Re: [GENERAL] Server SSL key with passphrase

dhanuj hippie wrote: I have a postgres-9.6 server running with SSL enabled, and I have setup the certificates as per documentation. But currently the key file is not protected by passphrase. Does postgres provide a way to use passphrase protected keys ? If by "per documentation" you refer t

[GENERAL] Server SSL key with passphrase

Hi, I have a postgres-9.6 server running with SSL enabled, and I have setup the certificates as per documentation. But currently the key file is not protected by passphrase. Does postgres provide a way to use passphrase protected keys ? Thanks Dhanuj

Re: [GENERAL] Server crashed, now cannot start postgres [FIXED]

On Mon, 12 Sep 2016, Tom Lane wrote: Hmm, AFAIK that's what it should be out of the box. Certainly on my RHEL6 machine I see Until I make the time to upgrade this host from Slackware-14.1 to -14.2 the kernel is 3.10.17-smp. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgr

Re: [GENERAL] Server crashed, now cannot start postgres [FIXED]

Rich Shepard writes: >Yes, it's a linux box. And /dev/shm/ does have incorrect permissions > (755). Thanks to your response I remembered that chromium does not run until > I follow its advice to chmod 1777 /dev/shm. Sure enough, chromium would not > load. >So, I changed the perms on /dev/s

Re: [GENERAL] Server crashed, now cannot start postgres [FIXED]

On Mon, 12 Sep 2016, Tom Lane wrote: A look at the code suggests this is shm_open() returning EACCES. Not sure why that's happening. If this is a Linux box, maybe the permissions on /dev/shm are bollixed? Tom, Yes, it's a linux box. And /dev/shm/ does have incorrect permissions (755). Thank

Re: [GENERAL] Server crashed, now cannot start postgres

Rich Shepard writes: >Tried to compile 3 large programs at one time and the CPU overheated, > shutting down the server. Now when I try to start postgres-9.5.4 (as the > superuser, postgres) I get this result: > postgres@salmo:~$ postgres -D /var/lib/pgsql/9.5/data/ & > [1] 14544 > postgres@sa

[GENERAL] Server crashed, now cannot start postgres

Tried to compile 3 large programs at one time and the CPU overheated, shutting down the server. Now when I try to start postgres-9.5.4 (as the superuser, postgres) I get this result: postgres@salmo:~$ postgres -D /var/lib/pgsql/9.5/data/ & [1] 14544 postgres@salmo:~$ FATAL: could not open shar

Re: [GENERAL] Server side backend permanent session memory usage ?

-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Wednesday, July 27, 2016 4:50 PM To: Day, David Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Server side backend permanent session memory usage ? "Day, David" writes: > We have a server

Re: [GENERAL] Server side backend permanent session memory usage ?

"Day, David" writes: > We have a server side function written in plpgsql called by the client side > application. That fx does work that includes > Invoking a server side plpython2u function. > If I repeat calling this severer side logic/function outside our app from a > a psql invoked connecti

Re: [GENERAL] Server side backend permanent session memory usage ?

14, 2016 11:22 AM To: Day, David Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Server side backend permanent session memory usage ? "Day, David" writes: > There seems to be an unbounded growth of memory usage by the backend > postgres process representing a "permanent&

Re: [GENERAL] Server side backend permanent session memory usage ?

"Day, David" writes: > There seems to be an unbounded growth of memory usage by the backend > postgres process representing a "permanent" session in our system. It's hard to evaluate this report with so little information, but there are at least three possible explanations: 1. Many people misu

[GENERAL] Server side backend permanent session memory usage ?

Hi, There seems to be an unbounded growth of memory usage by the backend postgres process representing a "permanent" session in our system. The size/res values retrieved by running the "top" utility seem to exceed the amount I would expect given the mem and buf tuning parameters of the pos

Re: [GENERAL] Server-side hooks for user session start and session end

Hi, 27.09.2015 23:22, Pavel Stehule wrote: [...] updated patch - fixed error reporting Wow! I'll definitely borrow it :) Thank you, Nikolai Regards Pavel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org ) To make c

Re: [GENERAL] Server-side hooks for user session start and session end

2015-09-27 22:51 GMT+02:00 Nikolai Zhubr : > Hi, > 27.09.2015 22:59, Pavel Stehule: > >> >> 2015-09-27 21:40 GMT+02:00 Jim Nasby > >: >> >> _PG_fini >> >> >> It should not work - see a doc >> > > I'd rather consider registering with on_shmem_exit -- as per the

Re: [GENERAL] Server-side hooks for user session start and session end

Hi I stored this extension to github https://github.com/okbob/session_exec Regards Pavel

Re: [GENERAL] Server-side hooks for user session start and session end

Hi, 27.09.2015 22:59, Pavel Stehule: 2015-09-27 21:40 GMT+02:00 Jim Nasby mailto:jim.na...@bluetreble.com>>: _PG_fini It should not work - see a doc I'd rather consider registering with on_shmem_exit -- as per the insightfull note placed in postgresql.c:4290. (Haven't tried - just thi

Re: [GENERAL] Server-side hooks for user session start and session end

2015-09-27 13:33 GMT+02:00 Nikolai Zhubr : > Hi, > 27.09.2015 8:29, Pavel Stehule: > >> I'll check it. >> >> >> It is working. Patch attached >> > > Oh, brilliant! This is a _huge_ help actually! > > If I understand it correctly, any unhandled SQL-level exceptions will > essentially be ignored

Re: [GENERAL] Server-side hooks for user session start and session end

2015-09-27 21:40 GMT+02:00 Jim Nasby : > _PG_fini It should not work - see a doc If the file includes a function named _PG_fini, that function will be called immediately before unloading the file. Likewise, the function receives no parameters and should return void. Note that _PG_fini will only

Re: [GENERAL] Server-side hooks for user session start and session end

On 9/26/15 7:12 PM, Nikolai Zhubr wrote: 26.09.2015 20:59, Tom Lane wrote: [...] A session-end hook seems pretty problematic to me: you simply cannot guarantee that it will run at all. (Consider process crash or server abort cases.) So anything built on the assumption that it gets to run at se

Re: [GENERAL] Server-side hooks for user session start and session end

2015-09-27 13:33 GMT+02:00 Nikolai Zhubr : > Hi, > 27.09.2015 8:29, Pavel Stehule: > >> I'll check it. >> >> >> It is working. Patch attached >> > > Oh, brilliant! This is a _huge_ help actually! > > If I understand it correctly, any unhandled SQL-level exceptions will > essentially be ignored

Re: [GENERAL] Server-side hooks for user session start and session end

Hi, 27.09.2015 8:29, Pavel Stehule: I'll check it. It is working. Patch attached Oh, brilliant! This is a _huge_ help actually! If I understand it correctly, any unhandled SQL-level exceptions will essentially be ignored there, so that the session will continue regardless? And maybe i

Re: [GENERAL] Server-side hooks for user session start and session end

> >> > years ago I tried it, if I remember well. I had a problems with SPI >> calls, >> > because some caches was not initialized. I am not sure, and I didn't >> test >> > last time. >> >> You'd have to start your own transaction if you wanted one, and any >> uncaught error would effectively be FAT

Re: [GENERAL] Server-side hooks for user session start and session end

26.09.2015 20:59, Tom Lane wrote: [...] A session-end hook seems pretty problematic to me: you simply cannot guarantee that it will run at all. (Consider process crash or server abort cases.) So anything built on the assumption that it gets to run at session end is going to be inherently unreli

Re: [GENERAL] Server-side hooks for user session start and session end

On Saturday, September 26, 2015, Tom Lane wrote: > Pavel Stehule > writes: > > 2015-09-26 19:53 GMT+02:00 Nikolai Zhubr >: > >> And the events of session start and session end would seem quite generic > >> and usefull anyway? > > > I don't know. I am pretty sceptical - from my experience this re

Re: [GENERAL] Server-side hooks for user session start and session end

2015-09-26 20:29 GMT+02:00 Tom Lane : > Pavel Stehule writes: > > 2015-09-26 19:59 GMT+02:00 Tom Lane : > >> A session-start hook is already possible at the C-code level, using > >> session_preload_libraries. It wouldn't be hard to write an extension > >> that exposed that in some useful way to

Re: [GENERAL] Server-side hooks for user session start and session end

Pavel Stehule writes: > 2015-09-26 19:59 GMT+02:00 Tom Lane : >> A session-start hook is already possible at the C-code level, using >> session_preload_libraries. It wouldn't be hard to write an extension >> that exposed that in some useful way to SQL code. > years ago I tried it, if I remember

Re: [GENERAL] Server-side hooks for user session start and session end

2015-09-26 19:59 GMT+02:00 Tom Lane : > Pavel Stehule writes: > > 2015-09-26 19:53 GMT+02:00 Nikolai Zhubr : > >> And the events of session start and session end would seem quite generic > >> and usefull anyway? > > > I don't know. I am pretty sceptical - from my experience this request was > > r

Re: [GENERAL] Server-side hooks for user session start and session end

Pavel Stehule writes: > 2015-09-26 19:53 GMT+02:00 Nikolai Zhubr : >> And the events of session start and session end would seem quite generic >> and usefull anyway? > I don't know. I am pretty sceptical - from my experience this request was > related to unhappy designed projects. A session-end

Re: [GENERAL] Server-side hooks for user session start and session end

2015-09-26 19:53 GMT+02:00 Nikolai Zhubr : > Hi Pavel, > 26.09.2015 19:26, Pavel Stehule wrote: > [...] > >> This cannot be solved without patching PostgreSQL source code :( . There >> are not good hooks for custom extension. Patch is relative simple, but I >> cannot to publish it. >> > > Ok, I se

Re: [GENERAL] Server-side hooks for user session start and session end

Hi Pavel, 26.09.2015 19:26, Pavel Stehule wrote: [...] This cannot be solved without patching PostgreSQL source code :( . There are not good hooks for custom extension. Patch is relative simple, but I cannot to publish it. Ok, I see. Creating such a patch might be not very hard actually. But li

Re: [GENERAL] Server-side hooks for user session start and session end

2015-09-26 18:17 GMT+02:00 Nikolai Zhubr : > Hi all, > > I'm trying to find a soultion to automatically execute something > (preferrably a function or at least some pure sql statements) at the > beginning and at the end of a user session. As an example, imagine just > storing of all login and logo

[GENERAL] Server-side hooks for user session start and session end

Hi all, I'm trying to find a soultion to automatically execute something (preferrably a function or at least some pure sql statements) at the beginning and at the end of a user session. As an example, imagine just storing of all login and logout timestamps (though the real task is a bit more

Re: [GENERAL] Server tries to read a different config file than it is supposed to

Adrian Klaver writes: > On 05/23/2015 08:06 AM, Tom Lane wrote: >> I can't explain that claim, but for me, -c config_file=something >> seems to work as you'd expect, and a look at the server source >> code confirms that it should honor that (cf SelectConfigFiles()). >> I think the documentation Ad

Re: [GENERAL] Server tries to read a different config file than it is supposed to

On 05/23/2015 08:06 AM, Tom Lane wrote: twoflower writes: So I wrote a few scripts to make my life easier, e.g. *pg94start.sh*: su postgres -c "/usr/lib/postgresql/9.4/bin/pg_ctl -D /storage/postgresql/9.4/data -o '-c config_file=/etc/postgresql/9.4/main/postgresql.conf'" But running this scrip

Re: [GENERAL] Server tries to read a different config file than it is supposed to

twoflower writes: > So I wrote a few scripts to make my life easier, e.g. *pg94start.sh*: > su postgres -c "/usr/lib/postgresql/9.4/bin/pg_ctl -D > /storage/postgresql/9.4/data -o '-c > config_file=/etc/postgresql/9.4/main/postgresql.conf'" > But running this script did not work, the server would

Re: [GENERAL] Server tries to read a different config file than it is supposed to

On 05/23/2015 07:01 AM, rob stone wrote: On Sat, 2015-05-23 at 04:23 -0700, twoflower wrote: I thought I understood how specifying a config file path for the server works, but that's apparently not the case. The cluster data is at /storage/postgresql/9.4/data. The config files are at /etc/p

Re: [GENERAL] Server tries to read a different config file than it is supposed to

On 05/23/2015 04:23 AM, twoflower wrote: I thought I understood how specifying a config file path for the server works, but that's apparently not the case. The cluster data is at */storage/postgresql/9.4/data*. The config files are at */etc/postgresql/9.4/main* (this is the default location on

Re: [GENERAL] Server tries to read a different config file than it is supposed to

On Sat, 2015-05-23 at 04:23 -0700, twoflower wrote: > I thought I understood how specifying a config file path for the > server works, but that's apparently not the case. > > The cluster data is at /storage/postgresql/9.4/data. > > The config files are at /etc/postgresql/9.4/main (this is the

[GENERAL] Server tries to read a different config file than it is supposed to

I thought I understood how specifying a config file path for the server works, but that's apparently not the case. The cluster data is at */storage/postgresql/9.4/data*. The config files are at */etc/postgresql/9.4/main* (this is the default location on Ubuntu). This is how the beginning of */etc/p

Re: [GENERAL] Server statistics monitoring?

On 1/29/2015 2:12 PM, Israel Brewster wrote: I'm working on setting up a new PostgreSQL database server, and would like to be able to monitor a number of statistics on it, such as: number of connections number of queries query times etc. All these stats are easily available, either from the p

Re: [GENERAL] Server statistics monitoring?

On Jan 29, 2015, at 1:20 PM, Michael Heaney wrote: > On 1/29/2015 5:12 PM, Israel Brewster wrote: >> I'm working on setting up a new PostgreSQL database server, and would like >> to be able to monitor a number of statistics on it, such as: >> >> number of connections >> number of queries >> que

Re: [GENERAL] Server statistics monitoring?

On 1/29/2015 5:12 PM, Israel Brewster wrote: I'm working on setting up a new PostgreSQL database server, and would like to be able to monitor a number of statistics on it, such as: number of connections number of queries query times etc. All these stats are easily available, either from the p

[GENERAL] Server statistics monitoring?

I'm working on setting up a new PostgreSQL database server, and would like to be able to monitor a number of statistics on it, such as:number of connectionsnumber of queriesquery timesetc.All these stats are easily available, either from the pg_stat_statements view (which I have enabled) and the li

Re: [GENERAL] Server process crash - Segmentation fault

Hello Tom, Adrian Thank you for your help and the patch. Things works nicely for me now :-). Leif - Original Message - > Adrian Klaver writes: > > On 05/08/2014 07:19 AM, Tom Lane wrote: > >> 9.3 patch is here: > >> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff

Re: [GENERAL] Server process crash - Segmentation fault

On 05/08/2014 07:43 AM, Tom Lane wrote: Adrian Klaver writes: On 05/08/2014 07:19 AM, Tom Lane wrote: 9.3 patch is here: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fc58c39d468587467c7c55b349c28167794eadaf Alright, so I obviously linked to the wrong patch because I poi

Re: [GENERAL] Server process crash - Segmentation fault

Adrian Klaver writes: > On 05/08/2014 07:19 AM, Tom Lane wrote: >> 9.3 patch is here: >> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fc58c39d468587467c7c55b349c28167794eadaf > Alright, so I obviously linked to the wrong patch because I pointed at > HEAD and not REL9_3_STABL

Re: [GENERAL] Server process crash - Segmentation fault

On 05/08/2014 07:19 AM, Tom Lane wrote: Leif Jensen writes: I already compiled postgreSQL myself and now using 9.3.4, so I would very much like a patch. Where can I find that ? 9.3 patch is here: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fc58c39d468587467c7c55b349

Re: [GENERAL] Server process crash - Segmentation fault

On 05/08/2014 06:59 AM, Leif Jensen wrote: Hi Tom, I already compiled postgreSQL myself and now using 9.3.4, so I would very much like a patch. Where can I find that ? http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=04e5025be8bbe572e12b19c4ba9e2a8360b8ffe5 Leif --

Re: [GENERAL] Server process crash - Segmentation fault

Leif Jensen writes: >I already compiled postgreSQL myself and now using 9.3.4, so I would very > much like a patch. Where can I find that ? 9.3 patch is here: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fc58c39d468587467c7c55b349c28167794eadaf r

Re: [GENERAL] Server process crash - Segmentation fault

Hi Tom, I already compiled postgreSQL myself and now using 9.3.4, so I would very much like a patch. Where can I find that ? Leif - Original Message - > Leif Jensen writes: > >Could it be related to the OFFSET part of the statement ? I have > >another query on the same

Re: [GENERAL] Server process crash - Segmentation fault

Leif Jensen writes: >Could it be related to the OFFSET part of the statement ? I have another > query on the same table without OFFSET, which seems to work fine. Yeah, the specific code path here involves executing a stable (or possibly immutable) SQL function in a LIMIT or OFFSET clause. I

Re: [GENERAL] Server process crash - Segmentation fault

Could it be related to the OFFSET part of the statement ? I have another query on the same table without OFFSET, which seems to work fine. Leif - Original Message - > Leif Jensen writes: > >Here is a gdb dump of the backtrace at the server process crash. > >I have also incl

Re: [GENERAL] Server process crash - Segmentation fault

Leif Jensen writes: >Here is a gdb dump of the backtrace at the server process crash. I have > also included the code that generates these calls. As mentioned below this > specific connection has been used many times before the crash. Also, we are > aware of the thread caveat that only usin

Re: [GENERAL] Server process crash - Segmentation fault

Leif Jensen writes: >Thank you for your answer. I can post part of the code that makes these > calls, but I'm not sure how much it would help. It is rather large function > that makes these calls, and it is called all over the program. The part of > the log posted is only a small excerpt of

Re: [GENERAL] Server process crash - Segmentation fault

On 05/06/2014 11:37 PM, Leif Jensen wrote: Hello Adrian, Thank you for your answer. I can post part of the code that makes these calls, but I'm not sure how much it would help. It is rather large function that makes these calls, and it is called all over the program. The part of the l

Re: [GENERAL] Server process crash - Segmentation fault

Hello Adrian, Thank you for your answer. I can post part of the code that makes these calls, but I'm not sure how much it would help. It is rather large function that makes these calls, and it is called all over the program. The part of the log posted is only a small excerpt of the use of

Re: [GENERAL] Server process crash - Segmentation fault

On 05/06/2014 07:08 AM, Leif Jensen wrote: Hello. I was running PostgreSQL 9.1.4 when I got a server process crash (Segmentation fault) as the postgres log shown below. I tried upgrade to newest version 9.3.4, but this gives exactly the same problem. It is an (ecpg based) C-progra

[GENERAL] Server process crash - Segmentation fault

Hello. I was running PostgreSQL 9.1.4 when I got a server process crash (Segmentation fault) as the postgres log shown below. I tried upgrade to newest version 9.3.4, but this gives exactly the same problem. It is an (ecpg based) C-program that does tons of these scroll cursor exercis

Re: [GENERAL] Server continuously enters to recovery mode.

Hi everybody Thank you for your help! I upgrade the version of 9.0.15 to 9.0.17. But after that constantly show this error, in all sessions: *WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll ba

Re: [GENERAL] Server continuously enters to recovery mode.

On 05/03/2014 04:29 PM, DrakoRod wrote: Hi everybody! I have a problem (really huge problem), I have one server of production, but yesterday in the night I saw this error: *ERROR: could not access status of transaction 2410303155 DETAIL: Could not open file "pg_clog/08FA": No such fil

Re: [GENERAL] Server continuously enters to recovery mode.

Try dumping the database, you might have a damaged table as in this case: http://www.postgresql.org/message-id/cagwygjwpiffet_k6qvxjjqo_jrqiueu+bszr1hurrh1obv8...@mail.gmail.com good luck. 2014-05-03 18:59 GMT-05:00 David G Johnston : > DrakoRod wrote > > Hi everybody! > > > > I have a problem

[GENERAL] Server continuously enters to recovery mode.

Hi everybody! I have a problem (really huge problem), I have one server of production, but yesterday in the night I saw this error: *ERROR: could not access status of transaction 2410303155 DETAIL: Could not open file "pg_clog/08FA": No such file or directory* Solution: * dd if=/d

Re: [GENERAL] Server continuously enters to recovery mode.

DrakoRod wrote > Hi everybody! > > I have a problem (really huge problem), I have one server of production, > but yesterday in the night I saw this error: > > * > ERROR: could not access status of transaction 2410303155 > DETAIL: Could not open file "pg_clog/08FA": No such file or di

Re: [GENERAL] Server Timezone

You're right. This was my error. Sent from my iPhone > On Apr 7, 2014, at 8:53 PM, Tom Lane wrote: > > Robert DiFalco writes: >> Is there any way to set the timezone of the postgres server differently >> than the OS? I *have* tried setting timezone = 'UTC' in my postgresql.conf >> file but th

Re: [GENERAL] Server Timezone

Robert DiFalco writes: > Is there any way to set the timezone of the postgres server differently > than the OS? I *have* tried setting timezone = 'UTC' in my postgresql.conf > file but that seems to be a VIEW of time zone. It doesn't seem to behave > the same as running a postgresql server on a ma

[GENERAL] Server Timezone

Is there any way to set the timezone of the postgres server differently than the OS? I *have* tried setting timezone = 'UTC' in my postgresql.conf file but that seems to be a VIEW of time zone. It doesn't seem to behave the same as running a postgresql server on a machine that is in UTC. The machin

Re: [GENERAL] Server hanging with high CPU wait -- Checkpoint issue?

Thank you for the response. Our new server went down in memory from 20Gig to 16Gig. Our old server has 100 databases in the cluster, and we will be splitting up into multiple servers so we thought the the decrease was acceptable. dirty_background_ratio is 10 on the new box and 1 on the old. Tha

Re: [GENERAL] Server hanging with high CPU wait -- Checkpoint issue?

On Mon, Feb 3, 2014 at 11:16 AM, George Woodring wrote: > I am running 9.3.2 on CentOS 6.5 > > We have a new server we are migrating to that seems to lock up for up to > 30sec at a time with all of the processes in wait. I am seeing a weird > output with the checkpoint logs and am wondering if I

[GENERAL] Server hanging with high CPU wait -- Checkpoint issue?

I am running 9.3.2 on CentOS 6.5 We have a new server we are migrating to that seems to lock up for up to 30sec at a time with all of the processes in wait. I am seeing a weird output with the checkpoint logs and am wondering if I need to adjust something with the checkpointer config. My checkpo

Re: [GENERAL] Server Crash: Issues Re-starting Postgres [RESOLVED]

On Tue, 7 Jan 2014, Rich Shepard wrote: What is the process I follow to get postgres running again? Found the problem and fixed it. I had touched /tmp/.s.PGSQL.5432 as root and it was a regular file, not a socket. Stopping postgres, deleting that file, and restarting the server fixed the

[GENERAL] Server Crash: Issues Re-starting Postgres

While I was out of the office yesterday the server shut down unexpectedly. Now I'm having difficulties getting postgres restarted because it's been so long since I've done this. Based on error messages when trying to start postgres I killed the .pid file and /tmp/.s.PGSQL.5432. Obviously the

Re: [GENERAL] server registration problems

On Thu, Dec 20, 2012 at 12:59 AM, Ivan Pašić wrote: > Hi, I installed postgresql 8.4 and I set port number in installation as > 5432. I also installed PostGIS and everything was working well. But now I > wanted to create new server with port number 54321 but I can't do it because > it gives me err

[GENERAL] server registration problems

Hi, I installed postgresql 8.4 and I set port number in installation as 5432. I also installed PostGIS and everything was working well. But now I wanted to create new server with port number 54321 but I can't do it because it gives me error ''Server doesn't listen''. I was reading about that in the

Re: [GENERAL] Server to run Postgresql

On Sun, Nov 4, 2012 at 9:37 AM, Raymond O'Donnell wrote: > On 03/11/2012 23:08, Bob Pawley wrote: >> Hi >> >> I have an unused computer which I am considering turning into a server >> to run my Postgresql database. >> >> Is this even possible to do? > > Hi Bob, > > Of course. > >> If so, can someo

Re: [GENERAL] Server to run Postgresql

On 03/11/2012 23:08, Bob Pawley wrote: > Hi > > I have an unused computer which I am considering turning into a server > to run my Postgresql database. > > Is this even possible to do? Hi Bob, Of course. > If so, can someone suggest an open source server that is relatively easy > to set up?

Re: [GENERAL] Server to run Postgresql

ostgresql"; Subject:  [GENERAL] Server to run Postgresql Hi   I have an unused computer which I am considering turning into a server to run my Postgresql database.   Is this even possible to do?   If so, can someone suggest an open source server that is relatively easy to set up? Wind

Re: [GENERAL] Server to run Postgresql

On 04/11/12 12:08, Bob Pawley wrote: Hi I have an unused computer which I am considering turning into a server to run my Postgresql database. Is this even possible to do? If so, can someone suggest an open source server that is relatively easy to set up? Windows based would be ideal. Bob If y

Re: [GENERAL] Server to run Postgresql

On Sat, Nov 3, 2012 at 8:08 PM, Bob Pawley wrote: > Hi > > I have an unused computer which I am considering turning into a server to > run my Postgresql database. > > Is this even possible to do? > > If so, can someone suggest an open source server that is relatively easy > to set up? Windows b

[GENERAL] Server to run Postgresql

Hi I have an unused computer which I am considering turning into a server to run my Postgresql database. Is this even possible to do? If so, can someone suggest an open source server that is relatively easy to set up? Windows based would be ideal. Bob

Re: [GENERAL] server process (PID 1304) was terminated by exception 0xC0000142

On Mon, Oct 8, 2012 at 1:36 AM, gelin yan wrote: > > > On Mon, Oct 8, 2012 at 1:56 PM, Scott Marlowe > wrote: >> If the OP needs > 100 connections on the app end, he should add a >> connection pooler like pgbouncer or pgpool. pgbouncer is the easier >> of the two to configure. > > > > Hi > >

Re: [GENERAL] server process (PID 1304) was terminated by exception 0xC0000142

On Mon, Oct 8, 2012 at 1:56 PM, Scott Marlowe wrote: > On Sun, Oct 7, 2012 at 9:27 PM, gelin yan wrote: > > > > > > On Mon, Oct 8, 2012 at 9:02 AM, Haiming Zhang < > haiming.zh...@redflex.com.au> > > wrote: > >> > >> Hi all, > >> > >> > >> > >> I am Haiming, a software engineer. > >> > >> > >> >

Re: [GENERAL] server process (PID 1304) was terminated by exception 0xC0000142

On Sun, Oct 7, 2012 at 9:27 PM, gelin yan wrote: > > > On Mon, Oct 8, 2012 at 9:02 AM, Haiming Zhang > wrote: >> >> Hi all, >> >> >> >> I am Haiming, a software engineer. >> >> >> >> One of our product is depending on PostgreSQL. I am facing a problem that >> it somehow always gave me an error "

Re: [GENERAL] server process (PID 1304) was terminated by exception 0xC0000142

On Mon, Oct 8, 2012 at 9:02 AM, Haiming Zhang wrote: > Hi all, > > ** ** > > I am Haiming, a software engineer. > > ** ** > > One of our product is depending on PostgreSQL. I am facing a problem that > it somehow always gave me an error " server process (PID 1304) was > terminated by exce

[GENERAL] server process (PID 1304) was terminated by exception 0xC0000142

Hi all, I am Haiming, a software engineer. One of our product is depending on PostgreSQL. I am facing a problem that it somehow always gave me an error " server process (PID 1304) was terminated by exception 0xC142." or " No buffer space available (maximum connections reached?): connect".

Re: [GENERAL] Server doesn't accept connection

On 09/26/2012 08:57 AM, Empire Software srl wrote: Dear mr Adrian, I reinstall postgres 9.1 but the problem does not change. I open the config file pg_hda.conf the adress is 127.0.0.1/32 I am CCing the list so more eyes can see. pg_hba.conf controls who gets in once a connection is made. Y

Re: [GENERAL] Server doesn't accept connection

On 09/26/2012 07:39 AM, fra2012 wrote: Hi, i'm new user i'm this problem: My database Pgadmin III up to yesterday connect, tomorrow display this message: Could not connect to server: connection refused (0x274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP

[GENERAL] Server doesn't accept connection

Hi, i'm new user i'm this problem: My database Pgadmin III up to yesterday connect, tomorrow display this message: Could not connect to server: connection refused (0x274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432? I'm scanning

Re: [GENERAL] Server writing short WAL files

beamsplit...@gmail.com writes: > I'm having trouble with WAL files. Every 4th WAL file written by the server > into pg_xlog is 24576 bytes instead of 16MB. A short WAL causes a fatal > error during recovery. Hm. It's fairly hard to see how you could get into such a state to start with, but once t

[GENERAL] Server writing short WAL files

Hi, I'm having trouble with WAL files. Every 4th WAL file written by the server into pg_xlog is 24576 bytes instead of 16MB. A short WAL causes a fatal error during recovery. This behavior is perfectly consistent. For example, if archive_timeout is 5 mins, every 20 minutes the new WAL file is 245

Re: [GENERAL] Server choice for small workload : raptors or SSD?

On Wed, Mar 21, 2012 at 6:47 PM, Rory Campbell-Lange wrote: > I'd be grateful for comments on whether to go with a server with the A > or B spec. Both servers have the following in common: > >    E5620 Quad-Core / 4x 2.40GHz >    LSI MegaRAID SAS 9260-4i with BBU (6Gbps) >    48 GB PC3-10600 DDR3

Re: [GENERAL] Server choice for small workload : raptors or SSD?

We've used Raptors in production for a few years. They've been about as reliable as you'd expect for hard drives, with the additional excitement of a firmware bug early on that led to data loss and considerable expense. New machines deployed since November last year have 710 SSDs. No problems so

[GENERAL] Server choice for small workload : raptors or SSD?

I presently have about 40 databases on an aging server which runs both Postgresql and Apache. The databases presently consume about 20GB and I expect them to be consuming around 40GB in a year or more if demand for our services expand as we hope. The present database is 2 x Quad core E5420 Xeon (2

Re: [GENERAL] Server not starting problem

On Wed, 2012-02-01 at 11:44 -0200, Pablo Fulco wrote: > Hi all, im very new to postgres, and im having a problem with postgres 8.1. > > The thing is that the server wont start, when I checked the log it said: > > > > Received fast shutdown request > > Aborting any active transaction > > FATA

[GENERAL] Server not starting problem

Hi all, im very new to postgres, and im having a problem with postgres 8.1. The thing is that the server wont start, when I checked the log it said: Received fast shutdown request Aborting any active transaction FATAL: terminating connection due ti administrator command FATAL: terminating c

Re: [GENERAL] Server/Data Migration Advice

On Thursday, December 15, 2011 7:57:40 am Carlos Mennens wrote: > So after reading > http://www.postgresql.org/docs/9.1/interactive/backup-dump.html, That was not the link I posted. In fact I have never actually been to that page:) This is the link I posted: http://www.postgresql.org/docs/9.1/in

Re: [GENERAL] Server/Data Migration Advice

On Thu, Dec 15, 2011 at 11:09 AM, Raymond O'Donnell wrote: > The point here is that with the plain-text dump (the default output from > pg_dump), you can feed that directly to psql; but you have no control > over what is restored, or in what order, without editing the dump file > directly. > > If,

Re: [GENERAL] Server/Data Migration Advice

On 15/12/2011 15:57, Carlos Mennens wrote: > So after reading > http://www.postgresql.org/docs/9.1/interactive/backup-dump.html, > > I'm not sure why the manual shows you in "24.1. SQL Dump" & then > directly after in 24.1.1, they explain how to restore with psql as you > advised me not to. I got

Re: [GENERAL] Server/Data Migration Advice

On Thu, Dec 15, 2011 at 10:28 AM, Adrian Klaver wrote: > The reason I pointed to the manual links is that there is a lot of good > information in there. It deserves more than a skim:). Realistically, to get > the > most out of the dump/restore process you need to know the options available on > b

Re: [GENERAL] Server/Data Migration Advice

On Thursday, December 15, 2011 6:55:46 am Carlos Mennens wrote: > On Thu, Dec 15, 2011 at 9:37 AM, Adrian Klaver wrote: > > You know the fine manual covers this?: > > http://www.postgresql.org/docs/9.1/interactive/app-pgdump.html > > I've honestly skimmed the manual and it's very easy to use and

Re: [GENERAL] Server/Data Migration Advice

On Thu, Dec 15, 2011 at 9:37 AM, Adrian Klaver wrote: > You know the fine manual covers this?: > http://www.postgresql.org/docs/9.1/interactive/app-pgdump.html I've honestly skimmed the manual and it's very easy to use and good but it covers so many aspects and sometimes I need a specific answer

  1   2   3   4   5   >