Re: [GENERAL] starting PG command line options vs postgresql.con

On Mon, Oct 30, 2017 at 2:08 PM, David G. Johnston wrote: > On Mon, Oct 30, 2017 at 6:48 AM, rakeshkumar464 > wrote: >> >> I would prefer using postgresql.conf. what is the consensus in this forum >> regarding command line vs

Re: [GENERAL] starting PG command line options vs postgresql.con

On Mon, Oct 30, 2017 at 6:48 AM, rakeshkumar464 wrote: > I would prefer using postgresql.conf. what is the consensus in this forum > regarding command line vs postgresql.conf. ​I suspect that most people administering a PostgreSQL database would expect that the

Re: [GENERAL] starting PG command line options vs postgresql.con

rakeshkumar464 writes: > I am new to Docker env and I see that PG, as a container is started with > [ lots of command-line parameters ] > I would prefer using postgresql.conf. what is the consensus in this forum > regarding command line vs postgresql.conf. Also if

[GENERAL] starting PG command line options vs postgresql.con

I am new to Docker env and I see that PG, as a container is started with parameters like this: docker run -it \ --detach \ --name name \ --restart=unless-stopped \ -p 5432:5432 \ -e PGDATA=/var/lib/postgresql/data/pg10 -N 500 \ -B 3GB \ -S 6291kB \ -c listen_addresses=* \ -c

Re: [GENERAL] Starting new cluster from base backup

On 02/18/2015 10:24 AM, Guillaume Drolet wrote: 2015-02-18 11:06 GMT-05:00 Adrian Klaver adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com: So is E:\ a network drive shared by both machines? No, E:\ is a local drive on which I created a tablespace, in order to have enough

Re: [GENERAL] Starting new cluster from base backup

2015-02-18 13:40 GMT-05:00 Adrian Klaver adrian.kla...@aklaver.com: On 02/18/2015 10:24 AM, Guillaume Drolet wrote: 2015-02-18 11:06 GMT-05:00 Adrian Klaver adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com: So is E:\ a network drive shared by both machines? No, E:\ is a

Re: [GENERAL] Starting new cluster from base backup

2015-02-18 11:06 GMT-05:00 Adrian Klaver adrian.kla...@aklaver.com: On 02/18/2015 04:26 AM, Guillaume Drolet wrote: 2015-02-17 17:14 GMT-05:00 Adrian Klaver adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com: On 02/17/2015 06:54 AM, Guillaume Drolet wrote: Adrian:

Re: [GENERAL] Starting new cluster from base backup

2015-02-18 16:11 GMT-05:00 Adrian Klaver adrian.kla...@aklaver.com: On 02/18/2015 11:51 AM, Guillaume Drolet wrote: 2015-02-18 13:40 GMT-05:00 Adrian Klaver adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com: On 02/18/2015 10:24 AM, Guillaume Drolet wrote:

Re: [GENERAL] Starting new cluster from base backup

On 02/18/2015 11:51 AM, Guillaume Drolet wrote: 2015-02-18 13:40 GMT-05:00 Adrian Klaver adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com: On 02/18/2015 10:24 AM, Guillaume Drolet wrote: 2015-02-18 11:06 GMT-05:00 Adrian Klaver adrian.kla...@aklaver.com

Re: [GENERAL] Starting new cluster from base backup

2015-02-17 17:14 GMT-05:00 Adrian Klaver adrian.kla...@aklaver.com: On 02/17/2015 06:54 AM, Guillaume Drolet wrote: Adrian: thanks for this information. I tried running pg_basebackup in plain format with option -X stream (pg_basebackup -D F:\208376PT\db -X stream -l 208376PT17022015 -U

Re: [GENERAL] Starting new cluster from base backup

On 02/18/2015 04:26 AM, Guillaume Drolet wrote: 2015-02-17 17:14 GMT-05:00 Adrian Klaver adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com: On 02/17/2015 06:54 AM, Guillaume Drolet wrote: Adrian: thanks for this information. I tried running pg_basebackup in

Re: [GENERAL] Starting new cluster from base backup

On 02/18/2015 01:48 PM, Guillaume Drolet wrote: So if I understand correctly you have: 1) On source machine a directory E:\Data\Database. 2) On the source machine in Postgres you have a created a tablespace that points at E:\Data\Database. 3) On destination machine

