Hello, I have faced with a complicated case of table synchronisation. The full description of the problem (with some figures) is posted here: http://stackoverflow.com/questions/26237661/postgresql-update-table-with-new-records-from-the-same-table-on-remote-server Here it the partial repost of my st
Hi!
also, it generates statement which tries to change all columns to one character
length columns.
Andrus.
From: Andrus
Sent: Monday, October 06, 2014 8:11 PM
To: Melvin Davidson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Converting char to varchar automatically
Hi!
>SELECT '
Hi,
I have the raw fields of a particular row in char * . Now my requirement
is to convert these value into datum * . How should i go about this ? Does
converting into datum depends on the type of the field too ?
-- Harsha
On 10/07/2014 09:10 PM, Stephen Davies wrote:
The permissions on the socket are 777 owner/group postgres.
I installed the 9.3 onto the Centos 7 server using the repo at
postgresql.org.
(http://yum.postgresql.org/9.3/redhat/rhel-$releasever-$basearch)
There is no /var/run/postgresql and find ca
sri harsha writes:
> I have the raw fields of a particular row in char * . Now my requirement
> is to convert these value into datum * . How should i go about this ? Does
> converting into datum depends on the type of the field too ?
Yes. You are probably looking for BuildTupleFromCStrings().
I am currently doing periodic syncs of one of my production databases to my development database using the command pg_dump -ch | psql , run on my development server. This works well enough, but as the size of the production database grows, this command is, for obvious reasons, getting progressive
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
El 08/10/14 a las 14:01, Israel Brewster escibió:
> I am currently doing periodic syncs of one of my production
> databases to my development database using the command pg_dump -ch
> | psql , run on my
> development server. This works well enough
On Tue, Oct 7, 2014 at 12:06 PM, israel wrote:
>
> Thank you all for the advice. It looks like the load is due to a query
> that is taking around 1300ms to complete - a query that is run by every
> client connected (probably half a dozen or so, although I don't have
> specific numbers), every fif
Hi!
Using Toms recommendation I added not attisdropped and now got the query
SELECT 'ALTER TABLE ' || quote_ident(n.nspname) || '.'
|| quote_ident(c.relname)
|| ' ALTER COLUMN ' || quote_ident(a.attname) || ' TYPE
varchar;'
FROM pg_class c
JOIN pg_namespace n ON n.
---Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport Industrial RdFairbanks, AK 99709(907) 450-7293---BEGIN:VCARD
VERSION:3.0
N:Brewster;Israel;;;
FN:Israel Brewster
ORG:Frontier Flying Service;MIS
TITLE
On Oct 8, 2014, at 9:30 AM, Emanuel Calvo wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA512
>
>
>
> El 08/10/14 a las 14:01, Israel Brewster escibió:
>> I am currently doing periodic syncs of one of my production
>> databases to my development database using the command pg_dump -ch
>>
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> so I could easily be over a minute of sync time in another two years.
> I would really rather not have to wait several minutes every time I
> want to update my development data.
A minute is really not that long of a wait, especially given t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
El 08/10/14 a las 17:24, Israel Brewster escibió:
> On Oct 8, 2014, at 9:30 AM, Emanuel Calvo
> wrote:
>
>
>
> El 08/10/14 a las 14:01, Israel Brewster escibió:
I am currently doing periodic syncs of one of my production
databases to
On 10/8/14, 2:24 PM, Israel Brewster wrote:
Agreed. and no, I don't need all the data. But pg_dump doesn't give me an
option to, say, only grab the last week of data.
You might want to check out pg_sample. It lets you get a referentially
consistent sample of a database. You specify the numb
This revised query should give you what you need:
SELECT 'ALTER TABLE ' || quote_ident(n.nspname) || '.'
|| quote_ident(c.relname)
|| ' ALTER COLUMN ' || quote_ident(a.attname) || ' TYPE
varchar(' || i.character_maximum_length || ');'
FROM pg_class c
JOIN pg_namespace
On Wed, Oct 8, 2014 at 12:49 AM, Vitaly Isaev wrote:
> I am trying to figure out how to dump the contents of several selected
> tables from server in order to update the tables on development
> workstations. The biggest challenge is that the tables I'm trying to
> synchronize may be diverged (deve
Hi!
Thank you.
>This revised query should give you what you need:
>SELECT 'ALTER TABLE ' || quote_ident(n.nspname) || '.'
>|| quote_ident(c.relname)
>|| ' ALTER COLUMN ' || quote_ident(a.attname) || ' TYPE varchar('
> || i.character_maximum_length || ');'
> FROM pg_class
There really is no easy way to make a single ALTER for each table unless
you use a programming language. However, adding a
GROUP BY c.relname,
a.attname
would certainly simplify editing. Then you can combine all the
ALTER COLUMN's for each table.
On Wed, Oct 8, 2014 at 6:21 PM,
Hi all. I'm having a database, called "apeland", which at first (when
created) was in the default-tablespace (in $PGDATA), then I moved it with the
commands: # create tablespace apeland location
'/home/andreak/programs/postgresql/9.3.5/tablespaces/apeland'; CREATE TABLESPACE
Check space-us
This is not the same issue.
However, I had already disabled SELinux for other reasons.
The actual cause of my issue was the "new" private tmp facility in systemd
startup of httpd. This makes the PostgreSQL socket invisible to CGI scripts.
We have survived for many years without this before mig
Hi,
Le 9 oct. 2014 01:31, "Andreas Joseph Krogh" a écrit :
>
> Hi all.
>
> I'm having a database, called "apeland", which at first (when created)
was in the default-tablespace (in $PGDATA), then I moved it with the
commands:
>
> # create tablespace apeland location
'/home/andreak/programs/postgre
Hi!
>There really is no easy way to make a single ALTER for each table unless you
>use a programming language.
I’snt SQL a programming language ?
>However, adding a GROUP BY c.relname, a.attname
>would certainly simplify editing. Then you can combine all the
>ALTER COLUMN's f
22 matches
Mail list logo
