Hi all.
I got some error about psql pipeline.
I input the command in shell script below :
"shp2pgsql -d -w -I -s 987987(custom srid) test.shp test | psql -h testhost -d
testdb"
The problem is, when I check the table list and geometry_columns table, that it
doesn't have schema_name "public".
Hi all.
I got some error about psql pipeline.
I input the command in shell script below :
“shp2pgsql –d –w –I –s 987987(custom srid) test.shp test | psql –h testhost –d
testdb”
The problem is, when I check the table list and geometry_columns table, that it
doesn’t have schema_name “publ
On 04/23/11 7:00 AM, Marinos Yannikos wrote:
Hi,
I have a beefy server with 2 SANs, 1 "fast" (A) and 1 "slow" (B) and
1.3TB worth of 8.4.4 databases on A. A needs to be replaced/wiped
completely with as little downtime as possible. It's flash-based and
the modules need to be replaced, so no "
Elliott Prechter writes:
> I have a function which looks like this:
> ...
> declare _object bigint;
> begin
> set _object = insert into object (object_type,name) values
> ('type1','test object');
> insert into ref (object,refname) values (_object,'test object reference');
> end;
> ...
> Howeve
Phil Couling writes:
> I'm looking for a way to extract the data from a PostgreSQL 8.3.14
> database (cluster) that was built using an an ARM/Linux server. The
> problem is that the hardware itself is a brick and the replacement
> hardware will be X86/AMD64.
> Sadly my backups are all copies of
2011/4/24 Phil Couling :
> Hi
>
> I'm looking for a way to extract the data from a PostgreSQL 8.3.14
> database (cluster) that was built using an an ARM/Linux server. The
> problem is that the hardware itself is a brick and the replacement
> hardware will be X86/AMD64.
>
> Sadly my backups are all
Hi
I'm looking for a way to extract the data from a PostgreSQL 8.3.14
database (cluster) that was built using an an ARM/Linux server. The
problem is that the hardware itself is a brick and the replacement
hardware will be X86/AMD64.
Sadly my backups are all copies of the DB files and don't inclu
Hi Marinos,
Il 23/04/11 16:00, Marinos Yannikos ha scritto:
b) set up a PITR slave (warm standby) on the same box, fail over to
it, replace SAN A, then set up a PITR slave on A and fail over to it
eventually
Based on what you said (on a professional basis this would require a
thorough assess
On Saturday, April 23, 2011 3:54:05 pm Elliott Prechter wrote:
> I have a function which looks like this:
>
> ...
> declare _object bigint;
> begin
> set _object = insert into object (object_type,name) values
> ('type1','test object');
> insert into ref (object,refname) values (_object,'test obj
On 23/04/2011 23:54, Elliott Prechter wrote:
I have a function which looks like this:
...
declare _object bigint;
begin
set _object = insert into object (object_type,name) values
('type1','test object');
insert into ref (object,refname) values (_object,'test object reference');
end;
...
However
I have a function which looks like this:
...
declare _object bigint;
begin
set _object = insert into object (object_type,name) values
('type1','test object');
insert into ref (object,refname) values (_object,'test object reference');
end;
...
However I get a syntax error on the line 'set _obj
11 matches
Mail list logo
