Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gUbI8-0007fZ-Ov for pgsql-admin@arkaria.postgresql.org; Wed, 05 Dec 2018 17:48:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gUbI6-00044Q-9O for pgsql-admin@arkaria.postgresql.org; Wed, 05 Dec 2018 17:48:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gUbI6-00044J-06 for pgsql-admin@lists.postgresql.org; Wed, 05 Dec 2018 17:48:54 +0000 Received: from mail-oi1-x244.google.com ([2607:f8b0:4864:20::244]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gUbI3-0005w6-Gv for pgsql-admin@lists.postgresql.org; Wed, 05 Dec 2018 17:48:53 +0000 Received: by mail-oi1-x244.google.com with SMTP id x202so18250012oif.13 for ; Wed, 05 Dec 2018 09:48:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=KtD8tXKt1AVnXccV6mKhpRdUTf0m/lcmdMcPb7gDNHg=; b=QnKOVwcMEBo92i2oUcd9uAUZys+oIDs8l1qX+hLxlpg52c4qqGLZkxa1RClmGORo+v 1O5tcgptbSV/2FBye+HDgEbRkXVBRz3hOveplNxsEdHMceZlT8seQoc+aa1l1TilC6e6 l8tcX1BD2WTXN3MjRHP1C5YT+ECecMO7tIZmQSuMH4YMP5xF+G2RJIPaHSBbCu5arIZ8 4R1ItLb0SFM5gXwTGKpYbfxCh5Kx1INPQZ2ImQ0J4rDNeSU/wHhF0z2pVpNZ0Nx2hfK6 8iDwS8lkAhmzSPpiTeKrBQG8KY7MUUjAqNAaM8tx4aeo+KoO6S1UDPAlvyWvTapdKNfR j8nQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=KtD8tXKt1AVnXccV6mKhpRdUTf0m/lcmdMcPb7gDNHg=; b=AALmriH7ZXbL3DPmRH2lL84t96CwFxVZiqyZlQHEkdamk40vWlUY88KUec9xgawQst v4pBi6DNoGmKpyovjfkHfEf04JHO6Rf8NLFtpVhF+xMMhkB1iNeQR4FhbdcX3egEsGHy HgUMYz5VVRqNdJNgmLQA0iMrhi8Bk9wSr50ihxdV0Fbge5vD8RpCZ/z21YvrftXOjtps HCfX/sou5ebj+SM8T7wEeH1q9ScDBRnEPRw3r66VNM8LnDLRx06ndQMbr3RyjYrNlJJy P6LvRZZgfun5nH8X9kc7WwwCXuI+YtfN1kf30R7/8sDBJNm4zhk9VShFJ9BnVMfQnRKV FE9A== X-Gm-Message-State: AA+aEWZysczEn5hE4nG9yNQeJvjRQzP1cfdYOk6xkiT3nmaDmjMgcqWX RTYR1hQZAQevG6tIH2/sB7jrSDQM X-Google-Smtp-Source: AFSGD/WeZFD28i8d/Pb2GrGM3i4W5Vhh4Fm/pzaK0VyjaGKiS6F4FwvBtKWsl9DcR6/eZKAGYXufYA== X-Received: by 2002:aca:357:: with SMTP id 84mr15648710oid.12.1544032128681; Wed, 05 Dec 2018 09:48:48 -0800 (PST) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id w62sm7799349oiw.34.2018.12.05.09.48.47 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 05 Dec 2018 09:48:47 -0800 (PST) Subject: Re: DB Creations/ Drop DB :: Not working... To: pgsql-admin@lists.postgresql.org References: <2A91BEF8171A5349931391E0C721CC53093B7C45@CPEMS-KPN501.KPNCNL.LOCAL> <6144.1544030946@sss.pgh.pa.us> From: Ron Message-ID: <277c80dc-6224-5a8f-d360-2059a99b6d5c@gmail.com> Date: Wed, 5 Dec 2018 11:48:47 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <6144.1544030946@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 12/05/2018 11:29 AM, Tom Lane wrote: > writes: >> postgres=# CREATE DATABASE symuatdb >> postgres-# WITH >> postgres-# OWNER = postgres >> postgres-# ENCODING = 'UTF8' >> postgres-# LC_COLLATE = 'en_US.utf8' >> postgres-# LC_CTYPE = 'en_US.utf8' >> postgres-# TABLESPACE = sym_m_data1 >> postgres-# CONNECTION LIMIT = 10; >> ERROR: could not create directory "pg_tblspc/16386/PG_10_201707211/24576": No such file or directory > It looks like somebody's deleted the directory your tablespace sym_m_data1 > is pointing at. $PGDATA/pg_tblspc? -- Angular momentum makes the world go 'round.