Re: [GENERAL] Would you add a --dry-run to pg_restore?

I imagine pg_restore can execute the instructions on dump but don't write on disk. just like David said: "tell me what is going to happen but don't actually do it" Regards. On Wed, Aug 2, 2017 at 11:49 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Edmundo Robles &l

[GENERAL] Would you add a --dry-run to pg_restore?

I mean, to verify the integrity of backup i do: gunzip -c backup_yesterday.gz | pg_restore -d my_database && echo "backup_yesterday is OK" but my_database's size, uncompresed, is too big more than 15G and sometimes i have no space to restore it, so always i must declutter my disk

[GENERAL] I can't cancel/terminate query.

Hi! i have many too long time queries, the oldest is almost 16 days, so i tried to cancel and terminate with pg_cancel_backend and pg_terminate_backend but queries is still running. STIME ELAPSED ELAPSED %CPU PID COMMAND jun27 15-23:05:46 1379146 0.3 29660 postgres: argos_admin

[GENERAL] changing type of column on partitionated table.

Hi ! I have Postgresql 9.4, a partitionated table and i must change the type of column. The changes over a master table DDL are applied to the childs? or must I change the inheritance to off and change it one by one? for each child and master table. what is the best way/practice

Re: [GENERAL] Another windowed function with different values.

this issue was raised by timezone settings ... On Wed, Feb 1, 2017 at 10:15 AM, Edmundo Robles <edmu...@sw-argos.com> wrote: > i just changed the jdbc, but still get the wrong values... > > On Wed, Feb 1, 2017 at 9:47 AM, Edmundo Robles <edmu...@sw-argos.com> > wrote

[GENERAL] Another windowed function with different values.

I have postgresql 9.4 and wrote a function get_ignition_time() to get the first time when a car was ignition on and the last time when ignition is off, those time stamps are used in another function get_fuel_consumption() to get the fuel consumption. The issue is when: 1. I run

Re: [GENERAL] Another windowed function with different values.

this issues could be raised by a incorrect jdbc? the jdbc used is postrgresql-9.2-1002.jdbc4.jar and i have a postgresql 9.4 On Wed, Feb 1, 2017 at 9:35 AM, Edmundo Robles <edmu...@sw-argos.com> wrote: > > I have postgresql 9.4 and wrote a function get_ignition_time() to get

Re: [GENERAL] Another windowed function with different values.

i just changed the jdbc, but still get the wrong values... On Wed, Feb 1, 2017 at 9:47 AM, Edmundo Robles <edmu...@sw-argos.com> wrote: > this issues could be raised by a incorrect jdbc? the jdbc used is > postrgresql-9.2-1002.jdbc4.jar and i have a postgresql 9.4 > > O

Re: [GENERAL] recovery dump on database with different timezone

thanks for your comments, i will change the constraints from date to timestamp with time zone, i hope this works :) On Mon, Jan 23, 2017 at 7:48 PM, Tom Lane wrote: > Adrian Klaver writes: > > On 01/23/2017 05:14 PM, David G. Johnston wrote: > >>

Re: [GENERAL] recovery dump on database with different timezone

On Mon, Jan 23, 2017 at 6:02 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 01/23/2017 03:45 PM, Edmundo Robles wrote: > >> Hi! >> >> I have backed up a database with a 'UTC' timezone, but i can not to >> restore it on a database with 'localtime'

[GENERAL] recovery dump on database with different timezone

Hi! I have backed up a database with a 'UTC' timezone, but i can not to restore it on a database with 'localtime' timezone. I have a time constraints, the reason of the mistakes. * First, I did: 'alter database set timezone='UTC'; 'but no restore it... * After I did change

Re: [GENERAL] i got a process holding the lock

: argos_admin vacia 127.0.0.1(38634) SELECT waiting root 29071 6468 0 11:56 pts/200:00:00 grep postgres On Tue, Jan 10, 2017 at 11:56 AM, Edmundo Robles <edmu...@sw-argos.com> wrote: > how can i detect and cancel the process?? > > > -- > > --