Re: [GENERAL] Starting new cluster from base backup

Adrian: thanks for this information. I tried running pg_basebackup in plain format with option -X stream (pg_basebackup -D F:\208376PT\db -X stream -l 208376PT17022015 -U postgres -P) but I got the message: pg_basebackup: directory E:\Data\Database exists but is not empty I creatde a tablespace

Re: [GENERAL] Starting new cluster from base backup

This provides part of the answer to my previous post, from the 9.4 doc (although I'm running 9.3 but I guess the second phrase in the paragraph applies to my case): Tablespaces will in plain format by default be backed up to the same path they have on the server, unless the option

Re: [GENERAL] Starting new cluster from base backup

On 02/17/2015 06:54 AM, Guillaume Drolet wrote: Adrian: thanks for this information. I tried running pg_basebackup in plain format with option -X stream (pg_basebackup -D F:\208376PT\db -X stream -l 208376PT17022015 -U postgres -P) but I got the message: pg_basebackup: directory

Re: [GENERAL] Starting new cluster from base backup

On 02/17/2015 06:54 AM, Guillaume Drolet wrote: Adrian: thanks for this information. I tried running pg_basebackup in plain format with option -X stream (pg_basebackup -D F:\208376PT\db -X stream -l 208376PT17022015 -U postgres -P) but I got the message: pg_basebackup: directory

Re: [GENERAL] Starting new cluster from base backup

On 02/16/2015 11:31 AM, Guillaume Drolet wrote: Dear listers, I want to move a cluster from one machine to another. I used pg_basebackup to create an archive and copied/extracted it over the old PGDATA location on the new machine (the server was stopped). If I start pgsql I get these messages

[GENERAL] Starting new cluster from base backup

Dear listers, I want to move a cluster from one machine to another. I used pg_basebackup to create an archive and copied/extracted it over the old PGDATA location on the new machine (the server was stopped). If I start pgsql I get these messages in my log file: 2015-02-16 14:29:12 EST LOG:

Re: [GENERAL] Starting a cluster as a service

Hello Raghavendra, Sorry for the late answer, I couldn't test this properly before. That indeed solves the problem. Thank you and best regards. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Starting-a-cluster-as-a-service-tp5712728p5714759.html Sent from the PostgreSQL

Re: [GENERAL] Starting a cluster as a service

Hi again, I'm running PostgreSQL 9.1 under Windows XP. I'm still trying to set a proper logging system for a PostgreSQL cluster a_pg_cluster. In the cluster postgresql.conf configuration file, I uncommented logging_connector = on. When I stopped + started the service, I could see a pg_log

Re: [GENERAL] Starting a cluster as a service

On Fri, Jun 22, 2012 at 5:36 PM, Léa Massiot lmhe...@orange.fr wrote: Hi again, I'm running PostgreSQL 9.1 under Windows XP. I'm still trying to set a proper logging system for a PostgreSQL cluster a_pg_cluster. In the cluster postgresql.conf configuration file, I uncommented

Re: [GENERAL] Starting a cluster as a service

Hello Thomas, Contrary to what you say, I provided command lines and messages (in case of failure). What is missing according to you? Thank you and best regards. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Starting-a-cluster-as-a-service-tp5712728p5713039.html Sent

Re: [GENERAL] Starting a cluster as a service

Hi again, It looks like the problem comes from the -l option I'm trying to set when I register the service. 1) If I register the cluster as a service in the following way: It works: the service is automatically started properly. 2) If I add the following option: and then try to start the

Re: [GENERAL] Starting a cluster as a service

Sorry. I added some raw tags so maybe this is the reason why you couldn't see half of my message. Hi again, It looks like the problem comes from the -l option I'm trying to set when I register the service. 1) If I register the cluster as a service in the following way:

