Re: [GENERAL] pgdump (9.2.4) not dumping all tables

so i fix it and got it working !!! i followed the best practices of doing the dump with the newest pg_dump version. and now is working thanks everyone for your help -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-not-dumping-all-tables-tp5827736p5827821.html Sent fr

Re: [GENERAL] better architecture?

On 11/20/2014 04:57 PM, zach cruise wrote: On 11/20/14, Adrian Klaver wrote: On 11/20/2014 12:30 PM, zach cruise wrote: For more info see: http://www.postgresql.org/docs/9.3/interactive/continuous-archiving.html to be clear- i change my 2 VMs setup {"1. master (dev) - 2. slave (prod) setup"

Re: [GENERAL] better architecture?

On 11/20/14, Adrian Klaver wrote: > On 11/20/2014 12:30 PM, zach cruise wrote: >>> >>> For more info see: >>> >>> http://www.postgresql.org/docs/9.3/interactive/continuous-archiving.html >> to be clear- i change my 2 VMs setup {"1. master (dev) - 2. slave >> (prod) setup"} to 3 VMs {"1. master (de

Re: [GENERAL] deferring ForeignKey checks when you didn't set a deferrable constraint ?

Try the following queries. It will give you two .sql files (create_fkeys.sql & drop_fkeys.sql). First review them to make sure they look ok. Then execute the drop_fkeys.sql ie: \i drop_fkeys.sql Do your deletes, then rebuild your fk's with \i create_fkeys.sql Good luck. ==

[GENERAL] deferring ForeignKey checks when you didn't set a deferrable constraint ?

