Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied
On Sun, Jun 13, 2010 at 5:11 AM, Craig Ringer cr...@postnewspapers.com.au wrote: On 13/06/10 02:34, Adrian Klaver wrote: Question: Is it possible that there's corruption in the database which is being incorrectly reported as Permission denied? It's certainly not impossible. It'd really help if Pg would print more details from Windows' error reporting - GetLastError() etc - in cases like this. In fact, some searching reveals complaints about just that as far back as mid-2008 related to the exact error you're encountering. It does if you enable debug logging. DEBUG5 is required from what I can tell (see src/port/win32error.c, function _dosmaperr(), which is called from pgwin32_open()). In a lot of cases it maps straight over, but in the cases where we have to map to an errno value and use that, there can be more than one. In the case of access denied, it can be: ERROR_ACCESS_DENIED ERROR_CURRENT_DIRECTORY ERROR_LOCK_VIOLATION ERROR_SHARING_VIOLATION (but this is taken care of already in pgwin32_open) ERROR_NETWORK_ACCESS_DENIED ERROR_CANNOT_MAKE ERROR_FAIL_I24 ERROR_DRIVE_LOCKED ERROR_SEEK_ON_DEVICE ERROR_NOT_LOCKED ERROR_LOCK_FAILED Most of these can't (shouldn't be possible at least) appear when we're opening a file for reading. But it'd be interesting to know what they were. So it'd be interesting to see the output of this at DEBUG5 (there should be a line saying mapped win32 error code n to n showing up - there will be *tons* of other logging output of course) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] How to emulate password generation in PHP with PlpgSQL?
Hi, I need to create users in a database function. I'am dealing with a PHP application, the code that generate the password is this: [code] public function salt() { return substr(md5(uniqid(rand(), true)), 0, 10); } public function hash_password($password, $salt=false) { if (empty($password)) { return FALSE; } if (FALSE $salt) { return sha1($password . $salt); } else { $salt = $this-salt(); return $salt . substr(sha1($salt . $password), 0, -10); } } [/code] It is possible to emulate this in a PlpgSQL function? I have a function that generates the SHA1 codes [code] CREATE OR REPLACE FUNCTION sha1(bytea) returns text AS $$ SELECT encode(digest($1, 'sha1'), 'hex') $$ LANGUAGE SQL STRICT IMMUTABLE; [/code] But I'am not getting how to generate the SALT. Can someone give me a clue on how to do this. Best Regards,
[GENERAL] table partition or index
For how many records I should go for a table partition instead of using just index? Any idea please.
Re: [GENERAL] table partition or index
* AI Rumman (rumman...@gmail.com) wrote: For how many records I should go for a table partition instead of using just index? Any idea please. General rule of thumb is that you don't need partitioning until you're into the 100's of millions of records. Stephen signature.asc Description: Digital signature
[GENERAL] how to alias a table
I'm refactoring some code and I'll find helpful to be able to alias tables. What I'd like to do would be to refer to the same table with an alias in the code and later substitute the alias with an actual VIEW. Of course I could define a view as select * from original_table right from the start but I'm worried this may incur in some overhead I currently can't afford. thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] how to alias a table
Ivan Sergio Borgonovo m...@webthatworks.it wrote: I'm refactoring some code and I'll find helpful to be able to alias tables. What I'd like to do would be to refer to the same table with an alias in the code and later substitute the alias with an actual VIEW. Of course I could define a view as select * from original_table right from the start but I'm worried this may incur in some overhead I currently can't afford. Have you tried it? Tim -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Best way to store case-insensitive data?
Please don't top-post. Mike Christensen wrote: Ah, I should probably upgrade to 8.4. However, I'll probably just wait for 9.0 to come out. So it seems like citext will be about the same as casting both sides to LOWER(), plus putting an index on the lowercase version of the text. I'd probably use that if it were out of the box, but I'm trying to stay away from adding too many dependencies.. I think I'll stick with my original approach of only storing lowercase data in the DB, and perhaps put a CHECK constraint on there to ensure no upper case letters sneak in. If your db contains international text there are some corner cases where lower( upper( val )) != val or upper( lower( val )) != val. Or there should be, because that's what happens in certain languages. For example, upper-case 'ß' should be 'SS' in German. Lower-case 'SS' is 'ss'. -- Lew -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgcon 2010 videos?
On Jun 9, 3:45 pm, Aljosa Mohorovic aljosa.mohoro...@gmail.com wrote: i've found some videos of conference athttp://www.fosslc.org/drupal/category/event/pgcon2010 but some are missing. also, there is no mention of videos on pgcon page. anybody knows if missing videos will appear somewhere and why there is no links on pgcon site? Aljosa Mohorovic well! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] how to alias a table
On Jun 13, 10:07 am, m...@webthatworks.it (Ivan Sergio Borgonovo) wrote: I'm refactoring some code and I'll find helpful to be able to alias tables. What I'd like to do would be to refer to the same table with an alias in the code and later substitute the alias with an actual VIEW. Of course I could define a view as select * from original_table right from the start but I'm worried this may incur in some overhead I currently can't afford. thanks -- Ivan Sergio Borgonovohttp://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org) To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgcon 2010 videos?
On Jun 9, 3:45 pm, Aljosa Mohorovic aljosa.mohoro...@gmail.com wrote: i've found some videos of conference athttp://www.fosslc.org/drupal/category/event/pgcon2010 but some are missing. also, there is no mention of videos on pgcon page. anybody knows if missing videos will appear somewhere and why there is no links on pgcon site? Aljosa Mohorovic well! you could come to my home. thank you for emailing to me -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Partial indexes instead of partitions
On 11 June 2010 17:15, Leonardo F m_li...@yahoo.it wrote: Basically what I'm trying to do is to partition the index in the table where the data is going to be inserted into smaller indexes, but without using partitions: I would use partial indexes. Historic data will have just the big index... Well, you can estimate if it's worth bothering with index partitioning. For selects you should compare logM(N) N - number of records M - (base) number of records in b-tree node (in one 8k page) for whole table partition and index partition but I do not think the difference would be great. For inserts I do not see the reason why it would be better to use index partitioning because AFAIK b-tree would behave exactly the same in both cases. That is, the table where data will be inserted (ts will always be ascending, so I will always insert data in the latest table) will have multiple small indexes. Then, at night, the small indexes would be dropped after one big index has been created (since no more rows will be inserted in that table, I don't care if the index is big). So, a query like: select * from master where key1=938479 and ts between now() and now()-10 minutes You should explicitly state the index conditions and the partition conditions here otherwise they would not be used SELECT * FROM master WHERE -- For table partition ts = '2006-03-10' AND ts '2006-04-10' AND -- For index partition ts = '2006-03-10 01:00' AND ts '2006-03-10 02:00' AND -- Target conditions key1 = 938479 AND ts BETWEEN now() AND now() - interval '10 minutes'; Furthermore I would suggest you to use this index CREATE INDEX master_10_2_ix1 ON master_10 (key1, ts) WHERE ts = '2006-03-10 01:00' and ts '2006-03-10 02:00'; if you want Target conditions to work optimal way. a query like: select * from master where key1=938479 and ts between 3 days ago and 2 days ago You can not use BETWEEN here because it is equal to ts = ... AND ts = ... not ts = ... AND ts ... as specified in the table definition. See above. -- Sergey Konoplev Blog: http://gray-hemp.blogspot.com / Linkedin: http://ru.linkedin.com/in/grayhemp / JID/GTalk: gray...@gmail.com / Skype: gray-hemp / ICQ: 29353802 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Hosting without pgcrypto functions. There are other solutions?
Hi, I have an account in A2Hosting.com, and I'm developing some functions that deal with encryption. A2Hosting.com don't have available the function digest() [code] ERROR: function digest(unknown, unknown) does not exist LINE 1: select digest('', 'sha1') ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Indicação de entrada : select digest('', 'sha1') [/code] I need to compile a SHA1 function, but without the digest() function, nothing done... [code] CREATE OR REPLACE FUNCTION sha1(bytea) returns text AS $$ SELECT encode(digest($1, 'sha1'), 'hex') $$ LANGUAGE SQL STRICT IMMUTABLE; [/code] There is a way to get this job done without the digest() function? I need also to be able to do this select select substr(gen_salt('md5'), 0, 10) but there is no gen_salt() available... What is my best option? To change hosting account? There is some hosting accounts with this functions available in the Postgre? Best Regards,
Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied
I have information We had noticed two relations, their numbers being 16384/16642 and 16384/16792. Here is what pg_class has for them. relname;relnamespace;reltype;relowner;relam;relfilenode;reltablespace;relpages;reltuples;reltoastrelid;reltoastidxid;relhasindex;relisshared;relistemp;relkind;relnatts;relchecks;relhasoids;relhaspkey;relhasrules;relhastriggers;relhassubclass;relfrozenxid;relacl;reloptions pg_toast_16638;99;16643;16510;0;16642;0;0;0;0;16644;t;f;f;t;3;0;f;t;f;f;f;1581;; pg_toast_16788;99;16793;16510;0;16792;0;0;0;0;16794;t;f;f;t;3;0;f;t;f;f;f;2202;; We also looked at the permissions and whether the files actually exist. Findings: The files are both marked system file and have size 0 K. When logging on as an administrator and opening the files (eg with notepad, just to see if there is nothing at all) they appear to be empty. However, while we were working on the problem, pgadmin3 started reporting permission denied for 2611. At the same time, pgadmin was unable to see the columns of the tables. Attempting to do so is what caused the error for 2611. 2611 also appeared to be a system file with 0 bytes. Meantime, pgadmin was able to create a table and see the columns on the standard postgres database. Also, the Java application was able to see the columns and list them out as well. I have noticed that postgres is very unhappy if the proper postgres user doesn't have access to the files. But I have also noticed that other users seem to be able to have access without causing problems. I realize this compromises security, but in a development environment it is very convenient, eg when doing a system backup. Is it possible that some type of user might be causing files to be created as or changed to system files, marked read only, and apparently empty? I am not certain which users have access to the files at the client's site, but I know it's more than just the postgres user. All of these findings were on the second computer running XP. We ran out of time today before we investigated the original server to see if it also had system files marked read only with no apparent contents. John On Sun, 13 Jun 2010 11:51:45 +0200, Magnus Hagander wrote: On Sun, Jun 13, 2010 at 5:11 AM, Craig Ringer cr...@postnewspapers.com.au wrote: On 13/06/10 02:34, Adrian Klaver wrote: Question: Is it possible that there's corruption in the database which is being incorrectly reported as Permission denied? It's certainly not impossible. It'd really help if Pg would print more details from Windows' error reporting - GetLastError() etc - in cases like this. In fact, some searching reveals complaints about just that as far back as mid-2008 related to the exact error you're encountering. It does if you enable debug logging. DEBUG5 is required from what I can tell (see src/port/win32error.c, function _dosmaperr(), which is called from pgwin32_open()). In a lot of cases it maps straight over, but in the cases where we have to map to an errno value and use that, there can be more than one. In the case of access denied, it can be: ERROR_ACCESS_DENIED ERROR_CURRENT_DIRECTORY ERROR_LOCK_VIOLATION ERROR_SHARING_VIOLATION (but this is taken care of already in pgwin32_open) ERROR_NETWORK_ACCESS_DENIED ERROR_CANNOT_MAKE ERROR_FAIL_I24 ERROR_DRIVE_LOCKED ERROR_SEEK_ON_DEVICE ERROR_NOT_LOCKED ERROR_LOCK_FAILED Most of these can't (shouldn't be possible at least) appear when we're opening a file for reading. But it'd be interesting to know what they were. So it'd be interesting to see the output of this at DEBUG5 (there should be a line saying mapped win32 error code n to n showing up - there will be *tons* of other logging output of course) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied
John, I have noticed that postgres is very unhappy if the proper postgres user doesn't have access to the files. But I have also noticed that other users seem to be able to have access without causing problems. can you please give more information about the (windows)-user postgres ? is it a local user on that machine? How was that user created? Are there any group-policies or similar, or security-applications present, which can change the rights of this user postgres? (Or, can change the access-properties of files on the system?) Your sentenceabout postgres being unhappy when not having access to the files makes me curious how you did learn that --- was somebody / something taking file access away from Postgres? Could that somebody / something still be active? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - Using PostgreSQL is mostly about sleeping well at night.
Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied
On Sunday 13 June 2010 1:41:01 pm John T. Dow wrote: I have information We had noticed two relations, their numbers being 16384/16642 and 16384/16792. Here is what pg_class has for them. relname;relnamespace;reltype;relowner;relam;relfilenode;reltab lespace;relpages;reltuples;reltoastrelid;reltoastidxid;relhasindex ;relisshared;relistemp;relkind;relnatts;relchecks;relhasoids;r elhaspkey;relhasrules;relhastriggers;relhassubclass;relfrozenxid;r elacl;reloptions pg_toast_16638;99;16643;16510;0;16642;0;0;0;0;16644;t;f;f;t;3;0;f;t;f;f ;f;1581;; pg_toast_16788;99;16793;16510;0;16792;0;0;0;0;16794;t;f;f;t;3;0;f;t;f;f ;f;2202;; We also looked at the permissions and whether the files actually exist. Findings: The files are both marked system file and have size 0 K. When logging on as an administrator and opening the files (eg with notepad, just to see if there is nothing at all) they appear to be empty. Whose permissions do they have? However, while we were working on the problem, pgadmin3 started reporting permission denied for 2611. At the same time, pgadmin was unable to see the columns of the tables. Attempting to do so is what caused the error for 2611. 2611 also appeared to be a system file with 0 bytes. What does Postgres think it is? Another TOAST table? Meantime, pgadmin was able to create a table and see the columns on the standard postgres database. Now I am confused. What are you calling the standard Postgres database? Also, the Java application was able to see the columns and list them out as well. Of which database? I have noticed that postgres is very unhappy if the proper postgres user doesn't have access to the files. But I have also noticed that other users seem to be able to have access without causing problems. I realize this compromises security, but in a development environment it is very convenient, eg when doing a system backup. Sort of the purpose of permissions :) Is it possible that some type of user might be causing files to be created as or changed to system files, marked read only, and apparently empty? It would seem so. The question is whether this a historical artifact from corruption in the past or is ongoing? I am not certain which users have access to the files at the client's site, but I know it's more than just the postgres user. All of these findings were on the second computer running XP. We ran out of time today before we investigated the original server to see if it also had system files marked read only with no apparent contents. John -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied
can you please give more information about the (windows)-user postgres ? is it a local user on that machine? How was that user created? It's the user created by the one-click installer. I believe it owns the postgres data directory and is used to start the server. Other than that, the intention is for this user to have no other file privileges. The default is postgres but it could be anything. Are there any group-policies or similar, or security-applications present, which can change the rights of this user postgres? (Or, can change the access-properties of files on the system?) I don't know. It is not my computer, it is my client's computer. We will investigate if anything like that is going on. He was only available until 4PM today and we just discovered what was happening shortly before that point. The people that do their security should be available Monday and we can ask them this type of question. Any idea of what to look for? Your sentenceabout postgres being unhappy when not having access to the files makes me curious how you did learn that --- was somebody / something taking file access away from Postgres? Could that somebody / something still be active? That somebody was me, experimenting over the years. But I have not been messing around with this particular application. However, I'm not sure what the client did, as they copied the data files between the two computers at a time when I wasn't available. (They zipped, then unzipped after logging in as the proper user.) As a developer for multiple clients, I need easy access to my development copies of my clients' postgres data files. Therefore I have experimented with allowing my own userid to have access to the data directory and the subdirectories and files. I believe postgres doesn't care if you allow extra users, as long as postgres still has the proper access. John Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger StraAYe 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - Using PostgreSQL is mostly about sleeping well at night. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to show the current schema or search path in the psql PROMP
Right now I added two simple wrappers in my .psqlrc \set shsh 'SHOW search_path;' \set setsh 'SET search_path TO' So I can at least set and check the schema more quickly. But seeing it in the PROMPT would be th best. On Sat, Jun 12, 2010 at 05:26, Scott Marlowe scott.marl...@gmail.com wrote: On Fri, Jun 11, 2010 at 2:18 PM, Tom Lane t...@sss.pgh.pa.us wrote: Scott Marlowe scott.marl...@gmail.com writes: But that runs a shell command, how's that supposed to get the search_path? I've been trying to think up a solution to that and can't come up with one. Yeah, and you do *not* want the prompt mechanism trying to send SQL commands... Would a more generic way to access pgsql settings in a \set prompt be useful? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- ★ Clemens 呉 Schwaighofer ★ IT Engineer/Web Producer/Planning ★ E-Graphics Communications SP Digital ★ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ★ Tel: +81-(0)3-3545-7706 ★ Fax: +81-(0)3-3545-7343 ★ http://www.e-gra.co.jp This e-mail is intended only for the named person or entity to which it is addressed and contains valuable business information that is privileged, confidential and/or otherwise protected from disclosure. If you received this e-mail in error, any review, use, dissemination, distribution or copying of this e-mail is strictly prohibited. Please notify us immediately of the error via e-mail to disclai...@tbwaworld.com and please delete the e-mail from your system, retaining no copies in any media. We appreciate your cooperation. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied
I was talking to a friend (Joe Newcomer) who said that Unix doesn't have mandatory file locks and he guessed that the empty, system, read only files I saw at my client's site were unix-like lock files. To test that, on my home development computer I typed this command in the base\16384 diretory: attrib +r 2611 That is, I made 2611 read only. Sure enough, pgadmin can't display the columns for any of the tables. I get permission denied for 2611. And sure enough, the Java application runs fine and indeed is able to export the table definition, complete with columns. So this is exactly the behavior observed at my client's site. Apparently the problem boils down to this question: how did some of the files get set to be system and read only? Anybody ever seen this? Perhaps it's not even a postgres question. We will investigate further Monday when people are in the office. Any thoughts from anybody would be appreciated. Reminder: the problem with 2611 was observed on the second computer, which runs XP Pro 2002 SP3. The problems pasting 50K of text was first observed on the first computer, running 2000 Server if I remember right. It does not therefore seem to be related to AV software (the original suggestion) or the OS. John On Sun, 13 Jun 2010 14:10:27 -0700, Adrian Klaver wrote: On Sunday 13 June 2010 1:41:01 pm John T. Dow wrote: I have information We had noticed two relations, their numbers being 16384/16642 and 16384/16792. Here is what pg_class has for them. relname;relnamespace;reltype;relowner;relam;relfilenode;reltab lespace;relpages;reltuples;reltoastrelid;reltoastidxid;relhasindex ;relisshared;relistemp;relkind;relnatts;relchecks;relhasoids;r elhaspkey;relhasrules;relhastriggers;relhassubclass;relfrozenxid;r elacl;reloptions pg_toast_16638;99;16643;16510;0;16642;0;0;0;0;16644;t;f;f;t;3;0;f;t;f;f ;f;1581;; pg_toast_16788;99;16793;16510;0;16792;0;0;0;0;16794;t;f;f;t;3;0;f;t;f;f ;f;2202;; We also looked at the permissions and whether the files actually exist. Findings: The files are both marked system file and have size 0 K. When logging on as an administrator and opening the files (eg with notepad, just to see if there is nothing at all) they appear to be empty. Whose permissions do they have? However, while we were working on the problem, pgadmin3 started reporting permission denied for 2611. At the same time, pgadmin was unable to see the columns of the tables. Attempting to do so is what caused the error for 2611. 2611 also appeared to be a system file with 0 bytes. What does Postgres think it is? Another TOAST table? Meantime, pgadmin was able to create a table and see the columns on the standard postgres database. Now I am confused. What are you calling the standard Postgres database? Also, the Java application was able to see the columns and list them out as well. Of which database? I have noticed that postgres is very unhappy if the proper postgres user doesn't have access to the files. But I have also noticed that other users seem to be able to have access without causing problems. I realize this compromises security, but in a development environment it is very convenient, eg when doing a system backup. Sort of the purpose of permissions :) Is it possible that some type of user might be causing files to be created as or changed to system files, marked read only, and apparently empty? It would seem so. The question is whether this a historical artifact from corruption in the past or is ongoing? I am not certain which users have access to the files at the client's site, but I know it's more than just the postgres user. All of these findings were on the second computer running XP. We ran out of time today before we investigated the original server to see if it also had system files marked read only with no apparent contents. John -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Unable to (re) start PostgreSQL 8.4.4/WinXP
I have PostgreSQL 8.4.4 on Windows XP. I cannot get the service to (re) start. At first installation, the service started up fine, but I couldn't access the DB remotely. So I changed the pg_hba.conf file and the postgresql.conf file as suggested. Now, the service seems to take forever to start up (appears to hang), then dies with the message: The postgresql-8.4-PostgreSQL Server 8.4 service on Local Computer started and then stopped. Some services start automatically if they have no work to do, for example, the Performance Logs and Alerts service. My pg_hba.conf file has the following line: host all all 192.168.0.1/24 trust If I remove the line, the server starts up instantly. If I restore the line, the server takes for ever to start-up and ends up with the same error in this thread. My listen_addresses value is set to '*'. The postgres user already has full permissions on all the folders, including data and pg_log. Any suggestions? Thanks in advance. -- View this message in context: http://old.nabble.com/Unable-to-%28re%29-start-PostgreSQL-8.4.4-WinXP-tp28875697p28875697.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Unable to (re) start PostgreSQL 8.4.4/WinXP
kunalashar wrote: I have PostgreSQL 8.4.4 on Windows XP. I cannot get the service to (re) start. At first installation, the service started up fine, but I couldn't access the DB remotely. So I changed the pg_hba.conf file and the postgresql.conf file as suggested. Now, the service seems to take forever to start up (appears to hang), then dies with the message: The postgresql-8.4-PostgreSQL Server 8.4 service on Local Computer started and then stopped. Some services start automatically if they have no work to do, for example, the Performance Logs and Alerts service. My pg_hba.conf file has the following line: host all all 192.168.0.1/24 trust If I remove the line, the server starts up instantly. If I restore the line, the server takes for ever to start-up and ends up with the same error in this thread. My listen_addresses value is set to '*'. The postgres user already has full permissions on all the folders, including data and pg_log. any errors in the latest file in pg_log ? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general