Re: [SQL] [ADMIN] pg_dump : no tables were found.

2012-03-07 Thread Julien Rouhaud
On Tue, Mar 6, 2012 at 7:22 AM, Piyush Lenka wrote: > Hi, > > I m trying to take backup of data of a particular table using pg_dump. > I used double quotes for table name but output is : > pg_dump : no tables were found. > > Command used : > -h localhost -p 5432 -U postgres -W -F p -a -t '"TestTa

[SQL] Re-Sync Stand By Server

2012-03-07 Thread Adam Cornett
I have 2 identical machines, (Ubuntu 10.04 LTS running 9.1.2 from Martin Pitt's PPA) setup with streaming asynchronous replication. Recently I had to take the standby down for some extended maintenance, and when it came back up it was waiting for a WAL segment that had since been removed from the p

[SQL] Type Ahead Issue

2012-03-07 Thread Carlos Mennens
I don't know if this is an issue with my client (Psql) or if it's something I'm doing wrong but I've noticed this issue before and can't figure it out. When I'm using the psql client, I really rely on the tab / type ahead auto completion. When I run my command on one single line, it works fine but

Re: [SQL] Type Ahead Issue

2012-03-07 Thread Tom Lane
Carlos Mennens writes: > Am I missing something here? When the command is on one line, auto > complete works fine but when I break it up as show above in the 2nd > example, it acts like 'COLUMN' isn't even a valid option but if I > manually type the word 'COLUMN' and finish the command, it works.

Re: [SQL] map row in one table with random row in another table

2012-03-07 Thread Igor Neyman
> -Original Message- > From: rverghese [mailto:ri...@hotmail.com] > Sent: Tuesday, March 06, 2012 4:01 PM > To: pgsql-sql@postgresql.org > Subject: map row in one table with random row in another table > > Hi, I am trying to map every row in one table with a random row in > another. > So f

Re: [SQL] map row in one table with random row in another table

2012-03-07 Thread rverghese
That's cool, thanks! Yeah I just want to create some test data, so it's not something I would run often. -- View this message in context: http://postgresql.1045698.n5.nabble.com/map-row-in-one-table-with-random-row-in-another-table-tp5542231p5545510.html Sent from the PostgreSQL - sql mailing li