[GENERAL] i got a process holding the lock

how can i detect and cancel the process?? --

[GENERAL] Why autvacuum is not started?

I have running Postgresql 9.4 and... if i have a table with following configuration: autovacuum_vacuum_scale_factor=0.0, autovacuum_analyze_scale_factor=0.0, autovacuum_vacuum_threshold=1000, autovacuum_analyze_threshold=1000, autovacuum_enabled=true Why autovacuum is not started if the

Re: [GENERAL] Er Data Modeller for PostgreSQL

Maybe visual paradigm could help you, you can reverse and generate the database in postgresql. On Thu, Dec 22, 2016 at 11:50 PM, Günce Kaya wrote: > Hi All, > > I'm looking for an ER Data Modeller tool for postgresql. I use Navicat > Premium for postgresql and the tool

Re: [GENERAL] Disabling inheritance with query.

to the new t2_child On Thu, Dec 22, 2016 at 8:51 AM, Edmundo Robles <edmu...@sw-argos.com> wrote: > I want to do that because, I have a partitioned table (big_table) and > others (t1,t2,t3,t4) have foreign keys reference to big_table and i > had many trobules at ins

Re: [GENERAL] Disabling inheritance with query.

aints) and foreign key constraints only apply to single tables, not to their inheritance children. " On Wed, Dec 21, 2016 at 4:58 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Edmundo Robles <edmu...@sw-argos.com> writes: > > i need disable inheritance from many tables i

[GENERAL] Disabling inheritance with query.

Hi! i need disable inheritance from many tables in a query like "delete from pg_inherits where inhparent=20473" instead alter table ... but is safe? which is the risk for database if i delete it?

[GENERAL] Foreign keys fails with partitioned table.

I have a big,big table, this big table is referenced by another tables by foreign keys. I have a performance issues so i decide partition it by month -> ...,table_201610,table_201611,table_201612,... after i have been created the partition tables i try to insert data but foreign key

[GENERAL] Must I create an index for child table if master table have one?

Hi! i have a simple question, if the master table have an index, must i have create the same index in a child table? what is the best practice for indexes in table partition ?

Re: [GENERAL] Looking for software to 'enqueue' connections

veral servers (multimaster configuration like > https://wiki.postgresql.org/wiki/Bucardo) > > > > Ilya Kazakevich > > > > JetBrains > > http://www.jetbrains.com > > The Drive to Develop > > > > *From:* pgsql-general-ow...@postgresql.org [mailto

[GENERAL] Looking for software to 'enqueue' connections

Hi! I want find a software to 'enqueue' the client connections to database, so if i reach the max limit the query must be holding in a queue until one connection is released. I have many devices (100+) saving their state to a database, each minute, but the table is too large more than

Re: [GENERAL] Error at dynamic generated copy...

don't worry. I still working in this copy, how can i do to insert newlines to generate the copy dynamically and avoid the syntax error. On Fri, Aug 12, 2016 at 11:11 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 08/12/2016 08:15 AM, Edmundo Robles wrote: > >&

Re: [GENERAL] Error at dynamic generated copy...

have more than 13,000,000 records, plus have many indexes, that the reason why is slow to insert That's why i tried to use copy. On Fri, Aug 12, 2016 at 9:43 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 08/12/2016 07:11 AM, Edmundo Robles wrote: > >> Hi! >>

[GENERAL] Error at dynamic generated copy...

Hi! I hope you could help me... I tried to generate the next copy instruction in a function: copy tablefoo (id_foo, foo_name, foo_lastname, foo_age) FROM stdin DELIMITER as '|' ; 12060157|John|Doe|33 \. ** The commands to generate the copy are: CREATE OR REPLACE FUNCTION

[GENERAL] Executing \i of psql command using libpq library

Hi! How can i get the same behavior of psql -c \\i './a_lot_of_sentences' bd user, using the libpq library??? i tried Pqexec(pgconn,\\i './a_lot_of_sentences') but didn't work. :( -- SENSA Control Digital. Ing. Edmundo Robles Lopez. Analista Programador. -- Sent via pgsql-general

[GENERAL] about memory size reported by system.

by that? There is a best way to tweak the memory consumed by postgres? -- SENSA Control Digital. Ing. Edmundo Robles Lopez. Analista Programador. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] why sometimes checkpoint is too slow????

