On 10/25/12 11:46 AM, Boris Epstein wrote:
At this point I tried to just move the directory and use a soft link
to repoint to it - but so far I have not even been able to do that
properly, using pg_ctl. Apparently the process would not die. What
should I look into to debug this one?
try the
On 25 October 2012 19:46, Boris Epstein wrote:
> And if I want to split the storage - i.e., put databases into different
> directories - can I do that?
Take a look at the tablespace feature:
http://www.postgresql.org/docs/current/static/sql-createtablespace.html
You can move existing tables wit
You can try this one:
http://code.google.com/p/hisql/
then JMyETL1.0.6
--
Thanks&Regards,
Xiong He
-- Original --
From: "Martin Gainty";
Date: Thu, Oct 25, 2012 10:18 PM
To: "jose.soares";
"pgsql-general@postgresql.org";
Subject:
Hello listmates,
I am trying to move the data directory for this PG installation. So one
question would be, how do I do that? What's the accepted practice?
And if I want to split the storage - i.e., put databases into different
directories - can I do that?
At this point I tried to just move the
On 25/10/12 19:45, Raymond O'Donnell wrote:
> On 25/10/2012 16:32, Linos wrote:
>> Hello,
>> there is some way to get and old integer primary key column to show the
>> "type"
>> serial at table description?
>>
>> I had a table like this:
>>
>> CREATE TABLE test
>> (
>> test_id integer NOT N
On 25/10/2012 16:32, Linos wrote:
> Hello,
> there is some way to get and old integer primary key column to show the
> "type"
> serial at table description?
>
> I had a table like this:
>
> CREATE TABLE test
> (
> test_id integer NOT NULL,
> CONSTRAINT test_pkey PRIMARY KEY (test_id),
On 25/10/12 17:39, Tom Lane wrote:
> Linos writes:
>> there is some way to get and old integer primary key column to show the
>> "type"
>> serial at table description?
>
> No, because there is no such type. "serial" is just a convenient macro
> that you can use in CREATE TABLE; it's not a
Linos writes:
> there is some way to get and old integer primary key column to show the
> "type"
> serial at table description?
No, because there is no such type. "serial" is just a convenient macro
that you can use in CREATE TABLE; it's not a real type.
regards,
Hello,
there is some way to get and old integer primary key column to show the
"type"
serial at table description?
I had a table like this:
CREATE TABLE test
(
test_id integer NOT NULL,
CONSTRAINT test_pkey PRIMARY KEY (test_id),
);
that i would like to see as:
CREATE TABLE test
(
squirrel
http://www.squirrelsql.org/index.php?page=plugins
Saludos desde EEUU
Martin
__
Porfavor ..no altere o interrumptir esta communicacion
> Date: Thu, 25 Oct 2012 15:50:08 +0200
> From: jose.soa...@sferacarta.com
> To: pgsql-general@postgresql.
On 25 October 2012 15:50, jo wrote:
> Hi all,
>
> I'm working with same db schema in PostgreSQL and Oracle,
> We mainly work in PostgreSQL but sometimes we need to copy schema and data
> from pg to oracle
> because some our customers want to use oracle instead of pg.
That sounds like a job for an
Hi all,
I'm working with same db schema in PostgreSQL and Oracle,
We mainly work in PostgreSQL but sometimes we need to copy schema and
data from pg to oracle
because some our customers want to use oracle instead of pg.
Thus I'm looking for some linux script to migrate from pg to oracle.
At th
Murray Cumming writes:
> I hoped that if I didn't use "local" in my pg_hba.conf file, instead
> using just "host", then postgresql might not allow unix socket
> connections at all, so it wouldn't need to create that .lock file.
> http://www.postgresql.org/docs/9.2/static/auth-pg-hba-conf.html
> B
Am 22.10.2012 22:34, schrieb Martijn van Oosterhout:
Something that has worked for me in the past is:
$ SELECT ctid FROM table WHERE length(field) < 0;
As the structure of the tables (about four were affected) isn't
something that I wanted to actually look at, I set off writing a small
scrip
I'd like to avoid having to specify the unix socket directory when
starting local instances of postgres, due to the new restrictions on the
characters that can be in its path
http://archives.postgresql.org/pgsql-bugs/2012-09/msg00012.php
(only partly solved by a recent commit):
This needs to be sp
Hi,
I'm using Dell DVD store for training purposes, and I met some problems
with it!
Once they are corrected it works well (except the load test config on my
environment, problem encountered with a RSA fingerprint!)
The following slideshow tracks down the problems:
http://jkshah.blogspot.fr/2012/
>Have a look a Benerator. It can create quite reasonable test data (e.g. valid
>addresses, "real" looking names and so on).
>
>It has a bit steep learning curve, but I'm quite happy with the results
>http://databene.org/databene-benerator
>
>
>Another option might be the Dell DVD Store Loadtest:
>h
17 matches
Mail list logo
