On my machine:

```
C:\Program Files\PostgreSQL\8.4\data\postgresql.conf
```

`postgresql.conf` is located **in PostgreSQL&#39;s data directory**. The data directory is configured during the setup and the setting is saved as `PGDATA` entry in `c:\Program Files\PostgreSQL\&lt;version&gt;\pg_env.bat`, for example

    @ECHO OFF
    REM The script sets environment variables helpful for PostgreSQL
    
    @SET PATH=&quot;C:\Program Files\PostgreSQL\&lt;version&gt;\bin&quot;;%PATH%
    @SET PGDATA=D:\PostgreSQL\&lt;version&gt;\data
    @SET PGDATABASE=postgres
    @SET PGUSER=postgres
    @SET PGPORT=5432
    @SET PGLOCALEDIR=C:\Program Files\PostgreSQL\&lt;version&gt;\share\locale

Alternatively you can query your database with `SHOW config_file;` if you are a superuser.


You can find it by  following this path

```
C:\Program Files\PostgreSQL\13\data
```

On  my machine:
 
    C:\Program Files (x86)\OpenERP 6.1-20121026-233219\PostgreSQL\data

you will get postgressql.conf file 

C:/programfiles/postgressql/14/data
you will also get the pg_hba to check username password

I have following code, but why is the `ProcessExited` method never called? It is the same if I don&#39;t a use Windows shell (`startInfo.UseShellExecute = false`).

    ProcessStartInfo startInfo = new ProcessStartInfo();
    startInfo.CreateNoWindow = true;
    startInfo.UseShellExecute = true;
    startInfo.WindowStyle = ProcessWindowStyle.Hidden;
    startInfo.FileName = path;
    startInfo.Arguments = rawDataFileName;
    startInfo.WorkingDirectory = Util.GetParentDirectory(path, 1);
    
    try
    {
         Process correctionProcess = Process.Start(startInfo);
         correctionProcess.Exited += new EventHandler(ProcessExited);                   
                    
         correctionProcess.WaitForExit();
    
         status = true;
    }
           

.....
 
    internal void ProcessExited(object sender, System.EventArgs e)
    {
          //print out here
    }

Why is my process&#39;s Exited method not being called?

I&#39;ve created a sqlite database programmatically with the default way of extending `SQLiteOpenHelper` and overriding `onCreate()`. This way the db gets created on the fly when needed.

I&#39;d like to check the contents of the db file on my OS X machine with a sqlite browser.
I know the name of the db file, but I can&#39;t find it on the device. I&#39;ve connected to the device via USB and looked with finder and terminal, but I just can&#39;t find the db file. 

What is the default location for a sqlite databases on an android device?

Location of sqlite database on the device

I&#39;m receiving this message but I can&#39;t find the `postgresql.conf` file:

    OperationalError: could not connect to server: Connection refused (0x0000274D/10061)
    	Is the server running on host &quot;???&quot; and accepting
    	TCP/IP connections on port 5432?
    could not connect to server: Connection refused (0x0000274D/10061)
    	Is the server running on host &quot;???&quot; and accepting
    	TCP/IP connections on port 5432?



Where is the Postgresql config file: &#39;postgresql.conf&#39; on Windows?

I'm receiving this message but I can't find the <code>postgresql.conf</code> file:
<pre><code class="hljs language-vbnet">OperationalError: could not connect to server: Connection refused (0x0000274D/10061)
	Is the server running on host "???" and accepting
	TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
	Is the server running on host "???" and accepting
	TCP/IP connections on port 5432?
</code></pre>

What is the difference between user variables such as `PATH`, `TMP`, etc. and system variables?

I accidentally deleted the user variable `PATH`. What am I supposed to do?

What is the difference between user variables and system variables?

I downloaded PostgreSQL from their site - http://www.postgresql.org/download/windows

However, I can&#39;t create a database from **pgAdmin** and get a message:

&gt; could not connect to server:
&gt; Connection refused (0x0000274D/10061)
&gt; Is the server running on host
&gt; &quot;localhost&quot; and accepting TCP/IP
&gt; connections on port 5432? could not
&gt; connect to server: Connection refused
&gt; (0x0000274D/10061) Is the server
&gt; running on host &quot;localhost&quot; and
&gt; accepting TCP/IP connections on port
&gt; 5432?

 Do I have to create a windows service? How is it called? Do I have to install it separately?

**EDITED**

Let me explain myself. I am trying to run the service. I tried running postgres.exe from the command line but still it does not run.

What could run the database?

**EDITED**

The problem was with my installation file. I downloaded it again - and it worked well!

PostgreSQL database service

&lt;!-- language-all: lang-none --&gt;

I have an installation of Git for Windows, but when I try to use the `git` command in Command Prompt, I get the following error:

    &#39;git&#39; is not recognized as an internal or external command,
    operable program or batch file. 

How do I fix this problem?