why sometimes checkpoint is too slow and how can i do to avoid that??? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] undefined symbol PQconnectionNeedsPassword referenced by file pg_ctl.o

Hi, i tried to compile postgres 8.3.13 but i got the next error: Undefined first referenced symbol in file PQconnectionNeedsPassword pg_ctl.o ERROR: Symbol referencing errors. No output written to pg_ctl cc -b elf -O pg_ctl.o

[GENERAL] PANIC: ERRORDATA_STACK_SIZE exceeded

hi! i have postgresql 8.3.12 and i got the eror: PANIC: ERRORDATA_STACK_SIZE exceeded This happens after insert 1000 registers on a table every 1 minute during 3 hours. any idea, why this happened??? # - # PostgreSQL configuration file #

[GENERAL] Relation raltion_name with OID ##### no longer exists

Hi ! i have the above error when i tried to insert a register, How can i solve this issue???' regards . -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Question about SCO openserver and postgres...

On 07/22/2010 05:39 PM, Scott Marlowe wrote: On Thu, Jul 22, 2010 at 3:24 PM, Edmundo Robles L. erob...@sensacd.com.mx wrote: Hi! I have a problem with the max postgres connections on SCO Openserver 5.0.7, so ...my boss decided to buy the SCO Openserver 6.0 but this version

[GENERAL] Question about SCO openserver and postgres...

Hi! I have a problem with the max postgres connections on SCO Openserver 5.0.7, so ...my boss decided to buy the SCO Openserver 6.0 but this version comes in 2 editions: Starter and Enterprise. If SCO 5.0.7 only allows 95 ( -3 used by superuser) connections to postgres... Do you

[GENERAL] about scape characters

Hi!, maybe is a silly question but... Exists some syntax standard to escape especial characters on querys??? i mean, the notation E'\\ to escape especial characters only works in postgres (8.3.11) or this works on oracle, ms sql server too??? regards, eddie. -- Sent via pgsql-general

[GENERAL] getting the last N tuples of a query

Hi! if a want the first 5,10,N tuples of a query (even without order) i just have to do a: select * from table limit 10; but, What can i do to get the last 10 tuples ??? i try to do: select * from table limit -10; :-D but that query return 0 tuples . So, what is the right way

[GENERAL] OFFTOPIC -- pgpool list is down?????

Do you know if the pgpool list is down???, i sent many emails to the pgpool list but since last week i can't receive any mail from pgpool list , i checktheir web site too, but the last message are of june. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

[GENERAL] Forcing the use of one index instead other.

. well, thats all for the moment and i appreciate your time in reading this mail!!! See you. -- SENSA Control Digital. Ing. Edmundo Robles Lopez. Analista Programador. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

FW: [GENERAL] lack in psql console

in the psql prompt try this: \! stty sane Ing. Edmundo Robles Lopez. Analista Programador. -- -Original Message- From: pgsql-general-ow...@postgresql.org on behalf of Juan Camilo Marín Sent: Wed 5/13/2009 12:58 PM To: Craig Ringer Cc: pgsql-general@postgresql.org Subject: Re

[GENERAL] how many connections can i use????

Hello there! I have a problem with the number of connections on postgres 7.2.1, yeah is a quite older :-) but i have it running on SCO OpenServer 5.0.7 and tried to change the number of connections above 100 but, i only got 100 sometimes 101 but no more. I changed the parameters

FW: [GENERAL] how many connections can i use????

Edmundo Robles L. erob...@sensacd.com.mx writes: I have a problem with the number of connections on postgres 7.2.1, --egad ... the number of known bugs in that would curl your toes. --Think about an upgrade. Do more than just think about it. yes, maybe the upgrade solve that problem, i