pg_ctl: no database directory specified and environment variable PGDATA unset

You need to specify where the database directory is installed to.

eg

pg_ctl restart -D [insert directory location here]

Failing that you will need to set the environment variable PGDATA. Something like

 set $PGDATA = [directory location here]

Related Posts:

  1. missing FROM-clause entry for table
  2. Insert text with single quotes in PostgreSQL
  3. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  4. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  5. Postgresql tables exists, but getting “relation does not exist” when querying
  6. postgresql: error duplicate key value violates unique constraint
  7. Postgres Error: More than one row returned by a subquery used as an expression
  8. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  9. PostgreSQL create table if not exists
  10. updating table rows in postgres using subquery
  11. PostgreSQL visual interface similar to phpMyAdmin?
  12. GROUP BY and COUNT using ActiveRecord
  13. Postgresql column reference “id” is ambiguous
  14. What is a postgres superuser
  15. What’s the best way to search for a UPC code in a Database?
  16. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  17. SQL WITH clause example [duplicate]
  18. The wait operation timed out. ASP
  19. What is SELF JOIN and when would you use it? [duplicate]
  20. How do I UPDATE from a SELECT in SQL Server?
  21. SQL query to select dates between two dates
  22. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  23. Online SQL Query Syntax Checker
  24. Must declare the scalar variable
  25. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  26. MySQL query String contains
  27. IDENTITY_INSERT is set to OFF – How to turn it ON?
  28. How to reset AUTO_INCREMENT in MySQL
  29. mysql Foreign key constraint is incorrectly formed error
  30. Can a foreign key be NULL and/or duplicate?
  31. Why does NULL = NULL evaluate to false in SQL server
  32. How do composite indexes work?
  33. Difference between one-to-many and many-to-one relationship
  34. MySQL “WITH” clause
  35. Error Code: 2013. Lost connection to MySQL server during query
  36. Sql query – getting rid of hard-coded values
  37. ORA-00918: column ambiguously defined in SELECT *
  38. ORA-00918: column ambiguously defined in SELECT *
  39. How To Run A Github Repository?
  40. How do I format date and time on ssrs report?
  41. SQL Switch/Case in ‘where’ clause
  42. How to run a SQL query on an Excel table?
  43. MySQL Error 1264: out of range value for column
  44. SQL Server reports ‘Invalid column name’, but the column is present and the query works through management studio
  45. How to parse XML data in SQL server table
  46. Remote table-Valued Function Calls are not allowed
  47. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  48. Sql query to insert datetime in SQL Server
  49. Difference between View and table in sql
  50. Exclude a column using SELECT * [except columnA] FROM tableA?
  51. Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
  52. SQL selecting rows by most recent date with two unique columns
  53. Why is SQL server throwing this error: Cannot insert the value NULL into column ‘id’?
  54. ERROR 1148: The used command is not allowed with this MySQL version
  55. Bulk load data conversion error (truncation)
  56. How to order by with union in SQL?
  57. Difference between INNER JOIN and LEFT SEMI JOIN
  58. SQL conditional SELECT
  59. ‘CREATE PROCEDURE’ must be the only statement in the batch (Erro)
  60. DATEDIFF function in Oracle
  61. Solutions for INSERT OR UPDATE on SQL Server
  62. MySQL – Get row number on select
  63. MySQL error: Unknown column in ‘where clause’
  64. What is the difference between Views and Materialized Views in Oracle?
  65. How to truncate the text returned for a column in a MySQL query
  66. “select * into table” Will it work for inserting data into existing table
  67. ORA-01735: invalid ALTER TABLE option – Toad
  68. CASE IN statement with multiple values
  69. List of special characters for SQL LIKE clause
  70. Use wpdb->prepare for `order by` column name
  71. How To Write An Inner Join With WP Query
  72. Cron While Editing Post
  73. Update user_login, user_nicename, and display_name
  74. Change sticky status of posts from phpMyAdmin
  75. How to import a Typo3 database to a wordpress site?
  76. find pods item where relationship to other pod is not set
  77. Export SQL query based on post type
  78. Convert a category of posts to a custom post type using (MySQL) queries
  79. Connect to Ms SQL Server
  80. Clean up very big and very dirty database
  81. wpdb prepare sql problem
  82. How can I convert everything from category X to have post format Link
  83. Can Anyone provide an example of RAW SQL for SELECTING posts by 2 or more tags
  84. REGEXP_REPLACE in post_contet
  85. Bulk delete WordPress Post and all metadata, etc using SQL query
  86. Menu Order updating automatically
  87. How delete post_content records of specific category from phpmyadmin
  88. Reset post IDs with all post meta
  89. Fastest way to display 5000 post titles?
  90. Why does DROP TABLE-ing the `wp_options` reset my user session?
  91. How do I display SQL query on a specific page of my wordpress site
  92. How to refactor DB queries for better TTFB in WordPress?
  93. query sql-table and change entities
  94. Is it possible to utilize custom SQL for a single-post.php?
  95. How to handle my row actions on a custom list table in the admin section
  96. Backtick (MySQL norm) added to SQL Server Query causing error
  97. How can I avoid duplicate primary keys in SQL import?
  98. How to get the sum of each post with the same date
  99. How to dump a Microsoft SQL Server database to a SQL script?
  100. Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?

Leave a Comment

tech