&#39;git&#39; is not recognized as an internal or external command

I often see files named &#39;blabla.exe:Zone.Identifier&#39; when monitoring I/O with Process Monitor.  
The files are seen on network-drives.

![alt text][1]

- What are `Zone.Identifier` files?
- What does the colon mean in the filename?
- Is the colon related the file&#39;s extended attributes?
- How do I prevent these files from being created when I copy code files from Windows Explorer to a WSL directory?


  [1]: http://i.stack.imgur.com/92l8S.png

What are `Zone.Identifier` files, and how do I prevent them from being created?

I am reading about exception handling. I got some information about what exception handling is, but I have a few questions:

1. When to throw an exception?
2. Instead of throwing an exception, can we use a return value to indicate the error?
3. If I protect all my functions by try-catch blocks, won&#39;t it reduce the performance?
4. When to use exception handling?
5. I saw a project where each and every function in that project contained a try-catch block (i.e. code inside the entire function is surrounded by try-catch block). Is this a good practice?
6. What is the difference between try-catch and __try __except?


When and how should I use exception handling?

I have a query that looks like the following:

`SELECT * FROM table WHERE timestamp = NULL;`

The timestamp column is a timestamp with time zone data type (second type in [this][1] table). This is in PostgreSQL 8.4.

What I&#39;m trying to accomplish is to only select rows that have not had a timestamp inserted. When I look at the data in pgAdmin the field is empty and shows no value. I&#39;ve tried where timestamp = `NULL`, `&#39;EPOCH&#39;` (which you would think would be the default value), a valid timestamp of zeros (`0000-00-00 00:00:00-00`, which results in a out of range error), the lowest date possible according to the docs (`January 1, 4713 BC`) and a blank string (`&#39;&#39;`, which just gets a data type mismatch error). There also appears to be no `is_timestamp()` function that I can use to check if the result is not a valid timestamp.

So, the question is, what value is in that empty field that I can check for?

Thanks.

EDIT: The field does not have a default value.


  [1]: http://www.postgresql.org/docs/8.4/static/datatype-datetime.html#DATATYPE-DATETIME-TABLE

PostgreSQL: Select where timestamp is empty

Is there a way to specify that when executing a sql script it stops when encountering the first error on the script, it usually continues, regardless of previous errors.


How can I stop a Postgres script when it encounters an error?

Is there a simple ignore-case-comparison for PostgreSQL?

I want to replace:

    SELECT id, user_name 
        FROM users 
            WHERE lower(email) IN (lower(&#39;adamB@a.com&#39;), lower(&#39;eveA@b.com&#39;));

With something like:

    SELECT id, user_name 
        FROM users 
            WHERE email IGNORE_CASE_IN (&#39;adamB@a.com&#39;, &#39;eveA@b.com&#39;);

The `like` and `ilike` operators work on single values (e.g. `like &#39;adamB@a.com&#39;`), but not on sets.

PostgreSQL: Case insensitive string comparison

I need to connect to some PostgreSQL server providing some credentials, and print a list of available databases on that host for a given user.

I am trying:

    &lt;?php
        $connection = pg_connect(&quot;host=localhost user=testuser password=123 connect_timeout=5&quot;);
    ?&gt;

And I get:

    Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: database &quot;testuser&quot; does not exist in /var/www/test.php on line 56

I thought this must be possible because phpPgAdmin does it, but I looked at phpPpAdmin sources and found that they connect to a database named `template1`.

From http://www.postgresql.org/docs/8.1/interactive/manage-ag-templatedbs.html:

&gt; CREATE DATABASE actually works by copying an existing database. By
&gt; default, it copies the standard system database named template1. Thus
&gt; that database is the &quot;template&quot; from which new databases are made. If
&gt; you add objects to template1, these objects will be copied into
&gt; subsequently created user databases. This behavior allows site-local
&gt; modifications to the standard set of objects in databases. For
&gt; example, if you install the procedural language PL/pgSQL in template1,
&gt; it will automatically be available in user databases without any extra
&gt; action being taken when those databases are made.

Is there a way to connect without specifying any database?

Content Type	Original Author	Original Content on Stackoverflow
Question	pythondjango	View Question on Stackoverflow
Solution 1 - Windows	jonescb	View Answer on Stackoverflow
Solution 2 - Windows	splash	View Answer on Stackoverflow
Solution 3 - Windows	Boris Kamtou	View Answer on Stackoverflow
Solution 4 - Windows	Justi	View Answer on Stackoverflow
Solution 5 - Windows	Shilpa Jayant Patil	View Answer on Stackoverflow

Where is the Postgresql config file: 'postgresql.conf' on Windows?

Windows Problem Overview

Windows Solutions

Solution 1 - Windows

Solution 2 - Windows

Solution 3 - Windows

Solution 4 - Windows

Solution 5 - Windows

Location of sqlite database on the device

Why is my process's Exited method not being called?

Attributions