[GENERAL] Starting a cluster as a service

Hello and thank you for reading my post. My problem is that I do not manage to start a PostgreSQL cluster as a Windows service. The OS is WinXP. - I've created a PostgreSQL cluster a_pgcluster with the associated port 5433. - Running cmd.exe under Windows as a_user, I can start and stop it

Re: [GENERAL] Starting a cluster as a service

Hello Léa, Command line, message and commands are missing. Difficult to help you! Regards, Thomas 2012/6/15 Léa Massiot lmhe...@orange.fr Hello and thank you for reading my post. My problem is that I do not manage to start a PostgreSQL cluster as a Windows service. The OS is WinXP. -

Re: [GENERAL] Starting PostgreSQL

admin wrote: Sorry folks, a perennial one I'm sure ... I have read the manual and Googled for a couple of hours but still can't connect to PostgreSQL 8.3.4 (the PGDG RPMs running on an up to date CentOS 5.2). I continually get this message: psql: could not connect to server: No such

[GENERAL] Starting PostgreSQL

Sorry folks, a perennial one I'm sure ... I have read the manual and Googled for a couple of hours but still can't connect to PostgreSQL 8.3.4 (the PGDG RPMs running on an up to date CentOS 5.2). I continually get this message: psql: could not connect to server: No such file or firectory Is

Re: [GENERAL] Starting PostgreSQL

On Sun, 2008-10-12 at 00:03 +0930, admin wrote: psql: could not connect to server: No such file or firectory Is the server running locally and accepting connections on Unix domain socket /tmp/.s.PDSQL.0? Socket file name is wrong -- and the port... -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org,

Re: [GENERAL] Starting PostgreSQL

On Saturday 11 October 2008 7:33:20 am admin wrote: Sorry folks, a perennial one I'm sure ... I have read the manual and Googled for a couple of hours but still can't connect to PostgreSQL 8.3.4 (the PGDG RPMs running on an up to date CentOS 5.2). I continually get this message: psql:

Re: [GENERAL] Starting PostgreSQL

admin [EMAIL PROTECTED] writes: I continually get this message: psql: could not connect to server: No such file or firectory Is the server running locally and accepting connections on Unix domain socket /tmp/.s.PDSQL.0? If it's really saying .0, and not .5432, then the problem is on the

Re: [GENERAL] starting a stored procedure+rule AFTER an insert

Thanks for the reply, is there any online reference / tutorial for this? -BD 2007/10/8, Douglas McNaught [EMAIL PROTECTED]: Bima Djaloeis [EMAIL PROTECTED] writes: I have implemented a stored procedure that writes out the newest DB entry on insert, and combined it with a rule. 1)

[GENERAL] starting a stored procedure+rule AFTER an insert

Hi, Newbie here, I have implemented a stored procedure that writes out the newest DB entry on insert, and combined it with a rule. 1) create function newcache() returns void AS 'newCache', 'newCache' language c; 2) create rule newcacherule AS on insert to caches do also select newcache(); The

Re: [GENERAL] starting a stored procedure+rule AFTER an insert

Bima Djaloeis [EMAIL PROTECTED] writes: I have implemented a stored procedure that writes out the newest DB entry on insert, and combined it with a rule. 1) create function newcache() returns void AS 'newCache', 'newCache' language c; 2) create rule newcacherule AS on insert to caches do

[GENERAL] Starting Postgresql

I haven't used the command lines previously having relied on PG Admin. In the instructions - Starting postmaster Nothing can happen to a database unless the postmaster process is running. As the site administrator, there are a number of things you should remember before starting the

Re: [GENERAL] Starting Postgresql

