Hello !
Sorry for delay. Yes there are two version of postgresql 8.4 and 9.1 and
suddenly all begin to work properly. pg_lsclusters output is
Version Cluster Port Status OwnerData directory
Log file
8.4 main 5432 down postgres /var/lib/postgresql/8.4/main
/var/log/postgresql/post
On 21 June 2013 05:08, Tom Lane wrote:
> Melvin Call writes:
> > I was given a dump of an existing remote schema and database, and the
> > restore on my local system failed. Looking into it, I found a circular
> > parent-child/child-parent relationship, and I don't believe this existing
> > stru
Hello.
I think this CAN happen in practice when the constraints are DEFERRED, because
as such are checked at COMMIT time.
HTH,
Ladislav Lenart
On 21.6.2013 05:08, Tom Lane wrote:
> Melvin Call writes:
>> I was given a dump of an existing remote schema and database, and the
>> restore on my lo
Hello,
I have just found this post
http://grokbase.com/t/postgresql/pgsql-hackers/10ces3w9kz/alter-table-replace-with/nested/page/2#responses_tab_top
and it helped a lot
Thanks
From: salah jubeh
To: pgsql
Sent: Thursday, June 20, 2013 5:58 PM
Subject: [
Here is a script for initializing my database
*drop table if exists z;
create table z as select lpad(i::text,6,'0') as name from
generate_series(0,99) as i;
create index z_name on z(name text_pattern_ops);
analyze;
*
So - I have a table z with one column name that has textual index.
Now, I wa
On Thu, 20 Jun 2013 08:58:35 -0700 (PDT)
salah jubeh wrote:
> Hello,
>
>
> I have a database server which do a complex views calculation, the result
> of those views are shipped to another database servers via a simple
> replication tool which have a high client loads.
>
>
> The tool
Hi all,
Can any one give me more suggestion, about this problem. Every time my os
got restart, postmaster.pid is missing. After that createing postmaster.pid
is also not helping to start the server. I am using postgresql 9.2 in
ubuntu, with default installation. Is there any possibility i can tak
>as i know each value is limited to 1GB. For larger content use module lo
>http://www.postgresql.org/docs/9.2/static/lo.html
I just want to know that like DB2 we can convert other data types into
CLOB/BLOB using function CLOB()/BLOB().
Example:
SELECT CLOB('testdata') FROM SYSIBM.SYSDUMMY1
Same
On Fri, Jun 21, 2013 at 7:53 PM, itishree sukla
wrote:
> Hi all,
>
> Can any one give me more suggestion, about this problem. Every time my os
> got restart, postmaster.pid is missing. After that createing postmaster.pid
> is also not helping to start the server. I am using postgresql 9.2 in
> ub
On Fri, Jun 21, 2013 at 9:40 PM, sachin kotwal wrote:
>>as i know each value is limited to 1GB. For larger content use module lo
>>http://www.postgresql.org/docs/9.2/static/lo.html
>
>
> I just want to know that like DB2 we can convert other data types into
> CLOB/BLOB using function CLOB()/BLOB()
Hi Tom,
First an apology of sorts. The restore doesn't fail, but the COPY
statements generate errors about the referenced table not containing the
key values (as you seem to have figured out that I meant). I have no idea
what version of PostgreSQL the remote system is running, I just have the
dump
Hi Ladislav and Alban,
Thanks for the suggestions regarding the DEFERRED constraint. While
certainly a viable option, I would expect the dump to maintain those
constraints. The lack of them indicates to me that somehow an initial
insert was created and then the structure was modified to support th
Melvin Call wrote
> To summarize, the organization entity has an attribute of creator, which
> is a foreign key to the user table, but the user has to belong to an
> organization, which is a foreign key to the organization table. Since
> neither are nullable, there is no way to create even an initi
Chris Angelico wrote
> On Fri, Jun 21, 2013 at 7:36 AM, David Johnston <
> polobo@
> > wrote:
>> SELECT input
>> FROM ( SELECT unnest($1) AS input ) src
>> WHERE input IS NOT NULL AND input <> ''
>> LIMIT 1;
>
> Does this guarantee the order of the results returne
perfect, thanks much
alan
On Jun 20, 2013, at 1:27 AM, Pavel Stehule wrote:
> Hello
>
> I wrote lot of C VARIADIC functions - some examples are in core -
> "format" function
>
> Schema | Name| Result data type | Argument data types | Type
> +---+
Hi all!
I am working on migrating data in a very large database (22TB +) between two
existing tables that use type text for almost every field, to two new tables
that use native data type for dates, integers, etc.
The way I'm doing this is running a series of "Insert into new_table values
(stu
No, as its only one postgresql is running with default installation, server
got restatared with out shuting down postgresql service properly. Then i
tied to start server using ./init.d command, which didn't help me either.
Then i created pstmaster.pid, that also doesn't help me much.
Regards,
Itis
Greetings,
I'm trying to test out the new postgres-fdw support in postgresql-9.3
(beta) in preparation for an upgrade from 9.2 later this year. So
far, everything is working ok, however one problem I'm encountering is
with the COPY command. When I run it against a foreign table (which is
also in a
On 06/21/2013 10:39 AM, Lonni J Friedman wrote:
Greetings,
I'm trying to test out the new postgres-fdw support in postgresql-9.3
(beta) in preparation for an upgrade from 9.2 later this year. So
far, everything is working ok, however one problem I'm encountering is
with the COPY command. When I
On Jun 21, 2013, at 19:21, Natalie Wenz wrote:
> Hi all!
>
> I am working on migrating data in a very large database (22TB +) between two
> existing tables that use type text for almost every field, to two new tables
> that use native data type for dates, integers, etc.
>
> The way I'm doing
On 06/21/2013 10:37 AM, itishree sukla wrote:
No, as its only one postgresql is running with default installation,
server got restatared with out shuting down postgresql service properly.
Then i tied to start server using ./init.d command, which didn't help me
either. Then i created pstmaster.pid
On Jun 21, 2013, at 1:39 PM, Lonni J Friedman wrote:
> Greetings,
> I'm trying to test out the new postgres-fdw support in postgresql-9.3
> (beta) in preparation for an upgrade from 9.2 later this year. So
> far, everything is working ok, however one problem I'm encountering is
> with the COPY
On Jun 21, 2013, at 12:53, itishree sukla wrote:
> Hi all,
>
> Can any one give me more suggestion, about this problem. Every time my os got
> restart, postmaster.pid is missing.
Did you perhaps use reboot instead of shutdown -r? The former doesn't do a
clean shutdown. That's how it is on *B
I was afraid someone would say that. Is this a limitation that might
be removed in the future (like 9.4), or is there a technical reason
why its not possible to do a COPY against a foreign table?
On Fri, Jun 21, 2013 at 10:52 AM, Adrian Klaver wrote:
> On 06/21/2013 10:39 AM, Lonni J Friedman wr
On 06/21/2013 10:56 AM, Lonni J Friedman wrote:
I was afraid someone would say that. Is this a limitation that might
be removed in the future (like 9.4), or is there a technical reason
why its not possible to do a COPY against a foreign table?
Others would have to comment on that. Important t
On Jun 21, 2013, at 1:56 PM, Lonni J Friedman wrote:
> I was afraid someone would say that. Is this a limitation that might
> be removed in the future (like 9.4), or is there a technical reason
> why its not possible to do a COPY against a foreign table?
I think reason is, FDW is a way of repr
I was wondering what is the expected release data for the next PostgreSQL
patch - presumably 9.1.10? Although there is no documentation stating
release timeframes I'd become accustomed to them being released in the first
week of the month every other month.
Thank You
Rob
--
View this message in
On Jun 21, 2013, at 3:38 PM, Lonni J Friedman wrote:
> On Fri, Jun 21, 2013 at 11:17 AM, Vibhor Kumar
> wrote:
>>
>> On Jun 21, 2013, at 2:05 PM, Lonni J Friedman wrote:
>>
>>> On Fri, Jun 21, 2013 at 10:56 AM, Vibhor Kumar
>>> wrote:
On Jun 21, 2013, at 1:39 PM, Lonni J Friedman
I am trying to write a script that will create and populate a
database. I don't want to enter a password every time so I want to
use a .pgpass file. It has the correct permissions:
$ ls -l $PGPASSFILE
-rw--- 1 Stephen staff 43 21 Jun 14:48 /Users/Stephen/.pgpass
However, when I c
On 21/06/2013 23:25, Stephen Rasku wrote:
> I am trying to write a script that will create and populate a
> database. I don't want to enter a password every time so I want to
> use a .pgpass file. It has the correct permissions:
>
> $ ls -l $PGPASSFILE
> -rw--- 1 Stephen staff 43
On 06/21/2013 03:25 PM, Stephen Rasku wrote:
I am trying to write a script that will create and populate a
database. I don't want to enter a password every time so I want to
use a .pgpass file. It has the correct permissions:
$ ls -l $PGPASSFILE
-rw--- 1 Stephen staff 43 21 Ju
On Fri, Jun 21, 2013 at 3:33 PM, Raymond O'Donnell wrote:
>
> What's in your server's pg_hba.conf file?
# TYPE DATABASEUSERCIDR-ADDRESSMETHOD
#@remove-line-for-nolocal@# "local" is for Unix domain socket connections only
local all all
I am trying to write a script that will create and populate a
database. I don't want to enter a password every time so I want to
use a .pgpass file. It has the correct permissions:
$ ls -l $PGPASSFILE
-rw--- 1 Stephen staff 43 21 Jun 14:48 /Users/Stephen/.pgpass
However, when I c
On Fri, Jun 21, 2013 at 3:41 PM, Adrian Klaver wrote:
>
> First are you running the script from the location with .pgpass?
I wasn't but I copied the .pgpass into the local directory and I get
the same results. The correct location is actually in the home
directory.
> Second you are doing a crea
On 06/21/2013 04:29 PM, Stephen Rasku wrote:
On Fri, Jun 21, 2013 at 3:41 PM, Adrian Klaver wrote:
First are you running the script from the location with .pgpass?
I wasn't but I copied the .pgpass into the local directory and I get
the same results. The correct location is actually in the
http://wiki.postgresql.org/images/d/d1/DB2UDB-to-PG.pdf
On 18 June 2013 05:52, sachin kotwal wrote:
> Function in DB2: BLOB() Criteria: Size of character string targeted for cast
> is more than 1GB How can I migrate this function into PostgreSQL with above
> mention criteria.
> __
On 06/21/2013 04:49 PM, Daniel de Oliveira Mantovani wrote:
http://wiki.postgresql.org/images/d/d1/DB2UDB-to-PG.pdf
On 18 June 2013 05:52, sachin kotwal wrote:
Function in DB2: BLOB() Criteria: Size of character string targeted for cast
is more than 1GB How can I migrate this function into P
37 matches
Mail list logo
