Thanks Alvaro for your suggestion !!
Regards,
Sachin Srivastava
Mb.: 9811149139
On Sun, Feb 19, 2017 at 11:40 AM, Alvaro Aguayo Garcia-Rada <
aagu...@opensysperu.com> wrote:
> Cleaning pg_log should be enough to be able to start your postgres
> instance. However, it will let you with almost no
Cleaning pg_log should be enough to be able to start your postgres instance.
However, it will let you with almost no space for your database to grow. If you
have some tables with information you can delete, that can free up space.
Unless most of your database information is "volatile"(case in wh
With correction: pg_log consumed 897 MB only
Regards,
Sachin Srivastava
Mb.: 9811149139
On Sun, Feb 19, 2017 at 11:32 AM, Sachin Srivastava wrote:
> I have checked pg_log only 890 GB space consumed and pg_log folder
> consumed 1.1 GB only. All the space consumed by the database file only.
>
I have checked pg_log only 890 GB space consumed and pg_log folder consumed
1.1 GB only. All the space consumed by the database file only.
-bash-4.2$ du -h
0 ./pg_xlog/archive_status
1.1G./pg_xlog
712K./global
47M ./pg_clog
0 ./pg_commit_ts
0 ./pg_dynshmem
0 .
Cleanup some space on that device. Maybe your "pg_log" folder has some space to
free. If that doesn't helps, you may need to forcefully add more space. There's
not really much alternatives there.
Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.
Oficina: (+51-1) 3377813 | RPM: #03425
Dear Expert,
My PostgreSQL database got down due to no space left on my mount point
/dev/vdb1 where my data directory are available, please suggest what's the
best solution to resolve this issue. I am also not able to start my
database again due to no space available. And right now, we don't have
Rui Pacheco writes:
> I’m trying to send a Parse message with the name “my_name” and the statement
> “select * from departments” and no type id’s, along with a flush message:
> 'P','\0','\0','\0','(','m','y','_','n','a','m','e','\0','s','e','l','e','c','t','
> ','*',' ','f','r','o','m','
> ','d
I’m trying to send a Parse message with the name “my_name” and the statement
“select * from departments” and no type id’s, along with a flush message:
'P','\0','\0','\0','(','m','y','_','n','a','m','e','\0','s','e','l','e','c','t','
','*',' ','f','r','o','m','
','d','e','p','a','r','t','m','e',
On 02/18/2017 10:01 PM, Nikolay Petrov wrote:
Hot standby server was started with new recovery.conf, reached
consistent recovery state and resumed to restore WAL segments from
archive. When couple of next wal segments became unavailable slave
server just "skipped" them, instead to start streaming
Hello everyone.
I use postgresql 9.6.1 running under a debian 8 (master - slave hot standby
streaming replication).
I found out unexpected WAL-archive restore behaviour.
master:
wal_level = replica
archive_mode = on
archive_command = 'gzip < %p > /var/lib/postgres/archives/%f'
slave
On Sat, Feb 18, 2017 at 9:33 AM, Egon Frerich wrote:
> I have a table with two columns with type money. If column 'a' has an
> amount > 0 then this amount is wanted else the amount from column 'b'.
https://www.postgresql.org/docs/9.6/static/functions-conditional.html
SELECT CASE WHEN a > 0 TH
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a table with two columns with type money. If column 'a' has an
amount > 0 then this amount is wanted else the amount from column 'b'.
How could I do this?
Thanks.
Egon
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.22 (GNU/Linux)
iQIcB
On 02/17/2017 11:54 PM, Michael Paquier wrote:
On Sat, Feb 18, 2017 at 1:32 PM, Scott Marlowe wrote:
Yes it can. Truncate has been rollbackable for a while now.
Per the docs:
https://www.postgresql.org/docs/9.6/static/sql-truncate.html
"TRUNCATE is transaction-safe with respect to the data in
13 matches
Mail list logo