a shell http://en.wikipedia.org/wiki/Shell_%28computing%29 On Wed, Dec 20, 2006 at 10:59:05AM -0800, Bob Pawley wrote: I haven't used the command lines previously having relied on PG Admin. In the instructions - Starting postmaster Nothing can happen to a database unless the postmaster

Re: [GENERAL] Starting Postgresql

which in PostgreSQL is Bob - Original Message - From: Ray Stell [EMAIL PROTECTED] To: Bob Pawley [EMAIL PROTECTED] Cc: Postgresql pgsql-general@postgresql.org Sent: Wednesday, December 20, 2006 11:07 AM Subject: Re: [GENERAL] Starting Postgresql a shell http://en.wikipedia.org

Re: [GENERAL] Starting Postgresql

which in PostgreSQL is Bob - Original Message - From: Bob Pawley [EMAIL PROTECTED] To: Ray Stell [EMAIL PROTECTED] Cc: Postgresql pgsql-general@postgresql.org Sent: Wednesday, December 20, 2006 11:12 AM Subject: Re: [GENERAL] Starting Postgresql which in PostgreSQL is Bob

Re: [GENERAL] Starting Postgresql

On 20 Dec 2006 at 11:12, Bob Pawley wrote: which in PostgreSQL is It's not in PostgreSQL - it's the shell of your operating system. In Windows, you get that either by clicking Start - Run and typing command or cmd (depending on your version of windows), or by clicking on Start - Programs

Re: [GENERAL] Starting Postgresql

Raymond O'Donnell wrote: On 20 Dec 2006 at 11:12, Bob Pawley wrote: which in PostgreSQL is It's not in PostgreSQL - it's the shell of your operating system. In Windows, you get that either by clicking Start - Run and typing command or cmd (depending on your version of windows), or by