I have a core table with tens-of-millions of rows, and need to delete about a million records. There are 21 foreign key checks against this table. Based on the current performance, it would take a few days to make my deletions. None of the constraints were defined as `DEFERRABLE INITIALLY IMM

Re: [GENERAL] better architecture?

On 11/20/2014 12:30 PM, zach cruise wrote: For more info see: http://www.postgresql.org/docs/9.3/interactive/continuous-archiving.html to be clear- i change my 2 VMs setup {"1. master (dev) - 2. slave (prod) setup"} to 3 VMs {"1. master (dev) - 2. slave (prod) setup - 3. archive (wal)"}. but

Re: [GENERAL] better architecture?

On 11/20/14, Adrian Klaver wrote: > On 11/20/2014 11:02 AM, zach cruise wrote: >> On 11/20/14, Adrian Klaver wrote: >>> On 11/20/2014 08:00 AM, zach cruise wrote: combining replies for the list: > >>> Well it would depend on your setup and the load on the master. Assuming >>> streaming

Re: [GENERAL] Transactions to create pg_multixact members and offsets

Dev Kumkar wrote: > On Thu, Nov 20, 2014 at 11:15 PM, Alvaro Herrera > wrote: > > Merely waiting does not, but more than one lock being acquired on a > > tuple does cause a multixact to be created. Try SELECT FOR SHARE on two > > transactions on the same tuple. > > Sure. > Also what if there are

Re: [GENERAL] better architecture?

On 11/20/2014 11:02 AM, zach cruise wrote: On 11/20/14, Adrian Klaver wrote: On 11/20/2014 08:00 AM, zach cruise wrote: combining replies for the list: Well it would depend on your setup and the load on the master. Assuming streaming replication. Simple explanation: yes streaming replica

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

On Thu, 20 Nov 2014 11:52:23 -0700 (MST) Marcos Cano wrote: > i found this in the file... > > ERROR: could not access file "$libdir/rtpostgis-2.0": No such file or > directory > > > which acording to the firs link I found >

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

yes i'd better look at the postgis list.. i thought for one moment that this was encoding related. thanks for your help -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-not-dumping-all-tables-tp5827736p5827760.html Sent from the PostgreSQL - general mailing list archi

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

On 11/20/2014 10:52 AM, Marcos Cano wrote: i found this in the file... What file? Remember the list need context for your statements. You are at the computer and see all that goes on. We only know what you tell us and statements without supporting data are hard to troubleshoot. ERROR: c

Re: [GENERAL] better architecture?

On 11/20/14, Adrian Klaver wrote: > On 11/20/2014 08:00 AM, zach cruise wrote: >> combining replies for the list: >> >> >> On 11/19/14, Charles Zaffery wrote: >>> 2 and 3 can be covered by this: >>> http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster >> does something similar exist for windows?

Re: [GENERAL] Transactions to create pg_multixact members and offsets

On Thu, Nov 20, 2014 at 11:15 PM, Alvaro Herrera wrote: > Search for "burnmulti" in the archives, which is a contrib module to > test pg_multixact. > Thanks, got some links. Will give a try and get back. Merely waiting does not, but more than one lock being acquired on a > tuple does cause a mu

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

i found this in the file... ERROR: could not access file "$libdir/rtpostgis-2.0": No such file or directory which acording to the firs link I found , is a postgis

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

On Thu, 20 Nov 2014 11:25:10 -0700 (MST) Marcos Cano wrote: > i did it again... and the file shows exactly the same lots of : > > invalid command \N > invalid command \N > invalid command \N > invalid command \N > invalid command \N > invalid command \N > invalid command \N > invalid command \N

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

to answer to Adrian 1) i am using the old version to dump (i will try with the latest) 2) no the postgis version is different. pg9.2.4-> postgis-2.0.3 and pg9.3.5-> postgis-2.1.3 3) the schema is public \d+ al_shared_place Table "pu

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

i did it again... and the file shows exactly the same lots of : invalid command \N invalid command \N invalid command \N invalid command \N invalid command \N invalid command \N invalid command \N invalid command \N -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-no

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

On 11/20/2014 10:06 AM, Marcos Cano wrote: might be awkard but there is no file, so i assume 2 things: 1) there was no upgrade errors 2) the script + command is not writing to stderr (i think it is doing it) Aah, meant to add: Is there anything in the Postgres log for the time period of the re

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

On 11/20/2014 10:06 AM, Marcos Cano wrote: might be awkard but there is no file, so i assume 2 things: 1) there was no upgrade errors So to be clear the file below does not exist?: 2>$backup_path/$db_upgrade_errors.txt" or it exists but there is nothing in it? 2) the script + command is

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

On 11/20/2014 09:47 AM, Marcos Cano wrote: hello im trying to dump a complete DB, i've been doing something like this. (i'm in the process of upgrading from 9.2.4 to 9.3.5) my current DB looks like this: Name| Owner | Encoding | Collate | Ctype | Access privileges ---+-

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

might be awkard but there is no file, so i assume 2 things: 1) there was no upgrade errors 2) the script + command is not writing to stderr (i think it is doing it) -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-not-dumping-all-tables-tp5827736p5827739.html Sent

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

Marcos Cano writes: > everything seems to work fine until i noticed that i'm missing 5 tables, Did you look at the error output from the restore to see if there were any complaints? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

[GENERAL] pgdump (9.2.4) not dumping all tables

hello im trying to dump a complete DB, i've been doing something like this. (i'm in the process of upgrading from 9.2.4 to 9.3.5) my current DB looks like this: Name| Owner | Encoding | Collate | Ctype | Access privileges ---+--+---+-+---

Re: [GENERAL] Transactions to create pg_multixact members and offsets

Dev Kumkar wrote: > Hellos, > > How to manually increase pg_multixact members and offsets? Search for "burnmulti" in the archives, which is a contrib module to test pg_multixact. > Does a transaction waiting for exclusive lock or shared lock result into > entry being created in pg_multixact? Me

Re: [GENERAL] better architecture?

On 11/20/2014 08:00 AM, zach cruise wrote: combining replies for the list: On 11/19/14, Charles Zaffery wrote: 2 and 3 can be covered by this: http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster does something similar exist for windows? On 11/20/14, Michael Paquier wrote: On Thu, Nov 20

[GENERAL] Transactions to create pg_multixact members and offsets

Hellos, How to manually increase pg_multixact members and offsets? Does a transaction waiting for exclusive lock or shared lock result into entry being created in pg_multixact? Excerpt of multixact.c: /*- 2 * 3 * multixact

Re: [GENERAL] pgsql_tmp consuming all inodes

On 11/20/2014 08:20 AM, Nestor A. Diaz wrote: Hello People. I have installed a postgres engine: PostgreSQL 8.4.22 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian 4.7.2-5) 4.7.2, 64-bit from debian packages at postgresql official repository running on debian wheezy 7.7 64 bit. I have a

Re: [GENERAL] [sfpug] Linuxfest 2015 Call for Papers

On 11/20/2014 08:21 AM, David Gallagher wrote: Hmm, end of January in Bellingham... Sounds like a great excuse to ski Mt Baker and beyond :D. FYI the Bellingham event is at end of April. Trying to avoid the "Have You Seen Me?" being repeated at Heather Meadows:) -David On Nov 19, 2014, at

Re: [GENERAL] pgsql_tmp consuming all inodes

"Nestor A. Diaz" writes: > I have a couple of databases running on a cluster, and two of them have > been experiencing the following behavior since installed yesterday: > They create a lot of files under directory "pgsql_tmp" up to the point > they consume all the inodes, when I do a 'df -i' I fou

Re: [GENERAL] [sfpug] Linuxfest 2015 Call for Papers

On 11/20/2014 08:21 AM, David Gallagher wrote: Hmm, end of January in Bellingham... Sounds like a great excuse to ski Mt Baker and beyond :D. What I find funny is that Mt. Baker (mtbaker.us) is actually the resorts on Mt. Shuksan. Which is not-arguably more beautiful :D JD -- Command Pro

Re: [GENERAL] [sfpug] Linuxfest 2015 Call for Papers

Hmm, end of January in Bellingham... Sounds like a great excuse to ski Mt Baker and beyond :D. -David > On Nov 19, 2014, at 12:09 PM, Josh Berkus wrote: > > On 11/19/2014 11:57 AM, Adrian Klaver wrote: >> >> So as not to have lost souls wandering around Seattle in April, LFNW is >> actually in

[GENERAL] pgsql_tmp consuming all inodes

Hello People. I have installed a postgres engine: PostgreSQL 8.4.22 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian 4.7.2-5) 4.7.2, 64-bit from debian packages at postgresql official repository running on debian wheezy 7.7 64 bit. I have a couple of databases running on a cluster, and t

Re: [GENERAL] better architecture?

combining replies for the list: On 11/19/14, Charles Zaffery wrote: > 2 and 3 can be covered by this: > http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster does something similar exist for windows? On 11/20/14, Michael Paquier wrote: > On Thu, Nov 20, 2014 at 10:58 AM, zach cruise wrote: >>

Re: [GENERAL] Modeling Friendship Relationships

Robert DiFalco wrote: > I have a question about modeling a mutual relationship. It seems basic but > I can't decide, maybe it is 6 of one a half dozen of the other. > > In my system any user might be friends with another user, that means they > have a reciprocal friend relationship. > > It seems

Re: [GENERAL] better architecture?

On 11/19/2014 05:58 PM, zach cruise wrote: i need some advice: 1. for our small business, i have a master (dev) - slave (prod) setup. i develop using the master. i get data from other people's dev (mssql) databases. i also get data from their prod (mssql) databases. i replicate everything on sla

Re: [GENERAL] Modeling Friendship Relationships

Thanks Jonathan. So in your use case would you put non-approved friend requests in this table as non-reciprocal? If so, did the person requesting friendship get the row in there or the person receiving the friend request? Also, if A and B are friends, and B decided to remove A as a friend, are you

Re: [GENERAL] Performance question

Thanks Adrian On Thu, Nov 20, 2014 at 3:46 AM, Adrian Klaver wrote: > On 11/19/2014 08:26 AM, Anil Menon wrote: > >> Hello, >> >> I would like to ask from your experience which would be the best >> "generic" method for checking if row sets of a certain condition exists >> in a PLPGSQL function.