I guess you need to quote the identifier, as you use mixed case. I.e. try "myDB" with the double quotes.
Tomas
Dne 2. 5. 2014 2:49 Prashanth Kumar napsal(a):
Hi,Do not seem to figure out what is wrong here. Why am I getting database does not exist. I just created the database and am able to co
Seems you're using /run/shm and /var/run/shm by mistake.
Tomas
basti napsal/a:
>Hello,
>
>since I have enabled "stats_temp_directory = '/run/shm'" in
>/etc/postgresql/9.1/main/postgresql.conf I get the following error:
>
>2014-04-21 02:37:29 CEST LOG: could not rename temporary statistics
>file
> Sometimes per week server stops randomly responding for approx 5 minutes.
> User should wait for 5 minutes before server responds.
> Other users can work normally at same time.
So does the whole machine just stop responding, or just the postgresql?
Are those other users using postgresql or some
> On Tue, Jul 5, 2011 at 10:38, Condor wrote:
>> Hello,
>> any one can explain me why I have difference between db size when I dump
>> db,
>> I see it's 5G and when I run SELECT
>> pg_size_pretty(pg_database_size('somedatabase')) As fulldbsize; on my DB
>> postgresql return: 10 GB
>>
>> I run vacu
Try to one of these:
a) don't use INSERT statements, use a COPY instead
b) from time to time run ANALYZE on the "public" table (say 1000
inserts, then one analyze)
c) create the table without constraints (primary / foreign keys in this
case), import all the data, and then create the const
Hi,
I have records with date column. Is there a way I can get which day of
week this date is?
http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
t.v.
---(end of broadcast)---
TIP 4: Have you search