Re: [GENERAL] Starting Postgresql

] To: Ray Stell [EMAIL PROTECTED] Cc: Postgresql pgsql-general@postgresql.org Sent: Wednesday, December 20, 2006 11:12 AM Subject: Re: [GENERAL] Starting Postgresql which in PostgreSQL is Bob - Original Message - From: Ray Stell [EMAIL PROTECTED] To: Bob Pawley [EMAIL

Re: [GENERAL] Starting Postgresql

: [GENERAL] Starting Postgresql Raymond O'Donnell wrote: On 20 Dec 2006 at 11:12, Bob Pawley wrote: which in PostgreSQL is It's not in PostgreSQL - it's the shell of your operating system. In Windows, you get that either by clicking Start - Run and typing command or cmd (depending on your

Re: [GENERAL] Starting Postgresql

AM Subject: Re: [GENERAL] Starting Postgresql Raymond O'Donnell wrote: On 20 Dec 2006 at 11:12, Bob Pawley wrote: which in PostgreSQL is It's not in PostgreSQL - it's the shell of your operating system. In Windows, you get that either by clicking Start - Run and typing command

Re: [GENERAL] Starting Postgresql

Original Message From Bob Pawley Here's the url http://fusion.gat.com/~osborne/dbdoc/postgres/postmaster.htm Bob, The above documentation is circa version 7.0. It might be easier to use the current PostgreSQL official documentation. See for example:

Re: [GENERAL] Starting Postgresql

Bob Pawley wrote: Here's the url http://fusion.gat.com/~osborne/dbdoc/postgres/postmaster.htm As the others say, use the official docs. And perhaps drop osborne a note to let him know his docs are out of date. -- Richard Huxton Archonet Ltd ---(end of

[GENERAL] starting postgres on windows

How would I start Postgres on windows as an un-privileged user without logging into an un-privileged account. I have tried the -U switch but it still complains. I have version 8. kind regards Garry ---(end of broadcast)--- TIP 1: if posting/reading

Re: [GENERAL] starting postgres on windows

Garry, the standard recommendation is to install PostgreSQL as a service on windows; logging in with an own low privilege user account, usually named postgres. That usage of a service is recommended because it solves all the usual problems of services :) (start, shut down, login as seperate

Re: [GENERAL] starting postgres on windows

On 27 Nov 2006 at 8:03, garry saddington wrote: How would I start Postgres on windows as an un-privileged user without logging into an un-privileged account. I have tried the -U switch but it still complains. I have version 8. If you installed PostgreSQL using the installer - which I'd

[GENERAL] Starting Postgresql as windows service

Hi I want to start psql as a windows service manually.How to do that?i was able to register the service but able to start it..when i start it ..i got the following message..---Services ---The PostgreSQL service on Local Computer started and then

Re: [GENERAL] Starting Postgresql as windows service

Rajarajan,please check the postgresql logs witin your data directory pg_logyour data directory defaults to [programs]\Postgresql\8.1\datawhere [programs] is ~Programs and Files in US Windows, and Programme in German Windows. Propably there is some problem with postgresql.conf or access to your

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

On Sun, 2005-10-30 at 23:08 -0500, Tom Lane wrote: Vlad [EMAIL PROTECTED] writes: I'm looking for some help in regards to letting Posresql use more memory. 8.0 can't go past 2Gb of shared memory, and there is really no reason to try because its performance will get worse not better with

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

On Mon, Oct 31, 2005 at 12:16:59PM +, Simon Riggs wrote: 8.0 can't go past 2Gb of shared memory, and there is really no reason to try because its performance will get worse not better with more than about 5 shared buffers. Unless you turn off the bgwriter, in which case going

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

On Mon, 2005-10-31 at 14:14 +0100, Martijn van Oosterhout wrote: On Mon, Oct 31, 2005 at 12:16:59PM +, Simon Riggs wrote: 8.0 can't go past 2Gb of shared memory, and there is really no reason to try because its performance will get worse not better with more than about 5 shared

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

Anyway, the original writer didn't specify an architechure. If it is a 32bit one it is entirly possible that the memory map simply has no large contiguous space to map the shared memory. it's 32bit. The actual problem of giving more buffers to postgresql was solved with the help of the

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

Simon Riggs [EMAIL PROTECTED] writes: On Mon, 2005-10-31 at 14:14 +0100, Martijn van Oosterhout wrote: On Mon, Oct 31, 2005 at 12:16:59PM +, Simon Riggs wrote: I'm not sure we have any good tests of that either way, do we? I'm not certain why we would trust OS cache any more than we could

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

On Mon, Oct 31, 2005 at 01:34:12PM +, Simon Riggs wrote: Secondly, you're assuming that PostgreSQLs caching is at least as efficient as the OS caching, which is more of an assertion than anything else. Do you doubt that? Why would shared_buffers be variable otherwise? Because the

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

Martijn van Oosterhout kleptog@svana.org writes: There have been tests that demonstrate that you can raise the buffers to a certain point which is optimal and after that it just doesn't help [1]. They peg optimal size at 5-10% of memory. [1]

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

On Mon, Oct 31, 2005 at 09:54:39AM -0500, Tom Lane wrote: Note however that it's reasonable to think that 8.1 may do better than 8.0 did at performing well with large values of shared_buffers, primarily because we got rid of the StrategyDirtyBufferList overhead:

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

On Mon, 2005-10-31 at 09:35 -0500, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: On Mon, 2005-10-31 at 14:14 +0100, Martijn van Oosterhout wrote: On Mon, Oct 31, 2005 at 12:16:59PM +, Simon Riggs wrote: I'm not sure we have any good tests of that either way, do we? I'm not

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

Simon Riggs [EMAIL PROTECTED] writes: On Mon, 2005-10-31 at 09:35 -0500, Tom Lane wrote: The real point is that RAM dedicated to shared buffers can't be used for anything else [1], whereas letting the kernel manage it gives you some flexibility (for instance, to deal with transient large

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

On Mon, 2005-10-31 at 10:58, Simon Riggs wrote: On Mon, 2005-10-31 at 15:44 +0100, Martijn van Oosterhout wrote: On Mon, Oct 31, 2005 at 01:34:12PM +, Simon Riggs wrote: Secondly, you're assuming that PostgreSQLs caching is at least as efficient as the OS caching, which is more of

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

On Mon, 2005-10-31 at 14:50 -0600, Scott Marlowe wrote: As I understand it, when the last backend referencing a collection of data stops referencing it, that the buffers holding that data are released, and if, a second later, another backend wants the data, then it has to go to the Kernel for

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

On Mon, Oct 31, 2005 at 02:50:31PM -0600, Scott Marlowe wrote: Your point was about cache efficiency as an argument for not increasing shared_buffers. Politely, I don't accept that argument. Clearly, there are some other considerations (for which I agree completely) but those don't prevent

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

Scott Marlowe [EMAIL PROTECTED] writes: I was mainly wondering if that behaviour had changed, if, when the data are released, they are still held in shared memory until forced out by newer / more popular data. Which would make the buffer pool a real cache. Huh? It's always done that.

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

On Mon, 2005-10-31 at 15:44, Simon Riggs wrote: On Mon, 2005-10-31 at 14:50 -0600, Scott Marlowe wrote: As I understand it, when the last backend referencing a collection of data stops referencing it, that the buffers holding that data are released, and if, a second later, another backend

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

On Mon, 2005-10-31 at 16:12, Tom Lane wrote: Scott Marlowe [EMAIL PROTECTED] writes: I was mainly wondering if that behaviour had changed, if, when the data are released, they are still held in shared memory until forced out by newer / more popular data. Which would make the buffer pool a

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD

On Mon, 2005-10-31 at 14:48 -0800, Chris Travers wrote: Simon Riggs wrote: Your point was about cache efficiency as an argument for not increasing shared_buffers. Politely, I don't accept that argument. Clearly, there are some other considerations (for which I agree completely) but those

[GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD 6.0]

Hi, I'm looking for some help in regards to letting Posresql use more memory. It fails to start with this message: shmat(id=65536) failed: Cannot allocate shared bufers Max buffers I can start it with is 115200. Server has 4gig of RAM, I've adjuted MAXDSIZ to 2.5Gigs. Here is other kernel

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD 6.0]

Vlad [EMAIL PROTECTED] writes: I'm looking for some help in regards to letting Posresql use more memory. 8.0 can't go past 2Gb of shared memory, and there is really no reason to try because its performance will get worse not better with more than about 5 shared buffers. 8.1 will relax the

Re: [GENERAL] Starting PostgreSQL 8.0.4 with more memory [FreeBSD 6.0]

Tom, I understood your point on memory usage. Out of curiosity - 115200 buffers seems to be little less than 1 gig (I assume 1 buffer = 8k), so I could not get any closer to 2gigs anyways Is it practical experience that more than 5 buggers actually hurts postgresql performance? Any ideas

[GENERAL] Starting PostgreSQL on WinXP is not working

Hi, i'm working with PostgreSQL for a long time (about three years), but always on Linux box. But recently, I had to intall PostgreSQL on a WinXP machine! The installation works fine, although the starting service did not works in the finalization of the installation! The installation was

Re: [GENERAL] Starting PostgreSQL on WinXP is not working

Hi, i'm working with PostgreSQL for a long time (about three years), but always on Linux box. But recently, I had to intall PostgreSQL on a WinXP machine! The installation works fine, although the starting service did not works in the finalization of the installation! The

[GENERAL] starting postgresql with pgsql password - workarounds?

hello, I've been using postgresql for about a year now, and am pretty comfortable with the basics, bu there has been something bugging me for a while now: I set the METHOD in pg_hba.conf to md5 so that a password is required from all users, from all hosts. The only problem is that if the

Re: [GENERAL] starting postgresql with pgsql password - workarounds?

This is not a PostgreSQL problem, it's the script you are using for startup that has some problem. The pg_hba method is for connection stablishment. PostgreSQL will start no matter what you put there. Startup scripts are usually run as root, and postgresql script should su to the postgresql user

Re: [GENERAL] starting postgresql with pgsql password - workarounds?

I am using the default startup script that is supplied with the FreeBSD port (/usr/local/etc/rc.d/010.pgsql.sh) and enabling it in /etc/rc.d with -o -i flags so listens on TCP/IP Also, I should mention that the password I mentioned is NOT the password for the local (Unix) pgsql account, but

Re: [GENERAL] starting postgresql with pgsql password - workarounds?

mmmhhh, I have never installed postgresql from the ports. I don´t know what the script is doing, probably it´s checking that Postgresql directory is initialized. Anyway, here is my homemade script, you could replace yours with it (check it first, but it´s quite simple). My script does not tell

Re: [GENERAL] starting postgresql with pgsql password - workarounds?

# set defaults postgresql_enable=${postgresql_enable:-NO} postgresql_flags=${postgresql_flags:--w -s -m fast} Try it without the -w ... that's probably causing it to try to connect with psql. Alternatively, set up a ~/.pgpass file for the postgres user (which might be a reasonable thing

[GENERAL] starting

I am interested in seting up postgres 7.4 or 8.0 which is best on SuSe 8.0 professional and where should I put the tar.gz for unzip and install? Thank you. Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html

[GENERAL] starting the database server

Hello, I'm using a windows 2000 advanced server, postgresql was installed and working fine, and I'm using pgadminIII. the database server cannot start and get error "is the postmaster running with -i on localhost 127.0.0.1 and accepting tcp/ip connection on the port 5432" the last

Re: [GENERAL] starting the database server

Nefnifi, Kasem wrote: when trying to start it via the services of windows, get an internal error that error in windows or in the service... What error? What do your system logs say? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7:

Re: [GENERAL] starting the database server

Nefnifi, Kasem wrote: thanks Richard for the reaction, bellow a print screen of the error that I get when I try to start the service from windows services control panel: ole0.bmp Try and stick to cutting and pasting text rather than embedding images - lots of people on the lists will be

Re: [GENERAL] starting the database server

, 2004 2:17 PM To: Nefnifi, Kasem Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] starting the database server Nefnifi, Kasem wrote: thanks Richard for the reaction, bellow a print screen of the error that I get when I try to start the service from windows services control panel: ole0.bmp Try

Re: [GENERAL] starting the database server

Nefnifi, Kasem wrote: Hi Richard, bellow the text from the log file: -- start log file -- 30/11/2004 16:45:08PostgreSQL Error None0 N/A BAAN-AT-HOME execution of PostgreSQL by a user with administrative permissions is not permitted. The server

Re: [GENERAL] starting the database server

in advance. -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 5:42 PM To: Nefnifi, Kasem Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] starting the database server Nefnifi, Kasem wrote: Hi Richard, bellow the text from the log file

Re: [GENERAL] starting the database server

Nefnifi, Kasem wrote: Hello, but it has worked fine since the installation without any error until now and nothing has been changed in the system policy. how it can something like this happened. Something must have changed. If it's not your installation of PostgreSQL then it's something in the

Re: [GENERAL] starting the database server

30/11/200416:45:08PostgreSQL Error None0 N/A BAAN-AT-HOMEexecution of PostgreSQL by a user with administrative permissions is not permitted. The server must be started under an unprivileged user ID to prevent possible system security compromise. See the

[GENERAL] starting the server at boot

Hello; If I add the line: --- su -c 'pg_ctl start -D /usr/local/pgsql/data/ -l /usr/local/pgsql/data/logfile' postgres --- to /etc/rc.d/rd.local. Is there a way this could work when I don't boot as root, but as a common user? (I should be able to automatically

Re: [GENERAL] starting the server at boot

On Monday 10 November 2003 15:02, javier garcia - CEBAS wrote: Hello; If I add the line: --- su -c 'pg_ctl start -D /usr/local/pgsql/data/ -l /usr/local/pgsql/data/logfile' postgres --- to /etc/rc.d/rd.local. Is there a way this could work when I don't

[GENERAL] starting personal postmaster

How can I start a personal postmaster, e.g. the postmaster should manage a database cluster in ~/pgdata/. I'm using the Debian package of postgresql (7.0.3) and it want's to create a socket at /var/run/postgres/.s.PORT.sock (or something similiar). As I am not user postgres I dont have the

Re: [GENERAL] starting personal postmaster

Stefan Karrmann writes: How can I start a personal postmaster, e.g. the postmaster should manage a database cluster in ~/pgdata/. I'm using the Debian package of postgresql (7.0.3) and it want's to create a socket at /var/run/postgres/.s.PORT.sock (or something similiar). As I am not user

RE: [GENERAL] Starting postgresql on startup

Title: RE: [GENERAL] Starting postgresql on startup 'linuxconf' on Mandrake 7.1 should be able to set postgres to run at boot time as long as you set Postgresql up from an rpm. If you got to 'Control Panel' - 'Control service activity' - 'postgresql'. Set Startup to automatic and select

[GENERAL] Starting Postmaster

I've installed postgresql on a Linux-Mandrake 7.0.2 box with everything installing correctly. But when I try to start postmaster I get the following: DEBUG: Data Base System is in production state at Mon Mar 26 (and so forth) I know that there is a simple answer but I haven't been able to find

Re: [GENERAL] Starting Postmaster

"Scott Gritton" [EMAIL PROTECTED] writes: I've installed postgresql on a Linux-Mandrake 7.0.2 box with everything installing correctly. But when I try to start postmaster I get the following: DEBUG: Data Base System is in production state at Mon Mar 26 (and so forth) I know that there

Re: [GENERAL] Starting Postmaster

On Monday 26 March 2001 03:49 pm, Doug McNaught wrote: "Scott Gritton" [EMAIL PROTECTED] writes: I've installed postgresql on a Linux-Mandrake 7.0.2 box with everything installing correctly. But when I try to start postmaster I get the following: DEBUG: Data Base System is in

Re: [GENERAL] Starting Postmaster

On Mon, 26 Mar 2001, Scott Gritton wrote: I've installed postgresql on a Linux-Mandrake 7.0.2 box with everything installing correctly. But when I try to start postmaster I get the following: DEBUG: Data Base System is in production state at Mon Mar 26 (and so forth) I know that there is

[GENERAL] Starting Postgres on NT 4.0

Hi: Now I have the NT binaries, I've installed them, also have running the ipc-daemon but now when I try to start postgres this happens: joe666@THOR /etc $ /pgsql/bin/postgres.exe -D /pgsql/data/ DEBUG: Data Base System is starting up at Tue Oct 24 19:26:29 2000 DEBUG: Data Base System was

[GENERAL] Starting postmaster at boot

I'm still having difficulties getting postgres to start on boot. Any chance someone can give me an example of how they have it on their system? (Seemed to have been lost in the list being down). Adam Lang Systems Engineer Rutgers Casualty Insurance Company

Re: [GENERAL] Starting postmaster at boot

At 03:20 PM 9/14/00 -0400, Adam Lang wrote: I'm still having difficulties getting postgres to start on boot. Any chance someone can give me an example of how they have it on their system? (Seemed to have been lost in the list being down). Adam Lang Systems Engineer Rutgers Casualty

Re: [GENERAL] Starting postmaster at boot

Does it work the same for linux? Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "David Veatch" [EMAIL PROTECTED] To: "Adam Lang" [EMAIL PROTECTED]; "PGSQL General" [EMAIL PROTECTED] Sent: Thursday, September 14, 2000

Re: [GENERAL] Starting postmaster at boot

At 03:31 PM 9/14/00 -0400, Adam Lang wrote: Does it work the same for linux? It's basic sh, so I can only assume that it does, though I should stress that I don't run Linux, and haven't sat at a Linux command prompt in over a year... so I can't say it does with 100% certainty. The sh syntax

  1   2   >